Our Excel Courses

Latest Forum Posts

Mar 29, '23 at 8:22 pm
Answers: 1
Mar 29, '23 at 6:22 am
Answers: 1
Mar 28, '23 at 12:26 pm
Answers: 1
Mar 28, '23 at 5:58 am
Answers: 1
Mar 23, '23 at 1:37 pm
Answers: 1
Mar 22, '23 at 8:52 am
Answers: 1
Mar 20, '23 at 2:46 am
Answers: 2

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
Have one simple formula that will reference the same cell or range of cells on multiple worksheets at once without having to name each worksheet separately. (make sure to download our sample workbook so you can follow along) Sections: Example 3D Reference How it Works How to Create a 3D Reference Adding or Removing Sheets from the Workbook Functio ...
 
Excel Tip
How to combine a list of data into one cell while putting a delimiter between each piece of data. This tutorial uses a variation of concatenation in order to include delimiters (separators) between each value, which allows for more useful and readable data. This tip will save you hours! (make sure to download the accompanying workbook so you can f ...
 
Excel Tip
Tutorial showing you how to make a user enable macros in a workbook in order to view the workbook. This is very important when macros make-up a critical part of the workbook and not having them can stop the workbook from performing correctly or allow users to mess-up or corrupt the data and functionality of the spreadsheet. There are a few steps in ...
 
Excel Tip
How to make a macro run automatically after a workbook is opened and before anything else happens. You need this macro code: Private Sub Workbook_Open() 'simple message box that will pop-up and say "Hi!" to show you that the macro is working MsgBox "Hi!" End Sub The trick is that you must put this macro code into ThisWorkbook Steps to Make a Macro ...
 
Excel Tip
Display numbers in Excel as zip/postal codes and phone numbers in order to make them easier to read and retain any leading zeros if they exist. (make sure to download the sample workbook so you can follow along) Sections: Displaying Zip/Postal Codes in Excel Displaying Phone Numbers in Excel Custom Phone Number Formatting Zip Codes with Text Other ...
 
Excel Tip
How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup Error in Excel 2007, 2010, 2013, and Later Fix the Vlookup Error in Excel 2003 The Problem You get the #N/A error when Vlookup can't find any data or when you haven't entered a value for the lookup_value argument.   The Vlookup functi ...
 
Excel Tip
Here, I'll teach you what the errors in Excel mean.  There are many errors that you can get and each one means something. (make sure to download the accompanying spreadsheet so you can follow along and learn how to fix these errors) Quick Links to Each Error Section: ###### #DIV/0 #N/A! #NAME? #NULL! #NUM! #REF! #VALUE! ###### When your column is ...
 
Excel Tip
I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These two methods are very simple to use and will help keep your data from getting corrupted. Method 1 - Add Apostrophe The first way to keep leading zeros in front of numbers is to put an apostrophe ' in front of the number. Notice how I input '0123 and not just 0123 ...
 
Excel Tip
This feature allows you to make an Excel file that tells everyone that it is the final version, the completed version. This is great when you need to send a file to someone while at the same time letting them know that no further changes need to or should be made to the workbook. Note: this feature does not prevent a user from making changes to th ...
 
Excel Tip
I will show you a few ways to change negative numbers to positive numbers and back again in Excel. Don't forget to download the accompanying workbook so you can follow along with the tutorial. Method 1 - Convert Negative Values to Positive Values You can use the "paste special" method to change numbers from negative to positive or positive to nega ...