We are in the process of updating the site, so some pages still have the older design.

Latest YouTube Tutorial

Timestamps?!

It finally works!

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!

Latest Forum Posts

Sep 2, '26 at 12:40 pm
Answers: 0
Jul 27, '26 at 11:37 am
Answers: 2
Jul 18, '26 at 10:50 am
Answers: 1
Jul 12, '26 at 11:46 am
Answers: 1
Jun 12, '26 at 9:22 am
Answers: 1
Jun 4, '26 at 6:42 pm
Answers: 1
May 29, '26 at 2:33 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


Excel Tip
Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a specific cell has been selected. The benefit of this type of pop up message in Excel is that when a user goes to enter something in a particular cell, you can display a reminder to that user which can better help them fill out that cell. Th ...
 
Excel Tip
How to get a column letter from a number in Excel using a simple formula. This is an important thing to be able to do when working with complex formulas in Excel, especially the INDIRECT() function. Sections: Basic Formula - Works for A to Z More Complex Formula - Works For All Columns Notes Basic Formula - Works for A to Z The formula: =CHAR(64+A ...
 
Excel Tip
Return Vlookup results on partial matches of a cell's contents. You could type the start, end, or middle of a lookup value and still return a result. I assume that you are already familiar with Vlookup, if you aren't, then checkout our tutorials on lookup functions in Excel. Sections: Vlookup Match the Start of a Cell Vlookup Match the End of a Ce ...
 
Excel Tip
How to convert scientific numbers to show their full amount; this method also allows you to retain the appearance of text in case you have a mixed list of text and numbers in scientific notation format. There are a number of ways to do this and what you should use depends on your dataset. Sections: Convert Using a Formula Convert Using Formatting ...
 
Excel Tip
How to have a macro do something on a set interval of rows; for instance, input a value every 5 rows. Sections: The Code Change the Code to Work for You Notes The Code Sub row_interval()   'row interval interval = 2   'first row to start on first_row = 1   'last row to go to - above version of this goes to the last row of the data in the prescri ...
 
Excel Tip
Run a macro in Excel when a specific cell is changed; this also covers when a cell within a range of cells is changed or updated. Sections: Run Macro When a Cell Changes (Method 1) Run Macro When a Cell Changes (Method 2) Run Macro when a Cell in a Range of Cells is Changed Notes Run Macro When a Cell Changes (Method 1) This works on a specific ce ...
 
Excel Tip
Convert a column of data into multiple rows of data at a given interval. For instance, every 5 rows of data in the column will appear in its own row after being transposed. To Transpose in Excel means to convert a range of data from a column to a row and vice versa. The above example is kind of confusing so let's look at an example and then I will ...
 
Excel Tip
How to highlight duplicate values in a list. Also, how to arrange those values next to each other so they are easy to see. Sections: Highlight Duplicates Arrange Duplicates Next to Each Other Notes Highlight Duplicates Select the list of values that may contain duplicate values. Go to the Home tab > Conditional Formatting button > Highlight ...
 
Excel Tip
Find a desired result by having Excel automatically change input values in Excel. Using Goal Seek, you setup a formula or a series of formulas in a worksheet and have Excel cycle through different input values until it finds the one that generates the result that you wanted. Note: there are limitations to using Goal Seek and sometimes you will nee ...
 
Excel Tip
Change minutes stored as a decimal into a fraction of an hour. For instance, if time is stored as 8.15, 8 hours and 15 minutes, this is not very helpful when performing calculations such as a costing analysis; it is better to have the time converted to 8.25, or 8 hours and 25% of one hour.  With the new number, you can multiple it by, for instance ...