Microsoft Excel Tutorials: Including Free Practice Exercises!

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


Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

How to Print an Excel Spreadsheet like a Pro [8 Actionable Tips]

2019-10-15T13:09:51+00:00

How To Print An Excel Spreadsheet Like A Pro Written by co-founder Kasper Langmann, Microsoft Office Specialist. Printing your spreadsheets, aaah... At the surface, it's so simple. Just hit 'Print', right? Not so quick! Getting your spreadsheets to print well can be surprisingly difficult. Sometimes they split in weird places. Or you get just [...]

How to Print an Excel Spreadsheet like a Pro [8 Actionable Tips]2019-10-15T13:09:51+00:00

How to Calculate Percentages in Excel: The Exact Formulas You Need

2019-10-08T12:00:03+00:00

How to Calculate Percentages in Excel: The Exact Formulas You Need Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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 [...]

How to Calculate Percentages in Excel: The Exact Formulas You Need2019-10-08T12:00:03+00:00

How To Sort Data In Excel: Organize Your Data In A Few Clicks

2019-10-08T12:15:54+00:00

How To Sort Data In Excel: Organize Your Data In A Few Clicks Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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 [...]

How To Sort Data In Excel: Organize Your Data In A Few Clicks2019-10-08T12:15:54+00:00

How To Use The COUNTIF Function in Excel + COUNTIFS (NEW!)

2020-05-11T13:46:07+00:00

How to use the Excel-functions COUNTIF and COUNTIFS (new) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In this tutorial, I show you exactly how to use the 2 functions COUNTIF and COUNTIFS (which is new!). In short, these functions count the number of cells within a range that contain a specific value. A quick example: Say we [...]

How To Use The COUNTIF Function in Excel + COUNTIFS (NEW!)2020-05-11T13:46:07+00:00

How to Delete Blank Rows in Excel – The Right Way

2020-07-22T13:45:52+00:00

How to Delete Blank Rows in Excel — The Right Way Written by co-founder Kasper Langmann, Microsoft Office Specialist. There's something inherently irritating about spreadsheets with blank rows. Excel sets out your data so nicely—and then its hard work is interrupted by blank rows. It seems unjust. Fortunately, you can remove blank rows with just [...]

How to Delete Blank Rows in Excel – The Right Way2020-07-22T13:45:52+00:00

How to Insert a Checkbox in Excel in 5 minutes (or less)

2020-05-11T13:06:59+00:00

How to Insert a Checkbox in Excel in just 5 Minutes (or Less)✔ Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you use a spreadsheet to manage information, adding a checkbox seems like overkill. You can just type an "x" or a "1" wherever you might place a checkmark. But if many people [...]

How to Insert a Checkbox in Excel in 5 minutes (or less)2020-05-11T13:06:59+00:00

The Function COUNT Explained: Count Cells In Excel (Easily)

2019-10-16T11:52:28+00:00

The Excel-Function COUNT Explained: Count Values in Cells Written by co-founder Kasper Langmann, Microsoft Office Specialist. Of all the things that Excel does, counting seems rather rudimentary. But below the surface, there's so much more to it! I guarantee you're going to be surprised by the power of Excel's COUNT function :) And when you [...]

The Function COUNT Explained: Count Cells In Excel (Easily)2019-10-16T11:52:28+00:00

How to Create a Formula in Excel: Add, subtract, multiply, and divide (+more)

2019-10-16T13:05:10+00:00

How to Create a Formula in Excel: Add, Subtract, Multiply, and Divide (& more) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Learning how to create a formula in Excel is easy. If you have never known how to write a formula in your Excel spreadsheets, you are in the right place. This guide will [...]

How to Create a Formula in Excel: Add, subtract, multiply, and divide (+more)2019-10-16T13:05:10+00:00

How to Transpose Data in Excel: Turn Rows into Columns

2019-10-04T13:47:09+00:00

How to Transpose Data in Excel: Turn Rows into Columns (vice versa) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Reorganizing data in a spreadsheet can be a pain. Especially when you have to make big changes that a simple copy-and-paste won't fix. One of the common tasks that fall into this category is [...]

