Our Excel Courses

Latest Forum Posts

May 29, '23 at 3:45 pm
Answers: 1
Jun 1, '23 at 8:29 am
Answers: 1
May 30, '23 at 9:49 am
Answers: 1
May 25, '23 at 11:49 am
Answers: 1
May 24, '23 at 3:33 pm
Answers: 1
May 24, '23 at 2:12 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


Excel Tip
How to delete duplicate values from a data set in all versions of Excel. This includes Excel 2003 and earlier and also Excel 2007 and later. For Excel 2007 and later, we can use a simple feature within the program, but for Excel 2003 and earlier, we must use a macro, which is provided below. Sections: Remove Duplicates in Excel 2007 and Later Vers ...
 
Excel Tip
Prevent specific rows or columns from moving when you scroll through a spreadsheet in Excel. This allows you to keep header rows and columns in place so you can tell what each column or row is for no matter where you are in the worksheet. In Excel, this is called Freezing Panes. Sections: Steps to Lock Rows/Columns in Excel Steps to Lock Multiple R ...
 
Excel Tip
You can download Microsoft Office, including Microsoft Excel for a free trial period. This grants you full access to all features of the software for 60 days. This is perfect if you need to evaluate the benefit of Excel and Microsoft Office or if you just need to use Excel for a short period of time and don't want to pay hundreds of dollars for Mic ...
 
Excel Tip
View different sections of the same worksheet when the sections are far apart.  This allows you to better work on large spreadsheets that contain a lot of data. Steps to View Multiple Different Sections of a Worksheet at Once Go to the View tab and click the Split button: Once you do that, your screen will be divided into 4 sections: You have 4 d ...
 
Excel Tip
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you to quickly enter fractions in the fraction format without having to first convert them to decimals and then format it separately.  This will save you a lot of time. Steps to Enter Fractions Quickly Type a zero 0 in the cell: Hit the ...
 
Excel Tip
How to remove spaces from the middle of text in Excel.  This includes removing all spaces from the middle of text in a cell and removing only certain spaces from the middle of text in a cell. The methods shown below are easy to use and can be quickly applied to any size list or the entire workbook, which will save you a lot of time. Sections: Qui ...
 
Excel Tip
How to get the current date using Excel.  This method updates the date every day so that it is always accurate. To do this we will use the TODAY() function. Syntax =TODAY() There are no arguments for this function; you simply type it in as it is displayed above. List the Current Date in Excel Simply type =TODAY() into any cell where you want the c ...
 
Excel Tip
How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas; there is no VBA or Macro required for this to work. I'll teach you how to build your own or, if you just want to skip to the good stuff, download the Excel file that accompanies this tutorial and enjoy! :) Here is what we will build: Steps to Build a Sparkli ...
 
Excel Tip
How to change the order of the tabs in your spreadsheet. This is rather easy to do and makes your spreadsheets much easier to follow and understand.  There are two ways to change tab order in Excel, and both are explained below. Method 1 - Change Order of Tabs This is the easiest method when you have only a few tabs in the workbook. Left-click and ...
 
Excel Tip
How to automatically calculate someone's age using Excel.  This method is simple and will update every year so that you never have to manually adjust an age in Excel. This is great when you are working with employee or customer data. I'll show you two methods to do this; which one you use depends on the setup of your data. Sections: Calculate Som ...