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

How to Change Case in Excel – A Complete Guide

2017-06-23T10:00:34+00:00

How to Change Case in Excel - A Complete Guide There are times when letter case in Excel needs to be changed or corrected. Doing the changes by hand is extremely boring. Not only that, it's also inefficient. In some cases, it's also close to impossible... ...Imagine changing letter case in large data sets or [...]

How to Delete Blank Rows in Excel – The Right Way

2017-06-23T08:31:18+00:00

How to Delete Blank Rows in Excel — The Right WayThere'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 a few clicks!First, we'll show you the manual way to do it, in [...]

How to Round in Excel using ROUND, ROUNDUP, and ROUNDDOWN

2017-06-23T08:31:10+00:00

How to Round in Excel using ROUND, ROUNDUP, and ROUNDDOWN Microsoft Excel offers a few different options for rounding numbers. The most generally useful and versatile of these is the ‘ROUND’ function. There are also a couple of other more specialized functions useful for rounding in Excel... ... These are the functions ‘ROUNDUP’ and [...]

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

2017-06-21T13:35:56+00:00

How to Insert a Checkbox in Excel in 5 minutes (or less) 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, or you're concerned about [...]

The Ultimate Guide To The Excel Function COUNT

2017-06-23T08:31:27+00:00

The Ultimate Guide To The Excel Function COUNT 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 you can do. Let's take a look at COUNT, [...]

Excel’s Functions MIN and MAX Explained

2017-06-21T12:35:42+00:00

The Functions MIN and MAX Explained Two of the more useful yet simple functions that Microsoft Excel offers are ‘MIN’ and ‘MAX’. These two functions find the smallest and largest value in an array. It could be an array of constants (literal values) or an array of cells (range of cells). Let's get into all [...]

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

2017-06-20T12:41:53+00:00

How to Create a Formula in ExcelAdd, subtract, multiply, and divide (+more)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 you through each step of how to write a formula in Excel [...]

How to Transpose in Excel: Turn Rows into Columns

2017-06-20T12:46:36+00:00

How to Transpose in Excel: Turn Rows into Columns (vice versa) 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 transposing—turning rows into columns, or columns into rows. Without [...]

Send this to friend