Latest YouTube Tutorial

Build a Drag-&-Drop Dashboard in Excel that Auto-Updates (Professional Edition)

Build a self-updating dashboard that automatically combines multiple CSV files from a folder, cleans messy data, and updates your charts with one click.

Watch on YouTube Download the File
New videos weekly • 250+ 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

#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
HELP WITH A FRUSTRATING EXCEL PROBLEM
Feb 14, '26 at 2:21 am
Answers: 1
Toggle Symbol In a Cell by a single Click
Feb 7, '26 at 4:50 pm
Answers: 1
Error 1004 with lookup.
Jan 16, '26 at 10:53 am
Answers: 1
Why am I getting error 91 with "Sheets(ws).Range("g2") = foundCell.Address"
Jan 12, '26 at 7:41 pm
Answers: 1

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

Make All Numbers in a List Positive in Excel
Excel Tip
Take a list of numbers and make them all positive, regardless of whether the list contains a mixed set of positive and negative numbers, only negative numbers, or only positive numbers. In other words, this method can be applied to an entire list, without knowing that every number in that list is negative, and still get only positive values return ...
View Excel Tip
 
Count the Number of Cells that Start or End with Specific Text in Excel
Excel Tip
How to count cells that match text at the start or the end of a string in Excel. If you want a fuller explanation of counting cells that match a string, you can view our other tutorial on counting the number of cells that contain specific text in excel. Sections: Steps to Count Cells that Contain Specific Text at the Start or the End of the Cell Us ...
View Excel Tip
 
Get the Row or Column Number of a Cell in Excel
Excel Tip
How to get the row or column number of the current cell or any other cell in Excel. This tutorial covers important functions that allow you to do everything from alternate row and column shading to incrementing values at specified intervals and much more. We will use the ROW and COLUMN function for this.  Here is an example of the output from thes ...
View Excel Tip
 
OR Function - Check if Any Argument is True
Excel Tip
The OR function in Excel checks if ANY argument in it evaluates to TRUE.  If anything evaluates to TRUE, then the function will return TRUE; to return FALSE, every argument in the function must evaluate to FALSE.  Even if only one argument in this function evaluates to TRUE, the function will return TRUE. This is the sister function to the AND fu ...
View Excel Tip
 
Count the Number of Cells that Contain Specific Text in Excel
Excel Tip
How to count the number of cells that contain specific text within a spreadsheet in Excel. I'll show you how to count cells that match exactly a string or that contain part of a string. Sections: Count Cells that Exactly Match a String Count Cells that Contain a Particular String Anywhere within the Cell Notes Count Cells that Exactly Match a Strin ...
View Excel Tip
 
AND Function - Check if All Arguments are True
Excel Tip
The AND function in Excel checks if every argument you put in it evaluates to TRUE.  If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE. This is the sister function to the OR function. This is a very useful function and it is often used in con ...
View Excel Tip
 
Vlookup with a Range of Numbers in Excel
Excel Tip
How to use the Vlookup function to return a result that falls within a range of numbers, such as a weight or quantity or even tests or grades. This allows you to, for example, return the letter A for a score of 90 - 100 on a test. Here, it is assumed that you are at least partly familiar with the Vlookup function.  If you want to learn more about ...
View Excel Tip
 
Automatically Shade Every Other Row When You Add Data in Excel
Excel Tip
How to make Excel automatically add row shading to every other row when you add data to the spreadsheet. This does NOT use the Table feature in Excel.  This tutorial will show you how to use a formatting method to achieve automatically alternating row colors. Steps to Automatically Shade Alternating Rows When Data is Added to a Spreadsheet Select ...
View Excel Tip
 
Print Comments in Excel
Excel Tip
How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within the worksheet and how to print them at the end of the worksheet all in one place. Steps to Print Comments Go to the Page Layout tab and click the little button in the bottom right corner of the Page Setup section. In the window that op ...
View Excel Tip
 
Shade Every Other Row in Excel Quickly
Excel Tip
How to shade every other row in Excel quickly without using the Table feature. This method is for when you simply want to shade the rows and nothing more; when you do not want to convert your data to a Table type in Excel. Sections: Steps to Shade Every Other Row in Excel Quickly Remove Background Shading Remove Lines From Between the Cells Notes S ...
View Excel Tip