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
Post Type Selectors
Search in posts
Search in pages

How to Use COUNTIF in Excel: Step-by-Step (+COUNTIFS)

2023-01-27T17:33:51+00:00

How to Use COUNTIF in Excel: Step-by-Step (+COUNTIFS) The Excel COUNTIF function is a very smart mix of the COUNT and IF functions of Excel. Using this function you can count cells that meet a specified condition. And as it’s you who’s going to define the condition – so you have the world [...]

How to Use COUNTIF in Excel: Step-by-Step (+COUNTIFS)2023-01-27T17:33:51+00:00

Freeze Panes in Excel: How to Freeze Rows and Columns (2023)

2023-01-22T17:07:22+00:00

Freeze Panes in Excel: How to Freeze Rows and Columns (2023) Freezing here means locking particular rows/columns of Excel in place to enhance the readability of a worksheet. By freezing panes rows/columns in Excel, you can still view them when you scroll to other parts of the worksheet 🧐 The guide below will [...]

Freeze Panes in Excel: How to Freeze Rows and Columns (2023)2023-01-22T17:07:22+00:00

How to Lock Cells in Excel: Excel Protection Tutorial

2023-01-22T16:02:44+00:00

How to Lock Cells in Excel: Excel Protection Tutorial Protecting your data and maintaining the integrity of your files are super important nowadays. It's only safe to say that one needs to learn how. Better safe than sorry, right? 😉 Well, I have good news for you! Microsoft Excel provides different levels of [...]

How to Lock Cells in Excel: Excel Protection Tutorial2023-01-22T16:02:44+00:00

How to Remove Duplicates in Excel (and Find Them)

2023-01-21T18:45:48+00:00

How to Remove Duplicates in Excel (and Find Them) In an Excel spreadsheet, you’d often have to collate data from multiple sources. Sometimes from external sources (like webpages) too 🖨 And this might result in duplicates in your Excel sheet. So how can you remove them? By scanning your worksheet for dupes manually? [...]

How to Remove Duplicates in Excel (and Find Them)2023-01-21T18:45:48+00:00

How to Sort in Excel: Data and Columns (2023)

2023-01-19T12:02:31+00:00

How to Sort in Excel: Data and Columns (2023) When I say Excel is the most powerful spreadsheet software - that's not an exaggeration. Excel lets you do even the toughest of tasks with immense ease of use, let alone the simple ones. And what's simpler than sorting data? Excel offers a plethora [...]

How to Sort in Excel: Data and Columns (2023)2023-01-19T12:02:31+00:00

How to Use the HLOOKUP Function in Excel: Step-by-Step

2023-01-09T21:07:40+00:00

How to Use the HLOOKUP Function in Excel: Step-by-Step There are a total of four functions in Excel to look up a value. The LOOKUP, VLOOKUP, HLOOKUP, and XLOOKUP functions. Each of these has a different purpose and is useful in its own way. The Excel HLOOKUP function looks up values in a [...]

How to Use the HLOOKUP Function in Excel: Step-by-Step2023-01-09T21:07:40+00:00

How to Calculate Average in Excel (With Formula Examples)

2023-01-09T18:51:48+00:00

How to Calculate Average in Excel (With Formula Examples) What is average? It is simply the arithmetic mean of a given set of numbers. Averages are super easy to calculate – no doubt about that 🎉 But if your dataset gets long, it might be that easy to calculate averages manually. And who [...]

How to Calculate Average in Excel (With Formula Examples)2023-01-09T18:51:48+00:00

How to Print an Excel Spreadsheet on One Page (+ More)

2023-01-07T20:40:09+00:00

How to Print an Excel Spreadsheet on One Page (+ More) Trying to fit your big spreadsheet into 1 tiny page? As easy as it seems, printing Excel spreadsheets can be difficult if you don't know the pro tricks. And even more so if you're new to this software. Luckily, this guide has [...]

How to Print an Excel Spreadsheet on One Page (+ More)2023-01-07T20:40:09+00:00

How to Make A Percentage Formula in Excel: Step-by-Step

2022-11-14T20:49:09+00:00

How to Make A Percentage Formula in Excel: Step-by-Step We use percentages almost everywhere. For example, there's a 50% off this weekend, monthly sales have risen by 30%, you get an annual increment of 15%, etc. The percentage is a genius concept, and the best part – they are super easy to calculate. [...]

How to Make A Percentage Formula in Excel: Step-by-Step2022-11-14T20:49:09+00:00

How to Create a Formula in Excel Beginner Tutorial (2023)

2023-01-19T12:16:13+00:00

How to Create a Formula in Excel: Beginner Tutorial (2023) Excel is all about running calculations! And so creating and operating a formula in Excel is simple. An Excel formula is a combination of operators and operands. For example, 2 + 2 = 4 is a formula where 2s are the operands, plus [...]

How to Create a Formula in Excel Beginner Tutorial (2023)2023-01-19T12:16:13+00:00

How to Use the COUNT function in Excel (and COUNTA)

2022-11-03T07:04:06+00:00

How to Use the COUNT function in Excel (and COUNTA) Apart from storing and manipulating numbers, sometimes, you may want to use Excel to simply count numbers. For example, the number of students in a class, the number of items on a list, etc. To do so, Excel offers two functions, the COUNT [...]

How to Use the COUNT function in Excel (and COUNTA)2022-11-03T07:04:06+00:00

How to Transpose Data in Excel: Turn Rows into Columns (2023)

2023-01-19T12:22:17+00:00

