Our Excel Courses

Latest Forum Posts

Apr 9, '24 at 2:29 am
Answers: 1
Apr 4, '24 at 5:52 pm
Answers: 1
Apr 3, '24 at 5:41 pm
Answers: 1
Mar 28, '24 at 8:55 pm
Answers: 1
Mar 30, '24 at 9:14 pm
Answers: 1
Mar 29, '24 at 8:38 am
Answers: 1
Mar 28, '24 at 5:44 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


Excel Tip
Here, I'll show you a simple technique to quickly and easily compare large lists of duplicate values.  This allows you to analyze the list in order to have better data analysis and or just to figure out which duplicates might need to be removed. Steps to Easily Analyze a List Containing Duplicate Values in Excel Import the list into Excel, or if i ...
 
Excel Tip
How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsheet quickly and easily. Steps to Display all Formulas at Once in Excel Go to the worksheet where you want to view the formulas (this feature is worksheet specific). Go to the Formulas tab and then click Show Formulas or use the keyboard shortcut  Ctrl + ` (th ...
 
Excel Tip
I'll show you how to require a user to enter a unique number into a range of cells in Excel.  This feature will require that the value entered into the cell must be a number and that it must be different than any other number in that range.  To do this, we will be using data validation along with a custom formula. Create the Custom Formula The fi ...
 
Excel Tip
The Rate function in Excel (RATE) calculates the interest rate for a financial transaction, such as for an annuity or lump sum.  An annuity is simply an equal series of payments. You tell the RATE function the payments that are made, for how long they are made, and the present value and this function will give you the interest rate for that equati ...
 
Excel Tip
In Excel, you can quickly copy an entire worksheet from one workbook to another workbook.  This allows you to import data from other workbooks with ease and without having to copy/paste everything between the worksheets. Steps to Import a Worksheet from Another Workbook in Excel Make sure that you have both workbooks open, the one that has the dat ...
 
Excel Tip
In Excel you can actually hide data that is stored within a worksheet. This allows you to show data that is useful to a user while hiding data that you don't want them to change or that you simply don't want them to see.  This makes for more robust worksheets, as it becomes harder to mess things up and also makes for nicer looking well-kept spread ...
 
Excel Tip
In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook. To do this we need to create what is called a "personal macro workbook" and then save it.  All of the macros that we want to use in Excel will be stored within this personal macro workbook and will then be accessible by any Excel file. Steps to Make any ...
 
Excel Tip
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This allows you to select sections of important data to print without having to move those sections of data to other spreadsheets in order to print them. You can select a single part of a worksheet or multiple parts of a worksheet to print. ...
 
Excel Tip
How to switch a data set in Excel so that the columns become rows and the rows become columns. This will save you hours when you need to "flip" a set of data in Excel. Below, I'll show you the steps involved; don't forget to download the accompanying workbook so you can follow along with this tutorial. Sections: Desired Result Steps to Switch the ...
 
Excel Tip
There are two easy ways to combine values from multiple cells in Excel. In order to do this, we need to do what is called "concatenate" values. Method 1 - CONCATENATE Function Type =CONCATENATE( into the cell where you want the combined text to appear: Select the first cell that you want to combine: Type a comma and then select the next cell that y ...