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!


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

2018-08-28T08:55:22+00:00

How To Print An Excel Spreadsheet Like A Pro + Free Sample File Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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? [...]

How To Print An Excel Spreadsheet Like A Pro2018-08-28T08:55:22+00:00

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

2018-09-27T13:15:15+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 Need2018-09-27T13:15:15+00:00

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

2018-08-28T08:31:20+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 Clicks2018-08-28T08:31:20+00:00

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

2018-08-24T09:45:11+00:00

How To Use The COUNTIF Function in Excel (+COUNTIFS) Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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 [...]

How To Use The COUNTIF Function in Excel + COUNTIFS (NEW!)2018-08-24T09:45:11+00:00

How to Delete Blank Rows in Excel – The Right Way

2018-09-25T17:23:38+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 Way2018-09-25T17:23:38+00:00

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

2018-08-28T07:53:41+00:00

How to Insert a Checkbox in Excel ✔ 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 will be using your spreadsheet, [...]

How to Insert a Checkbox in Excel in 5 minutes (or less)2018-08-28T07:53:41+00:00

The Function COUNT Explained: Count Cells In Excel Easily [Ultimate Guide]

2018-08-22T10:37:11+00:00

The Function COUNT Explained: Count Cells In Excel (Easily) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Of all the things that Excel does, counting seems rather rudimentary. But you might be surprised by the power of Excel's COUNT function. And when you get into COUNT's sister functions, there are some really cool things [...]

The Function COUNT Explained: Count Cells In Excel Easily [Ultimate Guide]2018-08-22T10:37:11+00:00

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

2018-09-27T00:56:56+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 walk [...]

How to Create a Formula in Excel: Add, subtract, multiply, and divide (+more)2018-09-27T00:56:56+00:00

How to Transpose Data in Excel: Turn Rows into Columns

2018-08-28T08:06:49+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 Columns2018-08-28T08:06:49+00:00

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

2018-08-28T08:33:35+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]2018-08-28T08:33:35+00:00

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

2018-08-28T08:46:16+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)2018-08-28T08:46:16+00:00

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

2018-08-27T07:54:32+00:00

How To Find Duplicates in Excel And Then Remove Them (Or Merge) 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 [...]

How To Find Duplicates in Excel And Then Remove Them (Or Merge)2018-08-27T07:54:32+00:00

How To Use The Function AVERAGE To Calculate The Mean in Excel

2018-08-27T08:42:03+00:00

How To Use The Function AVERAGE To Calculate The Mean in Excel 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 [...]

How To Use The Function AVERAGE To Calculate The Mean in Excel2018-08-27T08:42:03+00:00

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

2018-08-28T07:41:51+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”2018-08-28T07:41:51+00:00

How To Use The HLOOKUP Function In Excel + Examples

2018-08-27T10:42:01+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 + Examples2018-08-27T10:42:01+00:00

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

2018-08-28T08:19:03+00:00

The Ultimate Guide to: Creating Pivot Tables in Excel 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 (2016). Pivot Tables make it easy [...]

Excel Pivot Table Tutorial: The Ultimate Guide to Creating Pivot Tables2018-08-28T08:19:03+00:00

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

2018-09-27T13:16:40+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 Need2018-09-27T13:16:40+00:00

VBA VLOOKUP: How to Use Worksheet Functions in VBA

2018-08-22T10:17:30+00:00

VBA VLOOKUP: How to Use Worksheet Functions in VBAWritten by co-founder Kasper Langmann, Microsoft Office Specialist.Visual Basic for Applications has many built-in functions that will help you work with spreadsheet data.But Excel is the undisputed king when it comes to useful functions.Fortunately, you can use worksheet functions to take advantage of that power when you’re writing macros [...]

VBA VLOOKUP: How to Use Worksheet Functions in VBA2018-08-22T10:17:30+00:00

How to Use For Loops in VBA

2018-08-28T09:51:46+00:00

How to Use For Loops in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. In programming, loops allow you to run commands multiple times. It's simple, but it’s one of the most powerful things you can do with VBA code. (And it saves you a huge amount of typing.) Let’s take a look [...]

How to Use For Loops in VBA2018-08-28T09:51:46+00:00

Using an Input Box with Your Macro in VBA

2018-08-22T10:18:12+00:00

Using an Input Box to Gather Data in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. Most of the time, you’ll write VBA code that uses values already present in your spreadsheet. But what if you want to get information directly from the user? Input boxes let you do just that. Instead of just [...]

Using an Input Box with Your Macro in VBA2018-08-22T10:18:12+00:00

How to Use IF Statements in VBA

2018-08-22T10:18:22+00:00

How to Use IF Statements in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. IF statements are some of the most foundational concepts in programming. They serve as the basis for many more complicated functions—if you understand them, you’re well on your way to becoming a VBA expert. But if you don’t have programming experience, [...]

How to Use IF Statements in VBA2018-08-22T10:18:22+00:00

How to Use Ranges in VBA

2018-08-22T10:18:30+00:00

How to Use Ranges in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you're working in VBA, you'll have to tell Excel which cells you want a particular command to apply to. To do that, you'll use Ranges. A range is simply a cell or collection of cells that you tell Excel to pay attention [...]

How to Use Ranges in VBA2018-08-22T10:18:30+00:00

How to Use the VBA Editor in Excel

2018-08-28T09:24:18+00:00

How to Use the VBA Editor in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel’s Visual Basic for Applications (VBA) editor is a very powerful tool. It lets you write and edit custom scripts that automate actions in Excel. In fact, when you record a macro it is stored in VBA code in the [...]

How to Use the VBA Editor in Excel2018-08-28T09:24:18+00:00

How to Make a Macro in Excel

2018-08-28T09:21:17+00:00

How to Make a Macro in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel is packed with great ways to save time—keyboard shortcuts, templates, the fill handle, and so on—but there's no better time-saving tool than a macro. A macro is a sequence of instructions that Excel will execute whenever you tell [...]

How to Make a Macro in Excel2018-08-28T09:21:17+00:00

How to Use Do Until and Do While Loops in VBA

2018-08-22T10:19:06+00:00

How to Use Do Until and Do While Loops in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. Like for loops, do until and do while loops are powerful concepts that you’ll find in most programming languages. And if you can master them in VBA, you’ll be prepared to create powerful scripts to work with [...]

How to Use Do Until and Do While Loops in VBA2018-08-22T10:19:06+00:00

VBA DIM: How to Declare Variables in VBA

2018-08-28T09:12:18+00:00

VBA DIM: How to Declare Variables in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. In VBA, like any other programming language, variables are important. They're one of the core parts of the language, in fact. A variable in programming is like a variable in math: it stands in the place of a value, [...]

VBA DIM: How to Declare Variables in VBA2018-08-28T09:12:18+00:00

How to Use Comments in Excel’s VBA Editor

2018-08-28T09:50:18+00:00

How to Use Comments in Excel's VBA Editor Written by co-founder Kasper Langmann, Microsoft Office Specialist. Like any scripts, Excel’s VBA modules can be very long and complicated to read. Basic VBA scripts are easy to work your way through. But once you start adding more variables and functions, it gets very difficult to figure [...]

How to Use Comments in Excel’s VBA Editor2018-08-28T09:50:18+00:00