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 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.

How to Find and Replace Anything in Excel

2017-07-14T13:05:26+00:00

How to Find and Replace Anything in Excel Excel's search functions are great . . . but if you aren't using the result in another cell, you can use a more familiar tool. The Find and Replace dialog is very powerful, especially once you get a handle on its more advanced features. In this [...]

Relative, Absolute, and Mixed Cell References Explained

2017-07-14T12:47:14+00:00

Relative, Absolute and Mixed Cell References Explained Most of the time, referencing a cell in Excel is super easy: you just click on it. Or type in the column and row. It's rare that you need to know more than that. But every once in a while, you'll need to understand the details of [...]

How to Hide and Unhide Cells, Rows, and Columns in Excel

2017-07-14T12:10:17+00:00

How to Hide Cells, Rows, and Columns in ExcelSpreadsheets can get out of hand quickly—and when you have hundreds (or thousands) of rows and columns, it can be hard to get any work done.Searching helps, but sometimes it's a good idea to make the whole spreadsheet easier to look at.That's where hiding things comes in. You [...]

How to Print Excel Spreadsheets Like a Pro

2017-07-14T11:47:21+00:00

Printing Excel Spreadsheets Like a Pro While the world is increasingly going digital, there are some times when you need to print your documents. Even your spreadsheets. It might seem like an easy task - just hit Print, right? Not so quick! Getting your spreadsheets to print well can be rather difficult. Sometimes they split [...]

All the Formulas You Need to Calculate Percentages in Excel (NEW)

2017-07-14T11:20:24+00:00

All the Formulas You Need to Calculate Percentages in Excel If you regularly work with numbers, you probably also work with percentages. And when you do, you'll find that Excel can handle them just as well as whole numbers or decimals. Still, you need to know how to get the right numbers in the [...]

How to Sort Data in Excel: More Powerful than You Realize

2017-07-14T10:40:58+00:00

How to Sort Data in Excel: More Powerful Than You Realize Excel packs a lot of organizational power. Useful tools like charts, filters, and pivot tables let you slice and dice your data any way you want. But sometimes you need something a little simpler: you just want to sort. And if it's sorting [...]

How to use the functions: COUNTIF and COUNTIFS

2017-06-29T13:21:05+00:00

How to use the functions: COUNTIF and COUNTIFS In Excel, there are many built-in functions available to make all kinds of calculations. In this tutorial, you're going to learn about 2 functions. These functions count the number of cells within a range that contain a specific value. Say we have a list of sales [...]

The functions TEXT and VALUE Explained

2017-06-29T11:13:40+00:00

The functions TEXT and VALUE Explained In this tutorial, you're going to learn exactly how to use the ‘TEXT’ and ‘VALUE’ functions in Excel. You use the function ‘TEXT’ to convert a numeric value to text in a specific number format. For instance, we will look at how to convert a date’s number value [...]

How to use the CHOOSE Function in Excel

2017-06-27T15:26:22+00:00

How to use the CHOOSE Function in Excel The ‘CHOOSE’ function is super useful and should be second-nature to you. We're going to explore how to apply the function with some practical examples. You're also going to learn how to combine ‘CHOOSE’ with a couple of advanced features and methods. This demonstrates the real [...]

How to Consolidate in Excel to Merge Data from Files and Workbooks

2017-06-26T11:47:43+00:00

How to Consolidate in Excel: Merging Data from Files and Workbooks Data consolidation is useful in cases where you want to summarize data from more than one source. This source data could be within the same Excel workbook on different worksheets. It could also be in one or more different workbooks altogether. This [...]

Send this to friend