Microsoft Excel Tutorials: Including Free Practice Exercises!

Right below you find +100 tutorials for Excel 2016 (Windows). All tutorials are super practical and include free exercises.
Simply download the included sample file and start practicing your Excel skills today!


Excel Pivot Table Tutorial: The Ultimate Guide to Creating Pivot Tables

2018-02-16T10:50:54+00:00

Excel Pivot Table Tutorial: The Ultimate Guide to Creating 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 tutorial for you on "Pivot Tables" in Excel (2016). Pivot Tables make it easy to summarize data and create dynamic [...]

Excel Pivot Table Tutorial: The Ultimate Guide to Creating Pivot Tables 2018-02-16T10:50:54+00:00

The Last Guide to VLOOKUP in Excel You’ll Ever Need

2018-02-14T09:48:01+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 in Excel You’ll Ever Need 2018-02-14T09:48:01+00:00

How to Make a Line Graph in Excel: Explained Step-by-Step

2018-02-14T11:43:39+00:00

How to Make a Line Graph in Excel: Explained Step-by-Step 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 [...]

How to Make a Line Graph in Excel: Explained Step-by-Step 2018-02-14T11:43:39+00:00

How to Make a Bar Chart in Excel

2018-02-05T14:14:14+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 2018-02-05T14:14:14+00:00

How to Make a Gantt Chart in Excel 2016

2018-02-05T14:14:38+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 2018-02-05T14:14:38+00:00

How to Make a Pie Chart in Excel

2018-02-05T14:15:02+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 2018-02-05T14:15:02+00:00

How to Make a Column Chart in Excel

2018-02-05T14:15:25+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 2018-02-05T14:15:25+00:00

How to Use the OFFSET Function in Microsoft Excel

2018-02-05T14:15:47+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 2018-02-05T14:15:47+00:00

A Look at the TRUE and FALSE Functions in Excel

2018-02-05T14:16:08+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 2018-02-05T14:16:08+00:00

How to use the SUBTOTAL Function in Microsoft Excel

2018-02-05T14:16:18+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 2018-02-05T14:16:18+00:00

How to Format Numbers in Excel

2018-02-05T14:16:29+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 2018-02-05T14:16:29+00:00

How to Create a VBA Message Box in Excel (“msgbox”) for Non-Geeks

2018-02-16T11:15:52+00:00

How to Create a VBA Message Box in Excel ("msgbox") for Non-Geeks 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 [...]

How to Create a VBA Message Box in Excel (“msgbox”) for Non-Geeks 2018-02-16T11:15:52+00:00

Send this to a friend