HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Learn ChatGPT with Excel to enhance productivity, and leverage AI for smarter business decisions.
Overview:
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.
About the Instructor:
Alan Murray is a Microsoft MVP and Excel trainer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. He runs his own blog - Computergaga (https://computergaga.com) and writes for multiple other publications. His YouTube channel has over 670 videos and over 50 million views. Alan also organizes a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each others company (https://www.meetup.com/London-Excel-Meetup-Group/).
Skill Level:
Learn How To:
Course requirement:
Who Should Take This Course:
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
Learn ChatGPT with Excel to enhance productivity, and leverage AI for smarter business decisions.
Overview:
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.
About the Instructor:
Alan Murray is a Microsoft MVP and Excel trainer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. He runs his own blog - Computergaga (https://computergaga.com) and writes for multiple other publications. His YouTube channel has over 670 videos and over 50 million views. Alan also organizes a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each others company (https://www.meetup.com/London-Excel-Meetup-Group/).
Skill Level:
Learn How To:
Course requirement:
Who Should Take This Course:
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
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.
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
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.