Uploaded May 2024 | Updated November 2026, 3 hours ago
AI tools like ChatGPT are great for enhancing your Excel skills. In this video, I present 7 tactics I use to 10x my Excel formula skills.
1οΈβ£ Asking AI for the formula
2οΈβ£ Explain it to me
3οΈβ£ Alternatives
4οΈβ£ Debug the formula with AI
5οΈβ£ Give me clues
6οΈβ£Test my skills
7οΈβ£ Critique my approach
π Download sample data file
=========================
Grab the sample data file from here chandoo.org/wp/wp-content/uploads/2024/05/AI-formulas.xlsx
π Video topics:
==============
0:00 - Using AI to improve your Excel skills
0:25 - The data and setup
1:24 - The first tactic - asking AI to do the work for you
2:58 - Asking for Explanations
5:31 - Proof that AI can't do everything
6:01 - AI to make a few alternatives
7:17 - Debugging the problems with ChatGPT
9:00 - Going to the next level - truly improving your skills
9:50 - Getting AI to give you clues
11:55 - Asking ChatGPT to test your knowledge
13:09 - Using AI to critique your approach
15:26 - How to use CoPilot to build things for you in Excel?
π€ MORE AI Videos
=================
Need to understand how AI will impact data analysis work? Check out these videos and rocket your skills.
10x your productivity with these AI tools in Excel - youtu.be/xGqH__hLVcU
Using CoPilot with Excel - youtu.be/z_cZ9HZbNrQ
ChatGPT made this dashboard - youtu.be/mp18miYmmJY
Using AI to write DAX for me - youtu.be/mPCDJag-6Zg
AI + Data - the playlist - youtube.com/playlist?list=PLmejDGrsgFyBh9sO5sD_PY9nZblKjfFX5
π»π‘ Full Excel Course
===================
Join my Excel School program and become a spreadsheet guru. Go here for all the details - chandoo.org/wp/excel-school-program
~
#chatgpt #ai #excel
~
What does an Excel nerd tell the barber...? β
I need a shortcut π
AI tools like ChatGPT are great for enhancing your Excel skills. In this video, I present 7 tactics I use to 10x my Excel formula skills.
1οΈβ£ Asking AI for the formula
2οΈβ£ Explain it to me
3οΈβ£ Alternatives
4οΈβ£ Debug the formula with AI
5οΈβ£ Give me clues
6οΈβ£Test my skills
7οΈβ£ Critique my approach
π Download sample data file
=========================
Grab the sample data file from here chandoo.org/wp/wp-content/uploads/2024/05/AI-formulas.xlsx
π Video topics:
==============
0:00 - Using AI to improve your Excel skills
0:25 - The data and setup
1:24 - The first tactic - asking AI to do the work for you
2:58 - Asking for Explanations
5:31 - Proof that AI can't do everything
6:01 - AI to make a few alternatives
7:17 - Debugging the problems with ChatGPT
9:00 - Going to the next level - truly improving your skills
9:50 - Getting AI to give you clues
11:55 - Asking ChatGPT to test your knowledge
13:09 - Using AI to critique your approach
15:26 - How to use CoPilot to build things for you in Excel?
π€ MORE AI Videos
=================
Need to understand how AI will impact data analysis work? Check out these videos and rocket your skills.
10x your productivity with these AI tools in Excel - youtu.be/xGqH__hLVcU
Using CoPilot with Excel - youtu.be/z_cZ9HZbNrQ
ChatGPT made this dashboard - youtu.be/mp18miYmmJY
Using AI to write DAX for me - youtu.be/mPCDJag-6Zg
AI + Data - the playlist - youtube.com/playlist?list=PLmejDGrsgFyBh9sO5sD_PY9nZblKjfFX5
π»π‘ Full Excel Course
===================
Join my Excel School program and become a spreadsheet guru. Go here for all the details - chandoo.org/wp/excel-school-program
~
#chatgpt #ai #excel
~
What does an Excel nerd tell the barber...? β
I need a shortcut π
![How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]
Power BIs new Visual Calculation feature allows us to do advanced business logic and analytics without the need for complicated (and often messy) DAX. In this video let me demonstrate the power of visual calculations with a cool month on month comparison chart.
Learn how to build report and perform data analysis from scratch, making your data visualization more impactful.
In the video:
0:00 - Demo of Visual Calculation driven sales report
0:25 - Data model for the report
0:50 - Creating the line chart
1:50 - Creating your first visual calculation in Power BI
3:40 - Converting the line to combination chart
4:30 - Fixing the first value in the chart (to blank)
6:15 - Dynamic coloring of columns - positive is green, negative is red
7:40 - Adjusting the axis scaling issues (advanced concept)
9:30 - Adding Axis Max as a measure for dynamic axis scaling
#powerbi #visualcalcs How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]](https://i.ytimg.com/vi/FCAWIHlknQI/mqdefault.jpg)









