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

Apr 18, '19 at 12:14 am
Answers: 1
Apr 18, '19 at 6:49 am
Answers: 1
Apr 16, '19 at 10:00 am
Answers: 1
Apr 12, '19 at 9:11 pm
Answers: 2
Apr 12, '19 at 1:14 pm
Answers: 1
Mar 27, '19 at 8:25 pm
Answers: 1
Apr 11, '19 at 2:33 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
How to generate random whole numbers (integers) that are between two numbers.  This allows you to set a minimum and maximum possible value and then generate random numbers within that range. Make sure to download the accompanying workbook to follow along. Sections: Steps to Generate Random Numbers within a Range in Excel Quickly Make a List of Ran ...
 
Excel Tip
How to prevent a user from entering any spaces within text in Excel.  This allows you to keep data clean when a user is entering something in Excel and helps to prevent data corruption. We will use data validation in Excel in order to achieve this result. Steps to Prevent Spaces Being Entered in Text in a Range in Excel Create the custom formula t ...
 
Excel Tip
How to quickly delete all empty cells or rows from a range in Excel.  This allows you to quickly clean your data to remove worthless blank sections that only serve to annoy you and break other features in Excel, like using the quick-fill handle to copy formulas down a column. Steps to Remove Blank Cells or Rows from a Range in Excel Select the col ...
 
Excel Tip
How to quickly change all text to upper case or lower case in Excel.  This allows you to change the case of text without having to manually type in the text. I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output. Also, check out our tutorial on ho ...
 
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 Forum