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! :)

(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 6, '21 at 3:58 am
Answers: 2
Feb 25, '21 at 4:55 am
Answers: 2
Mar 2, '21 at 1:31 pm
Answers: 1
Mar 2, '21 at 8:21 pm
Answers: 0
Mar 2, '21 at 5:51 am
Answers: 1
Mar 1, '21 at 4:30 pm
Answers: 1
Feb 28, '21 at 8:43 am
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
This is a simple way to get more space in Excel, reduce clutter, and streamline the interface by minimizing the big Ribbon Menu. Here is the regular interface: Here is the minimized Ribbon Menu interface: How to Minimize the Ribbon Menu in Excel Double-Click anywhere on the titles of the Ribbon Menu That's it! Now, if you ever want to access the M ...
 
Excel Tip
The Future Value function (FV) in Excel will return the future value of an investment based on a particular interest rate.  The future value of the investment can be calculated when there is a single lump sum payment, a series of payments, or a lump sum payment with a series of payments. This is a corner stone of many financial calculations and i ...
 
Excel Tip
Learn how to change the number of worksheets that are in new Excel workbooks. Excel workbooks always have 3 worksheets to start with and here is how you change that. Here is the default new workbook with its three worksheets: Change Default Number of Sheets in Excel Workbook Go to the File menu for Excel 2010 or later, the Office button for Excel ...
 
Excel Tip
I'll show you how to completely remove the entire Quick Access Toolbar from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing menu shortcuts.  This method will also remove the Ribbon Menu and either the File or Office buttons from the top of the window, depending on your version of Excel. Here is ...
 
Excel Tip
I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them. This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to.  This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook. Hide a Work ...
 
Excel Tip
I'll show you how to completely remove the entire Ribbon Menu from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing any menu in Excel.  As well, this method will hide the quick access toolbar and the Office or File buttons (depending on your version of Excel). Here is the normal Excel interface: ...
 
Excel Tip
I show you how to prevent duplicate values being entered into Excel using Data Validation. Let's say we have a list of part numbers and we want to make sure that there are no duplicates, that a part number is not put into the list more than once. First, select the range where you will be entering the list: Make sure to select enough rows so that a ...
 
Excel Tip
I'll show you how to make formulas and functions that automatically update when more data is added to a range in Excel.  A simple example is when you want to sum a range that will have more data added to it over time.  You don't want to have to continue to update your formulas and functions, so you want dynamically updating formulas and function ...
 
Excel Tip
I'll show you how to make a drop down list menu in a cell in Excel. This allows you to have a list appear when you click a cell and you can then select an item from the list to have it appear in the cell. This is a great way to make it easier for a user to enter a correct value in a cell. Here is what we want to have: There are two simple ways to ...
 
Excel Tip
The OFFSET function in Excel returns a cell or range reference that is a specified number of rows and columns away from a particular cell.  You can also specify how large the returned range reference will be. This can sound confusing so let's look at an example: Here I used the OFFSET function to return 1759, the value in cell C3, while using cel ...
 
Excel Forum