Latest YouTube Tutorial

This Might Be the Coolest Excel Trick I’ve Found

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

populate headers in listbox on form
Jul 27, '26 at 11:37 am
Answers: 2
Subscript out of range to autocomplete items in combobox
Jul 18, '26 at 10:50 am
Answers: 1
Sum columns in listbox on userform
Jul 12, '26 at 11:46 am
Answers: 1
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

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

What is a Macro in Excel?
Excel Tip
This is the first step to learning about Macros for Excel and how to use them.  What is a Macro?   A macro is a small program that you make in Excel that automates tasks. Basically, this "thing", the macro, can save you hours of time. You can create macros that do almost anything in Excel and even other Microsoft Office programs. How can Macros ...
View Excel Tip
 
Excel VBA MsgBox - Message Box Macro
Excel Tip
Create a pop-up message box in Excel using VBA Macros. This allows you to show a message to the user and to get input back, depending on which buttons were clicked in the pop-up message. To output a message in Excel, we use the MsgBox function. Below, you will find many examples that should suit your needs. Sections: Syntax Example 1 - Output Basic ...
View Excel Tip
 
VBA Comparison Operators
Excel Tip
VBA comparison operators are used to compare values in VBA and Macros for Excel. List of VBA Comparison Operators Comparison Operator Meaning < A < B - Checks if A is LESS THAN B. > A > B - Checks if A is GREATER THAN B. <= A <= B - Checks if A is less than or equal to B. >= A >= B - Checks if A is greater than or equal to B ...
View Excel Tip
 
Countdown Timer in Excel
Excel Tip
How to create a countdown timer in Excel. This allows you to display a timer in whatever cell you want and it will count down until it reaches zero. I also included a method to stop or pause the timer. To create the countdown timer, a macro will be used. However, this tutorial does not require any previous knowledge of macros or VBA in Excel. If y ...
View Excel Tip
 
Simple Excel Function to Combine Text with a Separator
Excel Tip
Excel function that makes combining text very easy. This function is simpler and better than the CONCATENATE function. This function is a UDF and this tutorial assumes that you have a basic understanding of those. You can learn about them here: User Defined Functions (UDF) in Excel Sections: Syntax Create the Function and Install It Usage Examples ...
View Excel Tip
 
Simple Excel Function to Extract a Word or Text from a Cell
Excel Tip
Excel function that makes it easy to extract a word or text from a cell in Excel. This is a single function! It does NOT require a complex formula or nested functions or anything like that. To use this function, we first need to create it using a UDF, User Defined Function. You can learn about this kind of function here: User Defined Functions in E ...
View Excel Tip
 
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
Excel Tip
This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods to insert a check-mark into Excel, including using Macros/VBA and a UDF, or User Defined Function. Sections: Basic Method to Insert a Check Mark into Excel VBA Method to Insert a Check Mark into Excel UDF that Inserts a Check Mark into Excel Notes Basic Metho ...
View Excel Tip
 
Loop through a Range of Cells in a UDF in Excel
Excel Tip
How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is almost the same as doing it for a basic macro, but getting the input is different. If you don't know what a UDF is, view this tutorial to learn more: Custom Functions in Excel - UDF Sections: Loop through a Range of Cells in a UDF Working Function Final Code No ...
View Excel Tip
 
Excel Prank - Automatically Change User-Entered Text
Excel Tip
Use AutoCorrect to change the text a user enters into something funny. This is a great little prank to use on co-workers. It makes it so that every time they enter a specific word, it will automatically change to another word, a word that you choose. Go to the File menu and then click Options. For Excel 2007, Office button > Excel Options. Go to ...
View Excel Tip
 
Excel Function to Remove All Text OR All Numbers from a Cell
Excel Tip
How to create and use a function that removes all text or all numbers from a cell, whichever you want. To do this, we will create a UDF or User Defined Function in Excel. But, I won't make you start from scratch; if you want to get the functions right away, simply download the Excel file attached to this tutorial and copy the code for yourself or g ...
View Excel Tip