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

Latest YouTube Tutorial

A New Kind of Worksheet in Excel?

It just 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 previous balance when search dates on form
Oct 11, '26 at 6:28 am
Answers: 1
Big font searchable dropdown List with Macro
Oct 9, '26 at 10:01 am
Answers: 1
missed column in listbox when try calculation
Sep 21, '26 at 6:56 am
Answers: 1
populate data in listbox based on selected sheet
Sep 14, '26 at 5:01 am
Answers: 1
double click
Sep 2, '26 at 12:40 pm
Answers: 0
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

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

Create a Bar Chart With a Macro in Excel
Excel Tip
Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data into an Excel bar chart. This is a great macro because it is so simply and therefore easy to integrate into any existing projects of macros for Excel. This macro has a hard-coded (static) range as the reference for the source data ...
View Excel Tip
 
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Excel Tip
Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows you to automatically add a drop down menu to any cell within a worksheet in Excel. This is part of the data validation features in Excel and this macro, since it is self-contained, is very easy to add to any other macro you may be us ...
View Excel Tip
 
Send Emails through Outlook using Email Addresses from Excel and text from Word
Excel Tip
Send Emails from Excel Course This macro allows you to send an email to a list of recipients through excel. The email will be sent through Outlook and the list of recipients is in excel. The message or body of the email is a word document located anywhere on your computer. The entire macro is run through excel and the email addresses used are liste ...
View Excel Tip
 
Create a Line Chart with a Macro in Excel
Excel Tip
Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from a selection of data on the worksheet. As this macro is currently set, the range from which the line chart will be created is a static range that is hard-coded into the macro. This is a bare-bones version of this macro and is in thi ...
View Excel Tip
 
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
Excel Tip
Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every day. This macro will, on its own, run another macro in your workbook at a certain time in the day. This is a great macro to use to automate your Excel spreadsheets. This macro only works in the ThisWorkbook vba section and not a modu ...
View Excel Tip
 
Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
Excel Tip
Run a macro after a certain amount of time has passed since the Excel workbook was opened. This means that you can set this macro to run another macro after the Excel workbook has been open for 10 seconds, 25 minutes, 1 hour, etc. This allows you to run times sensitive macros in Excel, such as time based warnings - i.e. "You have 15 minutes left f ...
View Excel Tip
 
Format Cells as a Percentage in Excel Number Formatting
Excel Tip
This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format to the Percentage number format. That will multiply any number by 100 in order to display the correct percentage number, which is what Excel does when you change the number format to Percent. This Excel macro is great for quickly ...
View Excel Tip
 
Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
Excel Tip
This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is really great because you can easily customize it to choose how many items you want to be displayed after you run the filter. To determine the number of items to display simply replace the "#" sign in the macro with the number of items whi ...
View Excel Tip
 
Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
Excel Tip
Return the highest number between two numbers that is in a range of cells with this UDF (user defined function) in Excel. This allows you to select a range of cells that you want to check and then to return the highest number from those cells that is between two numbers. This UDF in Excel is great for searching through large results of data and fo ...
View Excel Tip
 
Remove All Data Validation from a Cell in Excel
Excel Tip
Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you need to remove all data validation from cells in Excel. This removes drop down menus and lists, input messages, and all other data validation from a cell in Excel. Below, there are two versions of this macro. The first version works on ...
View Excel Tip