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

How to Find the Absolute Value in Excel (ABS Function)

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

How to Find the Absolute Value in Excel (ABS Function) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Numbers in Excel could either be positive or negative. Sometimes, due to formulas and calculations, the resulting numbers could be negative. Unfortunately, there are cases where you would want all the numbers in your spreadsheet [...]

How to Find the Absolute Value in Excel (ABS Function)2020-08-11T13:19:52+00:00

How to Mail Merge Using an Excel Spreadsheet and Word

2020-11-05T11:40:20+00:00

How to Mail Merge Using an Excel Spreadsheet and Word Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you’re not a fan of using expensive email platforms to send emails to a large list, knowing how to using mail merge is one of your best options. By using a combination of [...]

How to Mail Merge Using an Excel Spreadsheet and Word2020-11-05T11:40:20+00:00

How to Insert Excel Data into Word Like Tables, Files, and Spreadsheets

2020-10-16T15:25:16+00:00

How to Insert Excel Data into Word Like Tables, Files, and Spreadsheets Written by co-founder Kasper Langmann, Microsoft Office Specialist. 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 [...]

How to Insert Excel Data into Word Like Tables, Files, and Spreadsheets2020-10-16T15:25:16+00:00

How to Switch X and Y Axis in Excel

2020-10-16T14:20:37+00:00

How to Switch X and Y Axis in Excel (without changing values) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble.  Microsoft Excel is a powerful spreadsheet software that will let you store data and [...]

How to Switch X and Y Axis in Excel2020-10-16T14:20:37+00:00

How To Use Excel: A Beginner’s Guide To Getting Started

2020-10-16T14:14:55+00:00

How To Use Excel: A Beginner's Guide To Getting Started Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel is a powerful application—but it can also be very intimidating. That's why we've put together this beginner's guide to getting started with Excel. It will take you from the very beginning (opening a spreadsheet), [...]

How To Use Excel: A Beginner’s Guide To Getting Started2020-10-16T14:14:55+00:00