Search TeachExcel

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! I promise I won't bite. :)

(Blog post about our future and how we want to work with you to create the best possible learning experience.)

Don

Latest Forum Posts

Mar 21, '19 at 5:46 am
Answers: 0
Mar 19, '19 at 5:43 pm
Answers: 2
Mar 15, '19 at 7:02 am
Answers: 1
Mar 12, '19 at 12:13 pm
Answers: 1
Mar 12, '19 at 12:34 am
Answers: 0
Mar 9, '19 at 10:03 am
Answers: 1
Mar 9, '19 at 1:24 pm
Answers: 1

Our YouTube Channel is Back!

Over 250 Video Tutorials and Counting!
  • Updated every week!
  • Step-by-step tutorials.
  • Excel workbooks included for all new tutorials.

Featured Excel Content


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 ...
 
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 t ...
 
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 Forum