Never Write a Formula in Excel Again, Ever

Download Project Files
Author: | Edits: don

In this video, I'll show you 5 practical ways Microsoft Excel Copilot AI can help you build, fix, understand, modernize, and optimize formulas using plain English.

Whether you're dealing with a formula you inherited from someone else, trying to create a complex formula from scratch, or looking for ways to speed up a slow workbook, Copilot can often do the hard work for you.

In this tutorial you'll learn how to use Copilot AI to:

  • Explain complex formulas in plain English
  • Fix broken formulas and identify common errors
  • Build formulas from simple prompts
  • Convert old formulas into modern Excel functions
  • Speed up slow formulas and improve workbook performance

Examples include:

  • Understanding nested IF formulas
  • Troubleshooting VLOOKUP errors • Creating SUMIFS formulas with AI
  • Using LET() to make more advanced formulas with AI
  • Replacing slow SUMPRODUCT formulas with faster alternatives

If you'd like to learn more about automating Excel, check our Excel Automation Courses.

I hope you enjoy the video! :)

Don

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)


Excel Version: Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Hide Formulas in Excel
Tutorial: How to hide a formula in Excel so that a user cannot see it, select it, or change it - th...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Show All Formulas in a Worksheet in Excel
Tutorial: Display all formulas instead of their output values. This allows you to quickly troubles...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Tutorial Details
Excel Version: Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course