How to Transpose Data in Excel: Turn Rows into Columns2019-10-04T13:47:09+00:00

All Excel’s Date Functions Explained + Time Functions Too! [+5500 words]

2020-05-11T13:30:38+00:00

All Excel's Date and Time Functions Explained! Written by co-founder Kasper Langmann, Microsoft Office Specialist. This is the complete guide to date and time in Excel. It’s a whopping +5500 words (!), so be sure to bookmark it. The first part of the guide shows you exactly how to deal with dates in Excel. I [...]

All Excel’s Date Functions Explained + Time Functions Too! [+5500 words]2020-05-11T13:30:38+00:00

How To Password Protect An Excel File – Lock Cells and Formulas (Ultimate Guide)

2019-10-15T13:11:26+00:00

How To Password Protect An Excel File: Lock Cells and Formulas (Easily) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Excel, there are different ways that allow you to protect data and the integrity of your files. It's super important to know your way around protection Excel files. The most common use-case is [...]

How To Password Protect An Excel File – Lock Cells and Formulas (Ultimate Guide)2019-10-15T13:11:26+00:00

How To Find Duplicates in Excel And Then Remove Them (Or Merge)

2020-05-11T13:35:52+00:00

How to Find and Remove Duplicates in Excel (or Merge them) Written by co-founder Kasper Langmann, Microsoft Office Specialist. As an Excel spreadsheet grows, you start finding a host of new issues to deal with. Especially if it gets updated regularly, and even more so if it gets updated by multiple people. One of [...]

How To Find Duplicates in Excel And Then Remove Them (Or Merge)2020-05-11T13:35:52+00:00

How To Calculate The Average In Excel: Use The Function AVERAGE

2020-05-11T13:50:21+00:00

How To Calculate The Average In Excel: Use The Function AVERAGE Written by co-founder Kasper Langmann, Microsoft Office Specialist. Finding averages is often required when working with spreadsheets. It's a rather basic task—but Excel can do all sorts of great things with averages. In this tutorial, we'll take a look at the AVERAGE function, [...]

How To Calculate The Average In Excel: Use The Function AVERAGE2020-05-11T13:50:21+00:00

How to Freeze Cells, Rows, and Columns in Excel Using “Freeze Panes”

2020-05-11T13:45:37+00:00

How to Freeze Cells, Rows, and Columns in Excel Using "Freeze Panes" Written by co-founder Kasper Langmann, Microsoft Office Specialist. I bet you’ve been working in a spreadsheet that had so many rows, that as you scrolled down, you couldn’t see your headers? Remember the frustration of not remembering which column was what? It [...]

How to Freeze Cells, Rows, and Columns in Excel Using “Freeze Panes”2020-05-11T13:45:37+00:00

How To Use The HLOOKUP Function In Excel + Examples

2020-07-13T14:45:21+00:00

How To Use The HLOOKUP Function In Excel + Examples Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you're working with a small spreadsheet, it's easy to scan through and find the values you're looking for. When you start working with hundreds, thousands, or even tens of thousands of cells, though, that becomes [...]

How To Use The HLOOKUP Function In Excel + Examples2020-07-13T14:45:21+00:00

How To Create A Pivot Table In Excel: Pivot Tables Explained [Complete Guide]

2020-05-11T13:21:01+00:00

How to Create a Pivot Table in Excel [The Complete Guide] Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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. Pivot Tables make it easy to [...]

How To Create A Pivot Table In Excel: Pivot Tables Explained [Complete Guide]2020-05-11T13:21:01+00:00

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

2020-05-11T13:09:47+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 Need2020-05-11T13:09:47+00:00

How to Insert Pictures Into Excel Cells (Quick and Easy)

2020-08-11T13:18:04+00:00

