Microsoft Excel Tutorials: Free, actionable, and updated.

Right below you find find our latest Excel tutorials (+20!).
They all include practical examples, exercise files, and are updated for the latest version of Excel (2016).

The Ultimate Guide to Pivot Tables

2017-06-07T07:35:29+00:00

The Ultimate Guide to Pivot Tables Who else wants to handle and visualize data without breaking a sweat? I know I do! That's why I've written this ultimate guide for you on "Pivot Tables". Pivot Tables make it easy to summarize data and create dynamic reports. This is our most ambitious [...]

The Ultimate Guide to Pivot Tables 2017-06-07T07:35:29+00:00

The Last Guide to VLOOKUP You’ll Ever Need

2017-06-07T07:35:10+00:00

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

The Last Guide to VLOOKUP You’ll Ever Need 2017-06-07T07:35:10+00:00

How to Make a Line Graph in Excel

2017-11-30T19:41:18+00:00

How to Make a Line Graph in Excel The line graph is one of the simplest graphs you can make in Excel. But that doesn't mean it's not one of the best. The most effective visuals are often the simplest—and line charts (another name for the same graph) are some of the easiest to [...]

How to Make a Line Graph in Excel 2017-11-30T19:41:18+00:00

How to Make a Bar Chart in Excel

2017-11-30T19:41:24+00:00

How to Make a Bar Chart in Excel A bar chart is one of the simplest visuals you can make in Excel. But it's also one of the most useful. While the amount of data that you can present is limited, there's nothing clearer than a simple bar chart. We'll look at a [...]

How to Make a Bar Chart in Excel 2017-11-30T19:41:24+00:00

How to Make a Gantt Chart in Excel 2016

2017-11-30T19:41:32+00:00

How to Make a Gantt Chart in Excel Gantt charts are used almost exclusively for a single purpose: to show project timelines. You might find another use for a Gantt chart, but that's the main one. Why? Because it's perfect for that purpose. Unfortunately, Excel doesn't have a built-in way to create a Gantt chart. [...]

How to Make a Gantt Chart in Excel 2016 2017-11-30T19:41:32+00:00

How to Make a Pie Chart in Excel

2017-11-30T19:41:39+00:00

How to Make a Pie Chart in Excel The pie chart is one of the most commonly used charts in Excel. Why? Because it's so useful. Pie charts can show a lot of information in a small amount of space. They primarily show how different values add up to a whole. That might not [...]

How to Make a Pie Chart in Excel 2017-11-30T19:41:39+00:00

How to Make a Column Chart in Excel

2017-11-30T19:41:45+00:00

How to Make a Column Chart in Excel Column charts are by nature very simple. They represent a small amount of data in a clear, concise manner. But they can be eminently useful. No matter what kind of data you have, there's a good chance that a well-crafted column chart will share that information effectively [...]

How to Make a Column Chart in Excel 2017-11-30T19:41:45+00:00

How to Use the OFFSET Function in Microsoft Excel

2017-11-30T19:41:51+00:00

How to Use the OFFSET Function in Microsoft Excel The OFFSET function is one of the built-in functions in Microsoft Excel. Its purpose is to return a range that is a specified number of rows and columns from a reference cell or range. The range that the OFFSET function returns can be a single cell [...]

How to Use the OFFSET Function in Microsoft Excel 2017-11-30T19:41:51+00:00

A Look at the TRUE and FALSE Functions in Excel

2017-11-30T19:41:56+00:00

A Look at the TRUE and FALSE Functions in Excel There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. These types of formulas are very powerful in their simplicity. For example, you might manage a sales team. [...]

A Look at the TRUE and FALSE Functions in Excel 2017-11-30T19:41:56+00:00

How to use the SUBTOTAL Function in Microsoft Excel

2017-11-30T19:42:03+00:00

How to Use the SUBTOTAL Function in Microsoft Excel In this tutorial, we turn our attention to the SUBTOTAL function in Excel. You may think of a sum of selected values. But, the SUBTOTAL function is capable of much more. Also to its ability to return a sum, it can also give the user [...]

How to use the SUBTOTAL Function in Microsoft Excel 2017-11-30T19:42:03+00:00

How to Format Numbers in Excel

2017-11-30T19:42:09+00:00

How to Format Numbers in Excel In Microsoft Excel, there are several formats available when dealing with numeric data. Yet, the application also offers the ability to create custom number formats. That is, if any of the built-in offerings don’t meet your needs. In this article, we will take a quick look at the [...]

How to Format Numbers in Excel 2017-11-30T19:42:09+00:00

How to Create a VBA Message Box in Excel

2017-11-30T19:42:14+00:00

How to Create a VBA Message Box in Excel In this article, we are going to show you how to create custom message boxes in Microsoft Excel using VBA. If you do not have any experience with VBA, do not worry. This will be a great introduction for you. Soon you can impress your friends [...]

How to Create a VBA Message Box in Excel 2017-11-30T19:42:14+00:00

Send this to a friend