Latest YouTube Tutorial

Clean Messy Data in Excel (Professional Edition)

How to import raw CSV data into Excel, clean and transform it step-by-step AND how to automate it.

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

Allow Only Certain People to Edit Specific Cells in Excel
Excel Tip
How to allow only certain people to edit certain cells or ranges in Excel. This is a security feature that you can setup so that a user has to have a specific password in order to edit parts of a worksheet.  This allows you to have more robust Excel files and to reduce the chance that someone messes-up something in the worksheet. Steps to Allow O ...
View Excel Tip
 
Enable the Analysis ToolPak in Excel
Excel Tip
How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Excel and allows you to use powerful statistical and engineering analysis features. Steps to Enable the Analysis ToolPak Click the File button (Microsoft Office Button for Excel 2007). Click Options from the left side of the menu that appears (Excel Options for E ...
View Excel Tip
 
Quickly Resize Multiple Columns or Rows at Once in Excel
Excel Tip
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows or columns, which can take a very long time. Auto-Fit Multiple Rows or Columns to the Size of the Data in Them Select the entire columns or rows that need to be resized. To do this, left-click the header, either where it says A, B, C, ...
View Excel Tip
 
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