Latest YouTube Tutorial

I use this one trick to get Copilot to actually work in Excel

It finally works!

Watch on YouTube Download the File
New videos weekly • 750+ tutorials

Get Weekly Tips Delivered Straight to Your Email

Access Courses Through Our New Platform

We've created a streamlined course platform for easier browsing and purchasing. Access all Excel training courses with a simpler checkout process and better course management.

  • Download course videos for offline viewing
  • Pay with Credit Card, PayPal, Klarna, and more
  • Current course owners get free access - contact us!
Visit Course Platform

Latest Forum Posts

Sum columns in listbox on userform
Jul 12, '26 at 11:46 am
Answers: 0
Count blank cell in column until it get to a cell with value
Jun 12, '26 at 9:22 am
Answers: 1
Sumifs single and Mutiple criteria
Jun 4, '26 at 6:42 pm
Answers: 1
Userform textbox update
May 29, '26 at 2:33 am
Answers: 1
#SPILL! error in LET() function despite good array return
May 1, '26 at 7:27 pm
Answers: 0
Downloading file from TeachExcel
Mar 26, '26 at 8:47 pm
Answers: 0
entering new data code gives incorrctly result
Mar 7, '26 at 8:04 am
Answers: 0

Free Excel Training!

Help me create the best free Excel training experience on the web!

Today, I launch the Requested Tutorials feature that you can see below. Using this feature, I want to work with you to create the content that you want.

We start-off with a brand new course for UserForms in Excel. The goal is to create an expectional training guide for building UserForms in Excel so that you never have to pay to learn this material.

View the UserForms course outline in this blog post and feel free to leave your feedback there.

I need your help to create the content, and I look forward to working with you in a collaborative manner in order to create an extensive, open, and free learning experience for everyone!

Sign-in to your account today and submit a tutorial! :)

(Blog post about our future and how we want to work with you to create the best possible learning experience.)

Don


Featured Excel Content

Stop a Macro from Running in Excel
Excel Tip
How to stop a macro from running after it has started. This method uses the keyboard and has nothing to do with the programming of the macro. If the Macro is simply in a continuous loop or is running for too long you can use one of these keyboard shortcuts to kill it: Esc hit the Escape key. Ctrl + Break hit Ctrl key and then the break key, which ...
View Excel Tip
 
Loop through a Range of Cells in Excel VBA/Macros
Excel Tip
How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or a combination of both. This is for when you need to look into each cell or do something with each cell in a range; if you just need to search for a piece of data within a range, use the Find method (link coming soon). Sections: How to Loop Through a Range of C ...
View Excel Tip
 
Complex Structured References (Table Formulas) in Excel
Excel Tip
How to use complex structured references, table formulas, in Excel. If you don't already understand how structured references work or what they do, please read our tutorial on that: using formulas with tables in Excel. Note: the examples below will show you how to make the references but won't necessarily show you useful real world examples. This ...
View Excel Tip
 
Using Formulas with Tables in Excel
Excel Tip
Easy way to reference data tables and make formulas within a data table. This allows you to create formulas that apply to the entire table, copy easily, and are more robust than traditional formulas; these are called structured references. First, make sure your data is formatted as a table; if it's not, read this tutorial on how to create and mana ...
View Excel Tip
 
Remove Table Format in Excel
Excel Tip
Convert a table back into a regular set of cells.  This removes any automated table features and I'll show you how to quickly remove the visual formatting as well. Oddly enough, this isn't as straightforward as it seems like it should be. Steps to Remove a Table Format Select a cell anywhere in the table. Go to the Design tab that should appear w ...
View Excel Tip
 
Use a Form to Enter Data into a Table in Excel
Excel Tip
You can enter data into a table in Excel using a form; here I'll show you how to do that. This is a great feature that makes it more difficult for someone to mess-up entering data into a table.  However, it is not easily accessible. Steps to use a Form to Enter Data into a Table This feature is actually hidden in Excel, so first we need to access ...
View Excel Tip
 
Dynamic Charts in Excel - The Easy Way
Excel Tip
How to create dynamic charts that update automatically when new data is added to Excel. This works with adding new rows and new columns of data to the table. This method uses the table feature in Excel and is very easy to do. Select the data that you want to chart or just select a cell within that data.  Go to the Insert tab and click Table.  Yo ...
View Excel Tip
 
Create and Manage Tables in Excel
Excel Tip
Here, I'll show you everything you need to know to get started using tables in Excel; how to create, edit, and manage them. A table is a special configuration that allows you to manipulate and analyze your data with maximum efficiency. Converting your data set into a table allows you to quickly format, sort, filter, sum, and analyze the data. Sect ...
View Excel Tip
 
Get a Table Look with Only the Formatting in Excel
Excel Tip
How to get the nice formatting of a table without turning your data into an actual table. Formatting data as a table gives you nice banded rows and makes your data much easier to read and analyze. Steps to Get the Table Look Select anywhere in your data table or select the entire data table and then hit Ctrl + T or go to the Insert tab and click T ...
View Excel Tip
 
Center Titles Across Multiple Cells in Excel
Excel Tip
How to center a title across multiple cells in Excel in order to make good looking titles for your spreadsheets. Select the cells in which you want to center text. Go to the Home tab and click the button Merge & Center Your title will now look like this: If you only selected one row of cells to merge, skip to Step 5. Since we selected multiple ...
View Excel Tip