Latest YouTube Tutorial

AI Just Made VBA Obsolete… Or Did It?

In this video, you’ll learn how AI is changing Excel automation and why VBA still matters if you actually want more control over your workflows.

Watch on YouTube
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

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
VBA code copied to new workbook throws runtime "error 91" - UPDATE - SOLVED
Jan 2, '26 at 10:29 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

Generate Random Numbers within a Range in Excel
Excel Tip
How to generate random whole numbers (integers) that are between two numbers.  This allows you to set a minimum and maximum possible value and then generate random numbers within that range. Make sure to download the accompanying workbook to follow along. Sections: Steps to Generate Random Numbers within a Range in Excel Quickly Make a List of Ran ...
View Excel Tip
 
Prevent Spaces from Being Entered in Cells in Excel
Excel Tip
How to prevent a user from entering any spaces within text in Excel.  This allows you to keep data clean when a user is entering something in Excel and helps to prevent data corruption. We will use data validation in Excel in order to achieve this result. Steps to Prevent Spaces Being Entered in Text in a Range in Excel =A1=SUBSTITUTE(A1," ","") ...
View Excel Tip
 
Delete All Empty Rows or Blank Cells from a Range in Excel
Excel Tip
How to quickly delete all empty cells or rows from a range in Excel.  This allows you to quickly clean your data to remove worthless blank sections that only serve to annoy you and break other features in Excel, like using the quick-fill handle to copy formulas down a column. Steps to Remove Blank Cells or Rows from a Range in Excel Select the col ...
View Excel Tip
 
Make All Text Upper Case or Lower Case in Excel
Excel Tip
How to quickly change all text to upper case or lower case in Excel.  This allows you to change the case of text without having to manually type in the text. I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output. Also, check out our tutorial on ho ...
View Excel Tip
 
Easily Compare Duplicate Values in Excel
Excel Tip
Here, I'll show you a simple technique to quickly and easily compare large lists of duplicate values.  This allows you to analyze the list in order to have better data analysis and or just to figure out which duplicates might need to be removed. Steps to Easily Analyze a List Containing Duplicate Values in Excel Import the list into Excel, or if i ...
View Excel Tip
 
Display all Formulas at Once in Excel
Excel Tip
How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsheet quickly and easily. Steps to Display all Formulas at Once in Excel Go to the worksheet where you want to view the formulas (this feature is worksheet specific). Go to the Formulas tab and then click Show Formulas or use the keyboard shortcut  Ctrl + ` (th ...
View Excel Tip
 
Require a Unique List of Numbers in a Range in Excel
Excel Tip
I'll show you how to require a user to enter a unique number into a range of cells in Excel.  This feature will require that the value entered into the cell must be a number and that it must be different than any other number in that range.  To do this, we will be using data validation along with a custom formula. Create the Custom Formula The fi ...
View Excel Tip
 
RATE Function - Calculate an Interest Rate in Excel
Excel Tip
The Rate function in Excel (RATE) calculates the interest rate for a financial transaction, such as for an annuity or lump sum.  An annuity is simply an equal series of payments. You tell the RATE function the payments that are made, for how long they are made, and the present value and this function will give you the interest rate for that equati ...
View Excel Tip
 
Import a Worksheet from One Workbook to Another in Excel
Excel Tip
In Excel, you can quickly copy an entire worksheet from one workbook to another workbook.  This allows you to import data from other workbooks with ease and without having to copy/paste everything between the worksheets. Steps to Import a Worksheet from Another Workbook in Excel Make sure that you have both workbooks open, the one that has the dat ...
View Excel Tip
 
Hide Data Within a Worksheet in Excel
Excel Tip
In Excel you can actually hide data that is stored within a worksheet. This allows you to show data that is useful to a user while hiding data that you don't want them to change or that you simply don't want them to see.  This makes for more robust worksheets, as it becomes harder to mess things up and also makes for nicer looking well-kept spread ...
View Excel Tip