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 Use the Functions SMALL and LARGE to Find the Smallest and Largest Numbers in Excel

2017-09-11T09:55:09+00:00

How to Use the Functions SMALL and LARGE to Find Smallest and Largest Numbers in Excel With some basic sorting, it's easy to find the smallest and largest numbers in a spreadsheet. But sometimes you need to put those numbers into a formula - and that can be tricky. That's where the functions SMALL and LARGE [...]

How to Use the Functions SMALL and LARGE to Find the Smallest and Largest Numbers in Excel 2017-09-11T09:55:09+00:00

The Ultimate Guide to Worksheets in Excel: Learn How To Make a Spreadsheet (+much more)

2017-09-11T09:21:45+00:00

The Ultimate Guide to Excel Worksheets You might think that if you know a lot of useful functions, you know everything there is to know about Excel. But there are some cool things you can do to the spreadsheets themselves, too! We'll take a look at some of the basics, like creating and deleting [...]

The Ultimate Guide to Worksheets in Excel: Learn How To Make a Spreadsheet (+much more) 2017-09-11T09:21:45+00:00

The MOD Function Explained: How to Get Division Remainders in Excel

2017-09-11T08:36:30+00:00

Get Division Remainders in Excel with the MOD Function In elementary school, you probably did long division that resulted in remainders: the parts of the numerator that didn't fit nicely into the divisor. It's probably been a while since you've done long division, but those remainders can be quite useful. And in Excel, you can [...]

The MOD Function Explained: How to Get Division Remainders in Excel 2017-09-11T08:36:30+00:00

How to Show Formulas in Excel

2017-09-11T08:15:39+00:00

How to Show Formulas in Excel When you enter a formula into Excel, it disappears and gets replaced by the result of the function. Which is great. But sometimes you want to look back on the formula to see what it is. Excel has some built-in tools that can help, though. We'll take a look [...]

How to Show Formulas in Excel 2017-09-11T08:15:39+00:00

How to Add Bullet Points in Excel

2017-09-11T08:00:49+00:00

How to Add Bullet Points to an Excel Spreadsheet Unlike most word processors, Excel doesn't have a button for adding bullets. It seems like such a simple thing, but Microsoft neglected to include it. That doesn't mean you can't insert bullet points into Excel, though. You just have to know how to do it. Open [...]

How to Add Bullet Points in Excel 2017-09-11T08:00:49+00:00

Hyperlink in Excel: Learn how to insert links to URLs, cells, and workbooks/sheets (+HYPERLINK function)

2017-08-29T15:38:17+00:00

Hyperlink in Excel: Insert links to URLs, cells, and workbooks/sheets (+HYPERLINK function) In most programs, a hyperlink is simple - it brings you to a web page! Inserting it is just as simple: you highlight the text you want to link, click a button, and enter the URL. But Excel's hyperlinks are way more powerful [...]

Hyperlink in Excel: Learn how to insert links to URLs, cells, and workbooks/sheets (+HYPERLINK function) 2017-08-29T15:38:17+00:00

How to use the functions AVERAGEIF and AVERAGEIFS

2017-08-24T12:46:00+00:00

How to use the functions AVERAGEIF and AVERAGEIFS Finding the average of a series of numbers is a common task in Excel—and the AVERAGE function nails it. But sometimes you need a more capable function. That's where AVERAGEIF and AVERAGEIFS come in. If you're familiar with SUMIF and SUMIFS, you already have a good [...]

How to use the functions AVERAGEIF and AVERAGEIFS 2017-08-24T12:46:00+00:00

How to Wrap Text in Excel

2017-08-23T11:55:22+00:00

How to Wrap Text in Excel Excel has some great tools for working with text, but sometimes it's the simplest things that throw you off. Like trying to figure out how to get text to wrap so it doesn't take up your entire window. So we're going to help you out. Here's what you need [...]

How to Wrap Text in Excel 2017-08-23T11:55:22+00:00

Grouping and Outlining in Excel

2017-08-23T11:44:50+00:00

Grouping and Outlining in Excel Spreadsheets often have different levels of data. And those levels can be difficult to parse when you're trying to read them. That's where grouping and outlining comes in. Grouping cells can make your data easier to read, and it can even help you automate some addition within the outline. [...]

Grouping and Outlining in Excel 2017-08-23T11:44:50+00:00

How to AutoFit in Excel: Adjust Rows and Columns in a Snap

2017-08-23T11:33:16+00:00

How to Autofit in Excel: Adjust Rows and Columns in a Snap Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet. No need for cells that get cut off! (Or, for that matter, cells that have a lot of extra space.) And if you learn to quickly [...]

How to AutoFit in Excel: Adjust Rows and Columns in a Snap 2017-08-23T11:33:16+00:00

Send this to a friend