Latest YouTube Tutorial

Excel’s Hidden Ctrl + J Trick (Almost Nobody Knows This)

This will save you a lot of time.

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

HELP WITH A FRUSTRATING EXCEL PROBLEM
Feb 14, '26 at 2:21 am
Answers: 1
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

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

Minimize or Maximize the Ribbon Menu in Excel
Excel Tip
This is a simple way to get more space in Excel, reduce clutter, and streamline the interface by minimizing the big Ribbon Menu. Here is the regular interface: Here is the minimized Ribbon Menu interface: How to Minimize the Ribbon Menu in Excel Double-Click anywhere on the titles of the Ribbon Menu That's it! Now, if you ever want to access the M ...
View Excel Tip
 
Completely Hide the Quick Access Toolbar in Excel
Excel Tip
I'll show you how to completely remove the entire Quick Access Toolbar from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing menu shortcuts.  This method will also remove the Ribbon Menu and either the File or Office buttons from the top of the window, depending on your version of Excel. Here is ...
View Excel Tip
 
Hide or Unhide a Worksheet by Hand in Excel
Excel Tip
I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them. This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to.  This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook. Hide a Work ...
View Excel Tip
 
Completely Hide the Ribbon Menu in Excel
Excel Tip
Updated Version: Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More I'll show you how to completely remove the entire Ribbon Menu from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing any menu in Excel.  As well, this method will hide the quick access toolb ...
View Excel Tip
 
Prevent Duplicate Values in Excel
Excel Tip
I show you how to prevent duplicate values being entered into Excel using Data Validation. Let's say we have a list of part numbers and we want to make sure that there are no duplicates, that a part number is not put into the list more than once. First, select the range where you will be entering the list: Make sure to select enough rows so that a ...
View Excel Tip
 
Dynamic Formulas that Update When you Add Data in Excel
Excel Tip
I'll show you how to make formulas and functions that automatically update when more data is added to a range in Excel.  A simple example is when you want to sum a range that will have more data added to it over time.  You don't want to have to continue to update your formulas and functions, so you want dynamically updating formulas and function ...
View Excel Tip
 
Make a Drop Down List Menu in a Cell in Excel
Excel Tip
I'll show you how to make a drop down list menu in a cell in Excel. This allows you to have a list appear when you click a cell and you can then select an item from the list to have it appear in the cell. This is a great way to make it easier for a user to enter a correct value in a cell. Here is what we want to have: There are two simple ways to ...
View Excel Tip
 
OFFSET Function in Excel
Excel Tip
The OFFSET function in Excel returns a cell or range reference that is a specified number of rows and columns away from a particular cell.  You can also specify how large the returned range reference will be. This can sound confusing so let's look at an example: Here I used the OFFSET function to return 1759, the value in cell C3, while using cel ...
View Excel Tip
 
Dynamic Named Range in Excel
Excel Tip
How to create a named range that expands automatically when a new value is added to the range. This is a great little trick and it will save you a lot of time from updating your named ranges in Excel. The Problem When you create a named range in Excel, it will not update when you add a new value to that range or list. The Solution The solution is ...
View Excel Tip
 
Ignore Blanks in a Data Validation List in Excel
Excel Tip
I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel. All 3 methods are multi-step, but there is no way around this. Here is the issue: 3 ways to Remove Blanks from a Data Validation Dropdown Menu List Sorting Method (easy) Remove Blanks Quickly (easy) Complex Formula (Older Excel Versions) (complex) Excel 365 ...
View Excel Tip