Register your product to gain access to bonus material or receive a coupon.
Video accessible from your Account page after purchase.
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:
Learn How To:
Course requirement:
Who Should Take This Course:
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.
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