Our Excel Courses

Latest Forum Posts

problem show message "File not found" after open file
Jun 3, '25 at 3:47 am
Answers: 1
open files in all of folders branches in directory
Jun 2, '25 at 3:24 am
Answers: 1
Change range in formula based on another cell
Jun 1, '25 at 12:11 pm
Answers: 2
Local filename
May 10, '25 at 2:10 am
Answers: 3
Extraction files names for each sheet based on modified date
May 15, '25 at 4:53 am
Answers: 1
Excel UserEntryForm to open it without open in Excel
Aug 3, '23 at 11:38 pm
Answers: 1
Extract data from PDF file into Excel
Jul 19, '24 at 12:54 pm
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

Count the Number of Unique Values in a List in Excel
Excel Tip
Use a formula to count the number of unique values that are contained within a list in Excel. Steps to Count the Number of Unique Values in a List We need to enter a rather long formula, so it will be listed here in small parts. Type =SUM( Type 1/ Type COUNTIF( Select the range of data that contains the values: Type a comma and then select that sam ...
View Excel Tip
 
Best Lookup Formula in Excel - Index and Match
Excel Tip
A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Match lookups offer you freedom, to search to the left as well as the right and to perform more complex two way lookups with ease. Performing an Index/Match lookup is confusing at first.  Here, I'll show you how to do everything step by step. (before you start, ...
View Excel Tip
 
Insert and Manage Page Breaks in Excel
Excel Tip
How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and confusing but this tutorial should clear up everything. Page breaks are what you use to separate the worksheet into different pages when you go to print it.  If you don't set them, Excel will use default page breaks set to the size of a printed page, and thi ...
View Excel Tip
 
List All Defined Names and Values in the Worksheet in Excel
Excel Tip
Quickly list all Defined Names and their Values in the worksheet without using a macro. This allows you to view and analyze all of your Defined Names and that will help you manage and troubleshoot any potential issues. Steps to List all Defined Names and Values in the Worksheet Select a cell that has enough space below it and to the side to displa ...
View Excel Tip
 
Easy Way to Manage Names in Excel
Excel Tip
How to manage Names in Excel so they are easy to view and change as needed. This is a little trick that I use to keep all of my Names in Excel in one place where I can easily access them. Names are pieces of data that can be used in formulas and functions.  Names store basically anything you want, a cell reference, a formula or function, text, or ...
View Excel Tip
 
REPT Function in Excel - Repeat Values
Excel Tip
Quickly repeat a value, character, or number within a cell in Excel.  This is a neat little function that is easy to use and can help to create some unique elements within the spreadsheet or just perform a simple character repeat. Syntax =REPT(text, number_times) ArgumentDescriptionText What you want to repeat, surrounded by double quotation mark ...
View Excel Tip
 
Sort on Multiple Columns at Once in Excel
Excel Tip
How to sort a data set by multiple columns in Excel.  This allows you to better organize a data set and is really easy to do. Steps to Sort on Multiple Columns Select the data that you want to sort or simply select a cell within that data set. Go to the Data tab and click the big Sort button, NOT one of the smaller ones. A window will open. If you ...
View Excel Tip
 
Print Specific Rows or Columns on Each Page in Excel
Excel Tip
How to repeat specific rows or columns on every printed page so that you know what each column or row means when you are reading through the document. This is a handy little tip that makes reading printed documents much easier. Steps to Print Specific Rows/Columns on Each Page Go to the Page Layout tab and click the Print Titles button: In the win ...
View Excel Tip
 
Chart Hidden Data in Excel
Excel Tip
How to show data from hidden rows and columns on a chart in Excel. When you hide rows or columns of data, a chart will, by default, not display that data anymore.  Thankfully, there is a simple way around this. The problem: Steps to Show Hidden Data on Charts Select the chart: Go to the Design tab that appears when you select the chart and then c ...
View Excel Tip
 
Group Data Together for Increased Readability in Excel
Excel Tip
How to group data together or collapse it in order to focus only on the important data in Excel. This allows you to take a big spreadsheet that contains a lot of data and make it more manageable and, therefore, easier to read and use. This technique is different than simply hiding columns and rows, as that method does not make it easy to expand da ...
View Excel Tip