ChatGPT with Excel: Leverage ChatGPT for Data Success (Video)

Learn ChatGPT with Excel to enhance productivity, and leverage AI for smarter business decisions.

ChatGPT, Open AI's chatbot launched in Nov 2022, is the most popular AI in the market. It can assist in automating tasks, generating insights, and enhancing data manipulation processes. As data-driven decision-making becomes more prevalent, the ability to use AI tools like ChatGPT within Excel is a game-changer. More than 100 million people across 185 countries use ChatGPT weekly to learn something new.

This course is designed to empower learners with the skills to integrate ChatGPT within Microsoft Excel, transforming the way they interact with data. It covers the basics of setting up ChatGPT, using it for various Excel tasks, and implementing advanced techniques to streamline workflows and derive actionable insights from data. By the end of this course, participants will have a deep understanding of how to harness the power of ChatGPT in their daily Excel tasks.

Skill Level:

• Beginner

Learn How To:

• Speed-up performance of daily Excel tasks with ChatGPT
• Use ChatGPT as your new search engine
• Import data from images and PDF files into Excel using ChatGPT
• Use ChatGPT to write, explain, and help fix complex Excel formulas
• Create any chart with ChatGPT and enhance it with natural language
• Use ChatGPT to generate insights and perform data analysis

Course requirement:

• Prerequisite: Basic to intermediate knowledge of Excel and some familiarity with Excel functions and formulas.

Who Should Take This Course:

• Job titles: Data Analysts, Accountants, Business Analysts, Developers

About Pearson Video Training:

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more.  Learn more about Pearson Video training at  http://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.

Table of Contents

Introduction

Lesson 1: Fundamentals of ChatGPT with Excel (40 minutes)

Learning Objectives

1.1 Outline ChatGPT and Its Applications in Excel

1.2 Set Up ChatGPT

1.3 Understand the Different ChatGPT Models and Their Capabilities

1.4 Learn the ChatGPT Interface

1.5 Use ChatGPT as a Search Engine for Excel Skills

1.6 Exercise: Excel Problem Solving with ChatGPT

Lesson 2: Excel Formulas and ChatGPT (50 minutes)

Learning Objectives

2.1 Write Simple Formulas with ChatGPT

2.2 Write Lookup Formulas with ChatGPT

2.3 Prompt ChatGPT to Explain a Complex Excel Formula

2.4 Fix and Debug Excel Formulas with ChatGPT

2.5 Exercise: Write Formulas with ChatGPT

Lesson 3: Data Preparation and Cleaning with ChatGPT (50 minutes)

Learning Objectives

3.2 Transform Messy Excel Data

3.3 Extract Data from a PDF to Excel

3.4 Export Data from an Image to Excel

3.5 Perform More Advanced Data Transformations

3.6 Use ChatGPT and Power Query to Automate Data Preparation

3.7 Exercise: Clean and Transform Data with ChatGPT

Lesson 4: Data Analysis with ChatGPT and Excel (60 minutes)

Learning Objectives

4.1 Gather Insights on Excel Data

4.2 Perform Descriptive Analytics with ChatGPT

4.3 Perform Sentiment Analysis with ChatGPT for Excel

4.4 Create Charts with ChatGPT

4.5 Enhance Charts Easily with Natural Language Questions

4.6 Interpret Charts with ChatGPT

4.7 Exercise: Deliver Data Insights with ChatGPT

Summary

If you find an error, you can report it to us through our Submit errata page.