Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press

GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press

3h 12mBeginner2025-02-03

Authors

Microsoft Press

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal