Good day,
AI can write all of your formulas in Excel now, and it does a pretty darn good job at it.
This week's tutorial shows you 5 great ways to work with formulas using the new Copilot Edit mode in Excel.
AI News & More from TeachExcel
I made a new YouTube channel that focuses only on AI related news, updates, and how to's. If you're interested in AI, check it out here.
(This is separate from our main TeachExcel channel and will be commentary heavy.)
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Video: Talk to Your Worksheets in Excel
Understand Complex Formulas Without AI
You don't always need AI to figure out what a complex Excel formula is doing.
Excel has a built-in tool called Evaluate Formula that lets you watch a formula calculate one step at a time.
How to Use Evaluate Formula
Select the cell that contains the formula.
Go to the Formulas tab.
Click Evaluate Formula.
Click Evaluate to walk through the formula one piece at a time.
For example, with a formula like this:
=IF(A2>100,SUM(B2:B10),AVERAGE(B2:B10))
Excel will show you each part of the calculation and the value it produces before moving to the next step.
Why This Is Useful
Understand formulas created by someone else.
Find the part of a formula that is causing the wrong result.
Learn how Excel calculates nested formulas.
Debug formulas before asking Copilot or another AI tool for help.
Check out this week's tutorial to see how Copilot can help build, fix, explain, modernize, and speed up Excel formulas.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don