Latest YouTube Tutorial

Stop Updating Old Spreadsheets (Do this instead)

Fix slow, clunky spreadsheets with practical steps that work immediately. No fluff!

Download the File
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

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
show tick and acrossing mark in listbox and combobox
Oct 31, '25 at 4:32 pm
Answers: 3
merging errors for quantity between two files
Nov 24, '25 at 3:18 am
Answers: 1
Identify Date as Workday or Weekend/Holiday
Nov 14, '25 at 1:45 pm
Answers: 2

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

Loop through All Worksheets in Excel using VBA and Macros
Excel Tip
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only takes a few lines of code and is rather simple to use once you understand it. Here is the macro that will loop through all worksheets in a workbook in Excel: Sub Sheet_Loop() 'count the number of worksheets in the workbook sheet_count = Act ...
View Excel Tip
 
Get the Name of a Worksheet in Macros VBA in Excel
Excel Tip
How to get the name of a worksheet in Excel using VBA and Macros and also how to store that name in a variable for later use. This is rather simple but there are a couple different ways to do it. First, we can reference the currently active worksheet and put Name after it: ActiveSheet.Name This gets us the name of the currently active sheet, which ...
View Excel Tip
 
Find the Next Blank Row with VBA Macros in Excel
Excel Tip
Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This method will skip any blanks that are between your data but not at the very end of it. Look at this example: We want the VBA to locate cell C7 and NOT cell C5. The VBA to do this is quite simple: Sub Find_Next_Empty_Row() 'selects the next empty row 'ignores blan ...
View Excel Tip
 
Quickly See All Cells linked to a Formula or Function in Excel
Excel Tip
Ill show you how to see the cells used in a formula/function in Excel and also how to tell which cells are using that particular formula/function. This is a simple yet very helpful feature in Excel and it allows you to visually represent the relationship between the cells/formulas/functions in the worksheet. This is actually very easy to do, just ...
View Excel Tip
 
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Excel Tip
Ill show you how to use Excel to calculate the total time worked in a day minus lunch time or any breaks. This is actually quite simple once you know it, but too many people overcomplicate this. Here is our sample worksheet: (Dont forget to download the accompanying worksheet for this tutorial so you can follow along.) Formula to Calculate Time Wo ...
View Excel Tip
 
Naming Cells in Excel to Make Using Formulas/Functions Easier
Excel Tip
In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell which you have given a custom name to. This cell can then be referred to by its new custom name within and Formula or Function. For example, I have a table of orders and at the bottom are my totals: I could use the cell references C12 and B12 calculate the aver ...
View Excel Tip
 
Linking Cells in Excel
Excel Tip
In this tutorial I am going to cover how to link cells together. This is a useful feature of Excel as you can link cells in an Excel Formula instead of typing in the values each time. Linking cells allows you to perform calculations based on the value of cells instead of typing in values. This means that you can copy Formulas over multiple cells an ...
View Excel Tip
 
How to Input, Edit, and manage Formulas and Functions in Excel
Excel Tip
In this tutorial I am going to introduce how to input, edit and manage excel formulas. To start entering a formula, you just select a cell and start typing with an equals sign first: Alternatively you can select the cell, then use the formula bar: When entering a Function into a formula make sure to use parenthesis/brackets to enclose the arguments ...
View Excel Tip
 
Understanding Formulas and Functions in Excel
Excel Tip
In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A formula is an expression which helps perform calculations (E.g. 2 + 1 + 5 + 4 = 12, E = MC2). Excel Formulas allow you to calculate the value of a cell based on a specified equation.  This can range from simple addition, subtraction etc. to the more complex such ...
View Excel Tip
 
Calculate the Difference Between Two Times in Excel
Excel Tip
Here, youll learn how to get the difference between two times in Excel. A common example of this is for when someone starts and finishes work. (Note that my version of Excel put the finish time in the 24 hour time format (military time) but that it is still just 5:45 PM.) Here we have a start and finish time and I want to see how much time has ela ...
View Excel Tip