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

Feb 28, '20 at 7:35 am
Answers: 1
Feb 27, '20 at 8:56 pm
Answers: 1
Feb 27, '20 at 11:39 am
Answers: 1
Feb 27, '20 at 11:43 am
Answers: 0
Feb 27, '20 at 4:34 am
Answers: 1
Feb 26, '20 at 7:35 am
Answers: 1
Feb 25, '20 at 12:09 am
Answers: 0

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'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 t ...
 
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 Tip
How to create a named range that expands automatically when a new value is added to the range. This is a great little trick and it will save you a lot of time from updating your named ranges in Excel. The Problem When you create a named range in Excel, it will not update when you add a new value to that range or list. The Solution The solution is ...
 
Excel Tip
I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel. All 3 methods are multi-step, but there is no way around this. Here is the issue: 3 ways to Remove Blanks from a Data Validation Dropdown Menu List Sorting Method (easy) Remove Blanks Quickly (easy) Complex Formula (complex) Sorting Method The sorting method ...
 
Excel Tip
Data Validation is a tool in Excel that you can use to limit what a user can enter into a cell.  It is a great tool for creating forms or really anything where you want to ensure that erroneous values are not entered into a spreadsheet. Sections: What is Data Validation in Excel? How to Add Data Validation Types of Data Validation Any Value Whole ...
 
Excel Tip
In this tutorial I am going to show you how to combine multiple chart types to create a single chart in Excel. This will help you understand how to create more powerful charting tools for reporting and analyzing data. To start, set up your chart with 2 data series: Initially this doesnt look great as the values for the number of Orders are so small ...
 
Excel Tip
In this tutorial I am going to go through the Format tab in more detail and show you how to Format every element of a chart. The main focus here is on the styling section of the format tab. You can get to the Format tab in Excel after you have selected a chart: For this tutorial, I am starting with a chart layout built up in the previous tutorial, ...
 
Excel Tip
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts to get just about any setup you want. Here is the layout tab in Excel and you can access it once you select a chart that you have already created. To start, I have inserted a basic chart with no layout features: The tutorial will now b ...
 
Excel Tip
In this tutorial I am going to show you how to update, change and manage the data used by charts in Excel. This tutorial is split up in order to breakdown the Select Data Source window into small and easy to understand parts. To edit the data selection of a chart, right click the chart and select the Select Data option - or select the chart, go to ...
 
Excel Forum