Uploaded December 2025 | Updated November 2026, 5 minutes ago
My boss wanted to add "AI" to our data. So, I made an offline GPT to analyse our budget data and present insights. In this video, let me share the Excel GPT and how I built it.
0:00 - Why I made offline ChatGPT with Excel
1:45 - Chapter 1 - Demo of my offline chatgpt in Excel
3:07 - Chapter 2 - How I made the offline ChatGPT with Excel formulas
8:17 - Chapter 3 - Closer look at the Excel formula
10:26 - Chapter 4 - The end result
11:29 - Chapter 5 - But what if you can't write Excel formulas π€·ββοΈπ€·ββοΈ
π Demo file: chandoo.org/wp/wp-content/uploads/2025/12/excel-gpt.xlsx
Advanced Formula Editor (AFE) for Excel - techcommunity.microsoft.com/blog/excelblog/advanced-formula-environment-is-becoming-excel-labs-a-microsoft-garage-project/3736518
Learn more:
Excel Pivot Tables youtu.be/aofsdpjvK7w
Excel Formulas youtu.be/dVJFyqI_Nw4
Built- in AI features of Excel (no need for ChatGPT) - youtu.be/xGqH__hLVcU
My Excel Course:
Learn Excel properly and elevate your presence at work with my award-winning Excel School program - chandoo.org/wp/excel-school-program
#chatgpt #excel
My boss wanted to add "AI" to our data. So, I made an offline GPT to analyse our budget data and present insights. In this video, let me share the Excel GPT and how I built it.
0:00 - Why I made offline ChatGPT with Excel
1:45 - Chapter 1 - Demo of my offline chatgpt in Excel
3:07 - Chapter 2 - How I made the offline ChatGPT with Excel formulas
8:17 - Chapter 3 - Closer look at the Excel formula
10:26 - Chapter 4 - The end result
11:29 - Chapter 5 - But what if you can't write Excel formulas π€·ββοΈπ€·ββοΈ
π Demo file: chandoo.org/wp/wp-content/uploads/2025/12/excel-gpt.xlsx
Advanced Formula Editor (AFE) for Excel - techcommunity.microsoft.com/blog/excelblog/advanced-formula-environment-is-becoming-excel-labs-a-microsoft-garage-project/3736518
Learn more:
Excel Pivot Tables youtu.be/aofsdpjvK7w
Excel Formulas youtu.be/dVJFyqI_Nw4
Built- in AI features of Excel (no need for ChatGPT) - youtu.be/xGqH__hLVcU
My Excel Course:
Learn Excel properly and elevate your presence at work with my award-winning Excel School program - chandoo.org/wp/excel-school-program
#chatgpt #excel


![Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]
Its hot π₯΅ its coldπ₯Ά, its just a dashboard that is bold
In this video, let me share 3 powerful and amazing ways to create heatmaps in Excel. We can use them to visualize matrix (pivot) style data for dashboards or MIS reports.
In the video:
0:00 - Introduction to Excel Heatmaps
0:24 - Heatmap 1 using Conditional Formatting
3:16 - Heatmap 2 using Images in Cell
9:34 - Heatmap 3 using bubble chart in Excel
15:29 - In conclusion
You will also learn how to use new PIVOTBY function in the video.
Sample file: https://chandoo.org/wp/wp-content/uploads/2026/08/heatmap-3-ways-demo.xlsx
Related videos:
Map chart in Excel - https://youtu.be/qNNn5uiZxOE
Variance chart in Excel - https://youtu.be/REpNnsdHxlY
Dynamic chart with Check boxes - https://youtu.be/L3WFN0bGv8I
How to add avg. line to Excel charts - https://youtu.be/S2RRGqR_MNw
#Excel #dashboards #dataanalytics Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]](https://i.ytimg.com/vi/Q3oqqYQz2gM/mqdefault.jpg)







