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


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


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 Wrap Text in Excel


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

Grouping and Outlining in Excel


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

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


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 Strikethrough in Excel (+shortcut)


How to Strikethrough in Excel Excel is great with text, but it's not always clear how to get the formatting you want. This is especially true for strikethrough:) Fortunately, adding strikethrough in Excel is super easy—once you know how to do it. Let's take a look... Table of Contents 1: Adding strikethrough in [...]

Save Tons of Time: How to Create Named Ranges in Excel


Save Tons of Time: How to create Named Ranges in Excel Most of the time, we use cell references in our formulas. And most of the time, that works well. But Excel's ability to name cells and ranges can save you huge amounts of time when you're entering formulas. And they can help you [...]

Customizing Excel’s Quick Access Toolbar


Customizing Excel's Quick Access Toolbar The Quick Access Toolbar is easy to overlook. But by customizing it to your liking, you can access some of your most often-used commands faster than ever. If you use the same buttons in the Ribbon on a regular basis, the Quick Access Toolbar can save you a lot of [...]

How to Insert Tables and Data From Excel into Microsoft Word


How to Insert Tables and Data From Excel into Microsoft Word Microsoft Word is great for working on documents—but not so great with tables. If you want to put a table into a Microsoft Word document, you can work with Word's built-in table tools, or you can insert data directly from Excel. Guess which [...]

Need a Random Number Generator in Excel? Here are 2 Ways to do it


Need a Random Number Generator in Excel? Here are 2 Ways to do it You might be surprised at how often you need to generate random numbers in Excel. Maybe it's for an experiment or some type of hypothetical calculation. Or for whipping up a spreadsheet full of mock data. No matter the reason, [...]

How to Master the AND or OR Logical Functions in Excel


How to Master the AND and OR Logical Functions in Excel Most of Excel's functions deal with numbers and making calculations with them. But some functions have a different purpose: they resolve logical statements and display specific values based on the results. This might sound complicated, but it's actually pretty simple. And it can be extremely useful. [...]

Send this to friend