How to Insert Pictures Into Excel Cells (Quick and Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. One of the frequently asked questions in Excel is how to insert a picture into a cell. As you may know, Excel has many uses and in some cases, it would really help if you [...]

How to Insert Pictures Into Excel Cells (Quick and Easy)2020-08-11T13:18:04+00:00

How to Compress Excel Files – Without Third-Party Software

2020-08-11T13:18:20+00:00

How to Compress Excel Files - Without Third-Party Software Written by co-founder Kasper Langmann, Microsoft Office Specialist. A simple rule is that the more data you have, the heavier the Excel file will be. There’s no going around with that. However, there surely are ways to help you compress your Excel files without [...]

How to Compress Excel Files – Without Third-Party Software2020-08-11T13:18:20+00:00

How to Grab The First Word of a Text String in Excel

2020-08-11T13:23:41+00:00

How to Grab The First Word of a Text String in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Is it possible to grab the first word of a text string in Excel? Yes, it definitely is! However, there’s no button that will do that. You would need to use a [...]

How to Grab The First Word of a Text String in Excel2020-08-11T13:23:41+00:00

How to Use Excel’s Status Bar (Tweak, Optimize, and Setup)

2020-08-11T13:18:42+00:00

How to Use Excel's Status Bar (Tweak, Optimize, and Setup) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel’s status bar is an interesting feature as it tells you different kinds of information. What’s even cooler is that you can customize and tweak it to show the type of information you want. [...]

How to Use Excel’s Status Bar (Tweak, Optimize, and Setup)2020-08-11T13:18:42+00:00

How to Select Multiple Cells in Excel – Fast and Easy

2020-08-11T13:18:52+00:00

How to Select Multiple Cells in Excel - Fast and Easy Written by co-founder Kasper Langmann, Microsoft Office Specialist. There are times when you need to select multiple cells in the spreadsheet. But what should you do to make this process faster? Should you use the ‘Shift’ key? ‘Ctrl’ key? 🤔 In [...]

How to Select Multiple Cells in Excel – Fast and Easy2020-08-11T13:18:52+00:00

How to Randomize a List in Excel (Step-By-Step)

2020-08-11T13:19:01+00:00

How to Randomize a List in Excel (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Shuffling a list is easy to do in Excel. True, there are lots of random generators out there online. But if your data or list lives inside Excel, there’s no need to use some other platforms to [...]

How to Randomize a List in Excel (Step-By-Step)2020-08-11T13:19:01+00:00

How to Use Excel’s Scenario Manager (Step-By-Step)

2020-08-11T13:19:10+00:00

How to Use Excel's Scenario Manager (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Have you been in a situation when you wanted to have different values in the same cell? Chances are, you created another sheet for it or worse, created a new file to compare your different scenarios. But did [...]

How to Use Excel’s Scenario Manager (Step-By-Step)2020-08-11T13:19:10+00:00

How to Use Sparklines in Excel to Show Trends (Fast & Easy)

2020-08-11T13:19:31+00:00

How to Use Sparklines in Excel to Show Trends (Fast & Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Excel, there are lots of graphs that you can add to your report (and Excel keeps on adding new charts). But what if you want to put a mini chart into a [...]

How to Use Sparklines in Excel to Show Trends (Fast & Easy)2020-08-11T13:19:31+00:00

Circular Reference in Excel: How to Find, Enable, Use, or Remove

2020-08-11T13:19:37+00:00

Circular Reference in Excel: How to Find, Enable, Use, or Remove Written by co-founder Kasper Langmann, Microsoft Office Specialist. One of the most common warnings users encounter in Excel is the circular reference error. In fact, you may already have seen a few of them already on your reports (which is probably how [...]

Circular Reference in Excel: How to Find, Enable, Use, or Remove2020-08-11T13:19:37+00:00

How to Highlight Every Other Row in Excel – Fast and Easy

2020-08-11T13:19:45+00:00

How to Headline Highlight Every Other Row in Excel - Fast and Easy Written by co-founder Kasper Langmann, Microsoft Office Specialist. Highlighting every other row makes it easier to read the contents of the spreadsheet. Some people also highlight their sheets to give it a bit of flair. In this article, you’ll [...]

How to Highlight Every Other Row in Excel – Fast and Easy2020-08-11T13:19:45+00:00