Latest YouTube Tutorial

Timestamps?!

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

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
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

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

Do Something Every so Many Rows with a Macro in Excel
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 ...
View Excel Tip
 
Run a Macro When a Specific Cell Changes in Excel
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 ...
View Excel Tip
 
Transpose a Column into Multiple Rows in Excel
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 ...
View Excel Tip
 
Highlight Duplicate Values in Excel
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 ...
View Excel Tip
 
Goal Seek in Excel
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 ...
View Excel Tip
 
Change Minutes from a Decimal to a Percentage of an Hour
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 ...
View Excel Tip
 
Get the Decimal Part of a Number in Excel
Excel Tip
How to get the decimal part of a number without any rounding in Excel. This tip allows you to simply remove the whole number, integer, from the number in order to return the decimal portion of the number. To do this, we need to use the TRUNC function inside a small formula. If the number is in cell A1, use this formula to get the decimal part of t ...
View Excel Tip
 
Get the Integer Part of a Number in Excel
Excel Tip
How to get the integer part, the whole number, from a number that has a decimal after it. This does not round the number, this ONLY returns the integer, the non-decimal part of the number. We use the TRUNC function for this. =TRUNC(number) The number argument is usually a cell reference but it can also be a hard-coded number or another function/fo ...
View Excel Tip
 
Install Solver Add-In for Excel
Excel Tip
How to Install the Solver Add-In into Excel. Sections: Install Solver Developer Tab Add-In Install Install Solver Go to File > Options. (In Excel 2007, click the Office Button and then Excel Options.) Go to the Add-Ins section. Look to the bottom of the window and next to where it says Manage: make sure you have Excel Add-Ins selected. Click the ...
View Excel Tip
 
Get Formulas from Cells in Excel with VBA
Excel Tip
Get a formula from a cell using VBA in Excel. This method returns the actual formula instead of the output value. Get the Formula of a Cell into a Macro We use the Formula property for this. To get the formula in cell A1, type this in a macro: Range("A1").Formula I will put MsgBox in front of this line of code so we can see the output in Excel: Msg ...
View Excel Tip