How to Transpose Data in Excel: Turn Rows into Columns (2023) Did you ever happen to construct a data table in Excel? Where after it was all done, you realized that it would have made more sense the other way round? In such a situation, don’t rush to recreate the table altogether. Instead, [...]

How to Transpose Data in Excel: Turn Rows into Columns (2023)2023-01-19T12:22:17+00:00

How to Insert a Checkbox in Excel: Easy Step-by-Step Guide (2023)

2023-01-19T12:25:32+00:00

How to Insert a Checkbox in Excel: Easy Step-by-Step Guide (2023) If you want to collect user input in your spreadsheet there's no better way than the checkbox. User-friendly, slick-looking, and easy for you to work with. Well... After you learn it at least. If you're having a hard time understanding the [...]

How to Insert a Checkbox in Excel: Easy Step-by-Step Guide (2023)2023-01-19T12:25:32+00:00

How To Delete Blank Rows In Excel: Step-by-Step (2023)

2023-01-19T12:25:51+00:00

How To Delete Blank Rows In Excel: Step-by-Step (2023) Everyone hates empty rows in their data. Fortunately, there are 2 ways to remove all the blank rows in your spreadsheet - in just a few clicks. Which method fits you best comes down to this really important distinction: 1) "I want to delete [...]

How To Delete Blank Rows In Excel: Step-by-Step (2023)2023-01-19T12:25:51+00:00

How to use VLOOKUP in Excel for Dummies (2023 Tutorial)

2023-01-19T12:28:13+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 VLOOKUP in Excel for Dummies (2023 Tutorial)2023-01-19T12:28:13+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 Create A Pivot Table In Excel: Pivot Tables Explained [Complete Guide]

2020-11-05T11:18:23+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-11-05T11:18:23+00:00

Excel INDIRECT Function: Formulas and Examples (2023)

2023-02-02T19:26:00+00:00

Excel INDIRECT Function: Formulas and Examples (2023) Some functions of Excel are simply meant to amaze you. The INDIRECT function is also one of that lot 🙈 Technically speaking, it will not perform any operation, nor will it run any logical tests to return Boolean Values. It is a unique function that’s different [...]

Excel INDIRECT Function: Formulas and Examples (2023)2023-02-02T19:26:00+00:00

How to Import Text Files Into Excel: Step-by-Step Guide (2023)

2023-02-02T18:55:50+00:00

How to Import Text Files Into Excel: Step-by-Step Guide (2023) Don't you just wish you can magically import data that you need into a new usable format faster with nothing to do any manual work? 😩 Well, Microsoft Excel can grant your wish. Excel allows you to open other file formats such as [...]

How to Import Text Files Into Excel: Step-by-Step Guide (2023)2023-02-02T18:55:50+00:00

The 7 Best Excel Add-Ins in 2023: Full Excel Plugin Guide

2023-02-02T18:01:02+00:00

The 7 Best Excel Add-Ins in 2023: Full Excel Plugin Guide Microsoft Excel has a wide range of features and functionalities. But, there are situations when you need more powerful capabilities than Excel provides 💪🏻 Particularly when performing data analysis, regression analysis, and financial analysis. To increase the efficiency of Excel spreadsheets, there [...]

The 7 Best Excel Add-Ins in 2023: Full Excel Plugin Guide2023-02-02T18:01:02+00:00

The 7 Best Excel Alternatives: Free and Paid (and for MAC too)

2023-02-02T18:16:13+00:00

The 7 Best Excel Alternatives: Free and Paid (and for MAC too) Excel is the oldest, most versatile spreadsheet software out there. But just like all other applications, it has its fair share of limitations too. To reach the maximum potential of your computing and analysis skills, you need to explore more options [...]

The 7 Best Excel Alternatives: Free and Paid (and for MAC too)2023-02-02T18:16:13+00:00

How to use the VBA IF Statement: Step-by-Step (2023)

2023-01-30T20:33:21+00:00

How to use the VBA IF Statement: Step-by-Step (2023) 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, understanding how [...]

How to use the VBA IF Statement: Step-by-Step (2023)2023-01-30T20:33:21+00:00

How to Work with VBA Ranges in Excel: Full Guide (2023)

2023-01-30T20:48:46+00:00

How to Work with VBA Ranges in Excel: Full Guide (2023) 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 the range object. A range is simply a cell or collection of cells that you tell Excel to [...]

How to Work with VBA Ranges in Excel: Full Guide (2023)2023-01-30T20:48:46+00:00

How to use VLOOKUP in Excel VBA: Step-by-Step (2023)

2023-01-30T20:01:22+00:00

How to use VLOOKUP in Excel VBA: Step-by-Step (2023) Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data. But "normal" 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 [...]

How to use VLOOKUP in Excel VBA: Step-by-Step (2023)2023-01-30T20:01:22+00:00

How to Use Message Boxes in Excel: Step-by-Step Guide (MsgBox)

2023-01-30T20:23:31+00:00

How to Use Message Boxes in Excel: Step-by-Step Guide (MsgBox) In this article, we are going to show you how to create a message box in Excel. Also called an Excel message box (VBA style). If you do not have any experience with VBA, do not worry (make sure to check this out [...]

How to Use Message Boxes in Excel: Step-by-Step Guide (MsgBox)2023-01-30T20:23:31+00:00

How to Use the VBA Editor in Excel: Quick Guide (2023)

2023-01-30T19:50:45+00:00

How to Use the VBA Editor in Excel: Quick Guide (2023) 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 VBA editor. But [...]

How to Use the VBA Editor in Excel: Quick Guide (2023)2023-01-30T19:50:45+00:00