Latest YouTube Tutorial

I don't use Pivot Tables in Excel anymore, I do this instead

The future is here!

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

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
HELP WITH A FRUSTRATING EXCEL PROBLEM
Feb 14, '26 at 2:21 am
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

Using Parentheses in Excel
Excel Tip
How to use parentheses in Excel in order to create more powerful formulas and functions. Sections: Basics of Parentheses Using Parentheses with Logical Comparison Operators Using Parentheses with Functions Notes Basics of Parentheses When performing calculations or doing anything in a formula or function or operation in Excel, what is inside parent ...
View Excel Tip
 
Logical Comparison Operators in Excel - How to Compare Things
Excel Tip
(Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical comparison operators allow you to compare values in Excel to see if they are equal, not equal, greater than, or less than.  The result of one of these comparisons will either be TRUE or FALSE.  These operators allow you to make powerful spreadsheets in Excel and, her ...
View Excel Tip
 
Dates in Excel Explained
Excel Tip
I'll explain how dates in Excel work and then point you to many useful tutorials on how to use dates and also times in Excel. What is a Date in Excel? Dates in Excel are actually just numbers that are formatted as dates. If you take a date and select the cell and then set that cell's formatting to "General" it will look like this: Cell A1 has the ...
View Excel Tip
 
MOD Function in Excel
Excel Tip
The MOD function is very simple but it can be used to do wonderful things in Excel. It returns the remainder after you divide one number by another. Syntax =MOD(number, divisor) Argument Description Number The number that will be divided by another number. Divisor The number by which the first number will be divided. Example - Simple Type =MOD( Typ ...
View Excel Tip
 
Remove Print Preview Lines in Excel
Excel Tip
Here's how to remove the little dotted lines that sometimes appear on the spreadsheet. Specifically, this deals with removing or hiding the print preview lines that appear in Excel after you have adjusted a setting for printing but then gone back to the normal view of the spreadsheet. Here, you can see the annoying print preview dotted lines betwe ...
View Excel Tip
 
Count the Number of Unique Values in a List in Excel
Excel Tip
Use a formula to count the number of unique values that are contained within a list in Excel. Steps to Count the Number of Unique Values in a List We need to enter a rather long formula, so it will be listed here in small parts. Type =SUM( Type 1/ Type COUNTIF( Select the range of data that contains the values: Type a comma and then select that sam ...
View Excel Tip
 
Best Lookup Formula in Excel - Index and Match
Excel Tip
A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Match lookups offer you freedom, to search to the left as well as the right and to perform more complex two way lookups with ease. Performing an Index/Match lookup is confusing at first.  Here, I'll show you how to do everything step by step. (before you start, ...
View Excel Tip
 
Insert and Manage Page Breaks in Excel
Excel Tip
How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and confusing but this tutorial should clear up everything. Page breaks are what you use to separate the worksheet into different pages when you go to print it.  If you don't set them, Excel will use default page breaks set to the size of a printed page, and thi ...
View Excel Tip
 
List All Defined Names and Values in the Worksheet in Excel
Excel Tip
Quickly list all Defined Names and their Values in the worksheet without using a macro. This allows you to view and analyze all of your Defined Names and that will help you manage and troubleshoot any potential issues. Steps to List all Defined Names and Values in the Worksheet Select a cell that has enough space below it and to the side to displa ...
View Excel Tip
 
Easy Way to Manage Names in Excel
Excel Tip
How to manage Names in Excel so they are easy to view and change as needed. This is a little trick that I use to keep all of my Names in Excel in one place where I can easily access them. Names are pieces of data that can be used in formulas and functions.  Names store basically anything you want, a cell reference, a formula or function, text, or ...
View Excel Tip