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).

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

How to Lock and Protect Excel Files with Passwords (+MUCH MORE)

2017-06-14T08:37:00+00:00

How to protect Excel files, sheets and formulas 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 where an Excel file is used by many stakeholders for some ongoing [...]

Send this to friend