GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press
3h 12mBeginner2025-02-03
Authors

Microsoft Press
Microsoft
Course details
Microsoft Excel, enhanced by AI, becomes an even more powerful tool for not only organizing and visualizing data but also offering predictive insights and suggestions for users. In this course designed by Microsoft Press, instructor Alan Murray demonstrates the foundational skills and knowledge required to successfully leverage ChatGPT within Microsoft Excel. Transform the way you interact with Excel data using ChatGPT to automate tasks, generate insights, enhance data manipulation processes, and more. Alan begins by covering the basics of setting up ChatGPT and using it for various Excel functions, before showing you how to implement more advanced techniques to streamline workflows and derive actionable insights from your data. By the end of this course, you’ll be equipped with the skills you need to harness the power of ChatGPT for everyday Excel tasks.
Skills covered
ChatGPTOpenAISpreadsheetsMicrosoft ExcelAI Productivity ToolsBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - ChatGPT with Excel - Introduction
1. Fundamentals of ChatGPT with Excel
- 02 - Learning objectives
- 03 - Outline ChatGPT and its applications in Excel
- 04 - Set up ChatGPT
- 05 - Understand the different ChatGPT models and their capabilities
- 06 - Learn the ChatGPT interface
- 07 - Use ChatGPT as a search engine for Excel skills
- 08 - Exercise - Excel problem solving with ChatGPT
2. Excel Formulas and ChatGPT
- 09 - Learning objectives
- 10 - Write simple formulas with ChatGPT
- 11 - Write lookup formulas with ChatGPT
- 12 - Prompt ChatGPT to explain a complex Excel formula
- 13 - Fix and debug Excel formulas with ChatGPT
- 14 - Exercise - Write formulas with ChatGPT
3. Data Preparation and Cleaning with ChatGPT
- 15 - Learning objectives
- 16 - Transform messy Excel data
- 17 - Extract data from a PDF to Excel
- 18 - Export data from an image to Excel
- 19 - Perform more advanced data transformations
- 20 - Use ChatGPT and Power Query to automate data preparation
- 21 - Exercise - Clean and transform data with ChatGPT
4. Data Analysis with ChatGPT and Excel
- 22 - Learning objectives
- 23 - Gather insights on Excel data
- 24 - Perform descriptive analytics with ChatGPT
- 25 - Perform sentiment analysis with ChatGPT for Excel
- 26 - Create charts with ChatGPT
- 27 - Enhance charts easily with natural language questions
- 28 - Interpret charts with ChatGPT
- 29 - Exercise - Deliver data insights with ChatGPT
Conclusion
- 30 - ChatGPT with Excel - Summary