Our Excel Courses

Latest Forum Posts

Mar 18, '24 at 12:00 pm
Answers: 1
Mar 11, '24 at 6:24 pm
Answers: 2
Mar 14, '24 at 8:34 am
Answers: 1
Mar 11, '24 at 5:08 pm
Answers: 2
Mar 9, '24 at 3:48 pm
Answers: 1
Mar 9, '24 at 10:58 am
Answers: 1
Mar 5, '24 at 9:32 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
I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situation often happens when you export data from another program to Excel and it can wreak havoc in your spreadsheets. Here are three simple ways to converts numbers to their proper number format: (Don't forget to download the accompanying workbook so you can follo ...
 
Excel Tip
How to use the Vlookup function when your data has extra spaces in it. This happens when the lookup data is imported with leading or trailing spaces and it will break your formulas and functions. This tutorial assumes that you are already familiar with Vlookup; if you are not, first read our vlookup tutorial for Excel. The Problem Everything shoul ...
 
Excel Tip
How to remove all formatting from cells at once in Excel. This includes removing any and all types of formatting but leaving all data intact inside the cell.  You can do this to one or many cells and it's quite simple. Steps to Quickly Remove Formatting in Excel Select the data: Go to the Home tab and on the right side click the white eraser and ...
 
Excel Tip
Did you know that you can add colors to your tabs in Excel? This is a great feature that is simple but extremely helpful when organizing large spreadsheets. Steps to Add Color to Tabs and Organize Them Right-click the desired tab: Go to Tab Color and then select the desired color: The key is to make groupings of colored tabs so that it is easy to ...
 
Excel Tip
How to keep an Excel workbook safe by encrypting it with a password. This will make it so that a user cannot open the Excel file unless they have the correct password. Steps to Encrypt a Workbook with a Password in Excel Click the File button ( in Excel 2007 this is the Office button): Go to the Info tab (in Excel 2007 this is the Prepare tab): Cli ...
 
Excel Tip
I'll show you how to loop through an array in VBA and macros in Excel.  This is a fairly simple concept but it can be a little tricky. First, I'm assuming you already know what an array is and how to create and array in VBA [LINK to Article]. Now, that you know that, let's get to looping though arrays. There are two main ways to loop through all ...
 
Excel Tip
The Present Value (PV) function in Excel will return the current value of an investment.  This calculates the current value of a series of future payments, a future lump sum value, or both combined. This is a simple, yet powerful function, giving you the ability to understand how much money you need for something in the future, or simply how much ...
 
Excel Tip
I'll show you how to stop formulas and functions from performing their calculations and updating in Excel. This may seem trivial, but it will save you a lot of time when you are dealing with complex Excel files with thousands of formulas that are linked to other Excel files or with thousands of complex array formulas.  This is because these types ...
 
Excel Tip
I'll show you how to lock a spreadsheet so that nothing can be changed in it. This is a great feature to use when you want to present data without allowing for it to be potentially corrupted or altered. The result of this action is that it will prevent a user from doing almost anything with your data unless they know how to unlock it and know your ...
 
Excel Tip
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to hide a chart to better showcase data or for any other reason. Here is our sample spreadsheet (download it from the side-menu to follow along): Steps to Prevent a Chart from Printing in Excel Right-click the side of the chart and click ...