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

Feb 17, '19 at 11:08 am
Answers: 0
Feb 14, '19 at 9:25 pm
Answers: 0
Feb 13, '19 at 10:46 am
Answers: 1
Feb 13, '19 at 5:34 pm
Answers: 0
Feb 13, '19 at 12:12 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
In this tutorial I am going to introduce you to creating and managing charts in Excel. Before you create a chart you need to get your chart data organized correctly. In the below example I have a set of sales stats for a few different states: Notice how I have my data labels in a column on the left and the data I wish to display in a column next to ...
 
Excel Tip
In this tutorial I am going to introduce the idea of Logic in Formulas. A Logic test is a test that evaluates either True or False based on the outcome of an equation. There are only 2 outcomes to a logic test, so, for example, I have the Formula =B2 > C2 written in cell A2. This is a logic test that evaluates whether the value in cell B2 is gre ...
 
Excel Tip
In this tutorial I am going to show you how to easily input complex Functions in Excel. To insert a Function, select a cell then navigate to the Formula tab and click the Insert Function button. You then select the Function you wish to Insert and click ok (For this example I am going to insert the VLOOKUP Function). The following window opens:  No ...
 
Excel Tip
In this tutorial I am going to show you how to find and understand new Excel Functions. If you go to the Formulas tab, on the left there is an Insert Function button and a section called the Function Library. First, looking at the Insert Function you click on the button to open the following window: Search for the Function You can even search for a ...
 
Excel Tip
In this tutorial I am going to cover how to perform calculations in Excel. Calculations in Excel follow the same basic rules as simple math. The idea of Order of Operations in math applies to Excel in the same way. The + sign is the addition operator. The addition operator will add the number on the left to the number on the right. So for example I ...
 
Excel Tip
In this tutorial I am going to cover the difference between Absolute and Relative Cell References in Excel and show you how to use them and why they are so important. Relative Cell References Relative Cell references in a formula change as they are copied or filled down a spreadsheet. What this means is that the cell reference will update relative ...
 
Excel Tip
In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell which you have given a custom name to. This cell can then be referred to by its new custom name within and Formula or Function. For example, I have a table of orders and at the bottom are my totals: I could use the cell references C12 and B12 calculate the aver ...
 
Excel Tip
In this tutorial I am going to cover how to link cells together. This is a useful feature of Excel as you can link cells in an Excel Formula instead of typing in the values each time. Linking cells allows you to perform calculations based on the value of cells instead of typing in values. This means that you can copy Formulas over multiple cells an ...
 
Excel Tip
In this tutorial I am going to introduce how to input, edit and manage excel formulas. To start entering a formula, you just select a cell and start typing with an equals sign first: Alternatively you can select the cell, then use the formula bar: When entering a Function into a formula make sure to use parenthesis/brackets to enclose the arguments ...
 
Excel Tip
In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A formula is an expression which helps perform calculations (E.g. 2 + 1 + 5 + 4 = 12, E = MC2). Excel Formulas allow you to calculate the value of a cell based on a specified equation.  This can range from simple addition, subtraction etc. to the more complex such ...
 
Excel Forum