100x Your Excel Skills with ChatGPT

Learn how to automate Excel using ChatGPT. This tutorial shows how to create simple and advanced formulas, run advanced lookups, apply conditional formatting, build pivot tables, and generate charts. Get the demo data from the video: https://landing.andersjensen.org/5SNbSd Complete ChatGPT Course: https://youtube.com/playlist?list=PLXXz88_TPiHql3G2AoQ5_Ve8HRBUdX82w&si=rRmWdLRG5MVXdXF6 You will also see how to write VBA scripts and use Office Scripts to pull live data from an API. We work on a realistic sales dataset for clear, repeatable results. Every step is guided by short prompts you can reuse. No coding is required. You will learn practical patterns that speed up analysis and reporting. TOP LEARNINGS 🔹 Build formulas and advanced lookups 🔹 Use ChatGPT for conditional formatting, pivot tables, and charts 🔹 Combine Excel, VBA, and Office Scripts to automate and connect API data By the end of this video, you will use ChatGPT to write simple and advanced formulas, run lookups, apply conditional formatting, build pivot tables and charts, send an email with VBA, and pull live currency rates with Office Scripts. You will be able to turn plain data into clear results much faster in Excel. TIMESTAMPS 00:00 Fetch online data 03:22 Prepare ChatGPT 05:23 Data insights 06:45 Simple and advanced formulas 15:18 Conditional formatting 18:48 Charts and pivot tables 22:37 VBA 27:54 Advanced Office Script