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!


More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages

Excel Line Spacing: How to Adjust Line Spacing (2024)

2024-02-15T15:22:19+00:00

Excel Line Spacing: How to Adjust Line Spacing (2024) Sometimes, you may need to input a long text into your Excel spreadsheet. When you do, you need to make sure that it's organized and presentable, not only for your sake but for others as well😊 One of the many ways to do that [...]

Excel Line Spacing: How to Adjust Line Spacing (2024)2024-02-15T15:22:19+00:00

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)

2024-02-19T15:47:49+00:00

How to Calculate MEDIAN IF in Excel ("MEDIANIFS" Formula)Excel is a powerful tool that can help you easily analyze and manipulate data.One of the most useful functions in Excel is the median function, which helps find the middle value in a set of data.However, what if you only want to find the median of [...]

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)2024-02-19T15:47:49+00:00

How to SUM by color in Excel: Step-by-Step Guide (2024)

2024-02-15T15:21:39+00:00

How to SUM by color in Excel: Step-by-Step Guide (2024) Most of you know how to get the Excel SUM. It's one of the most basic Excel functions. What most people don't know is that you can get the Excel SUM by color, too 🤩 There is no built-in function for this but [...]

How to SUM by color in Excel: Step-by-Step Guide (2024)2024-02-15T15:21:39+00:00

How to do RANK IF in Excel to Rank With Condition (2024)

2024-02-15T15:22:04+00:00

How to do RANK IF in Excel to Rank With Condition (2024) Ranking values in Excel is something very common. And with the RANK function, that’s not even a problem. However, if you want to perform a conditional (or criteria-based) ranking in Excel, this might be a little problem at first 😣 That’s [...]

How to do RANK IF in Excel to Rank With Condition (2024)2024-02-15T15:22:04+00:00

Excel Not Responding – Here is How to Fix it (2024)

2024-02-15T15:21:00+00:00

Excel Not Responding - Here is How to Fix it (2024) Excel is a powerful tool used by millions of people around the world to handle data 💪🏻 However, it is common for Excel users to get issues with Excel files such as the Excel not responding error. This is such a frustrating [...]

Excel Not Responding – Here is How to Fix it (2024)2024-02-15T15:21:00+00:00

“Reference isn’t Valid” Excel Error: How to Fix (2024)

2024-02-15T15:21:14+00:00

"Reference isn't Valid" Excel Error: How to Fix (2024) When you're working in Excel to organize and analyze your data, you may encounter different types of Excel errors ⚠️ Getting Excel errors is so frustrating because it hinders you from getting work done 😩 The "Reference isn't Valid" error is one of the [...]

“Reference isn’t Valid” Excel Error: How to Fix (2024)2024-02-15T15:21:14+00:00

Excel Ran Out of Resources – How to Fix it Step-by-Step (2024)

2024-02-15T15:21:48+00:00

Excel Ran Out of Resources - How to Fix it Step-by-Step (2024) Microsoft Excel is an amazing tool that we can use to do our calculations. But, sometimes you get a headache with Excel when there are errors 😞 Most of the time you have to sort out these issues by yourself because [...]

Excel Ran Out of Resources – How to Fix it Step-by-Step (2024)2024-02-15T15:21:48+00:00

How to use the Excel functions TRUE & FALSE (Boolean)

2024-02-15T15:20:44+00:00

How to use the Excel functions TRUE & FALSE (Boolean) Written by co-founder Kasper Langmann, Microsoft Office Specialist. There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. For example, you might manage a sales team. You [...]

How to use the Excel functions TRUE & FALSE (Boolean)2024-02-15T15:20:44+00:00

How to Switch X and Y Axis in Excel (Flip Chart Axes)

2024-02-19T12:43:56+00:00

How to Switch X and Y Axis in Excel (Flip Chart Axes) 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 powerful spreadsheet software that will let you store data and make calculations on [...]

How to Switch X and Y Axis in Excel (Flip Chart Axes)2024-02-19T12:43:56+00:00

How to Print Labels From Excel: Step-by-Step (2024)

2024-02-15T15:21:56+00:00

How to Print Labels From Excel: Step-by-Step (2024) Mail Merge is one awesome feature that will help you create mass letters and email messages. But you can also use it to create and print mailing labels for your mailing list 😀 All you need to do is to prepare your label data in [...]

How to Print Labels From Excel: Step-by-Step (2024)2024-02-15T15:21:56+00:00

The 9 Best Project Management Templates for Excel (Free)

2024-02-23T12:11:52+00:00

The 9 Best Project Management Templates for Excel (Free) Project managers are known for their decisiveness and time management. A project's success depends on how a project manager identifies, plans, and employs the resources available for any given project (especially the timespan). If you, too, have a complicated project ahead of you that [...]

The 9 Best Project Management Templates for Excel (Free)2024-02-23T12:11:52+00:00

Free Excel Dashboard Templates (My Top-6)

2024-02-15T15:21:52+00:00

Free Excel Dashboard Templates (My Top-6) Excel dashboards are the difference between good and great data presentation. A well-built dashboard can breathe life into the most boring and mundane subjects. Simple Excel dashboards are easy enough to build if you follow a proper tutorial like ours here. But to truly wow your [...]

Free Excel Dashboard Templates (My Top-6)2024-02-15T15:21:52+00:00

How to Create Macros in Excel: Step-by-Step Tutorial (2024)

2024-02-15T15:21:04+00:00

How to Create Macros in Excel: Step-by-Step Tutorial (2024) Get ready to have your mind blown! 🤯 Because in this tutorial, you learn how to create your own macros in Excel! That’s right! And you don't need to know VBA (Visual Basic for Applications)! Instead, you will use the Excel macro recording feature [...]

How to Create Macros in Excel: Step-by-Step Tutorial (2024)2024-02-15T15:21:04+00:00

How to Recover an Unsaved Excel File (5 Free Solutions)

2024-02-15T15:19:31+00:00

How to Recover an Unsaved Excel File (5 Free Solutions) Losing an unsaved Excel file is a real pain🤕 Whether you lose an entire Excel spreadsheet or just the latest round of edits, it can take a lot of time to fix the problem. But don’t worry! In this guide, I’ve compiled the [...]

How to Recover an Unsaved Excel File (5 Free Solutions)2024-02-15T15:19:31+00:00

How to Insert a Checkbox in Excel (4 Uncomplicated Steps)

2024-02-23T12:37:10+00:00

How to Insert a Checkbox in Excel (4 Uncomplicated Steps) 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 ins [...]

How to Insert a Checkbox in Excel (4 Uncomplicated Steps)2024-02-23T12:37:10+00:00

How to Remove Blank Rows in Excel (3 Easy Methods)

2024-02-15T15:19:11+00:00

How to Remove Blank Rows in Excel (3 Easy Methods) Choosing the right method to remove blank rows in Excel is crucial - a wrong move can lead to lost data. Method 1: Remove all rows that contain only blank cells Method 2: Remove all rows that contain one or more blank cells Method [...]

How to Remove Blank Rows in Excel (3 Easy Methods)2024-02-15T15:19:11+00:00

How to use the VLOOKUP Formula in Excel (Example)

2024-02-26T11:37:25+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 VLOOKUP Formula in Excel (Example)2024-02-26T11:37:25+00:00

How to Add Axis Labels in Excel Charts (X and Y Titles)

2024-02-27T14:26:06+00:00

How to Add Axis Labels in Excel Charts (X and Y Titles) An axis label briefly explains the meaning of the chart axis. It's basically a title for the axis. Like most things in Excel, it's super easy to add axis labels, when you know how. So, let me show you 💡 If [...]

How to Add Axis Labels in Excel Charts (X and Y Titles)2024-02-27T14:26:06+00:00

How to Use INDEX MATCH With Multiple Criteria in Excel

2024-02-15T15:20:23+00:00

In this tutorial, you'll learn to use the MATCH INDEX functions with multiple criteria by following 5 easy steps. In the end, you'll have built a tool to search through your spreadsheet for information that you define. Don't miss this one!

How to Use INDEX MATCH With Multiple Criteria in Excel2024-02-15T15:20:23+00:00

How to Create a Drop-down List in Excel (in 60 Seconds)

2024-02-15T15:21:28+00:00

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.

How to Create a Drop-down List in Excel (in 60 Seconds)2024-02-15T15:21:28+00:00

How to Calculate NPV in Excel (NPV Formula Explained)

2024-03-18T08:58:46+00:00

How to Calculate NPV Using Excel (NPV Formula Explained) Net present value is a core topic of Financial Modeling. It discounts future cash flows to show their today's value 📆 But you’re not a finance person? That's alright. In the tutorial below, I am going to explain to you the concept of NPV, [...]

How to Calculate NPV in Excel (NPV Formula Explained)2024-03-18T08:58:46+00:00

How to Remove Formulas in Excel (and Keep Values)

2024-03-08T14:57:18+00:00

How to Remove Formulas in Excel (and Keep Values) Excel formulas are set to auto-update themselves as and when any input to them is changed 📋 While this is a plus point in terms of accuracy and speed, it might also become a downside in certain circumstances where you’d want the results to [...]

How to Remove Formulas in Excel (and Keep Values)2024-03-08T14:57:18+00:00

F4 shortcut not working in Excel? How to fix it!

2024-03-08T14:57:04+00:00

F4 shortcut not working in Excel? How to fix it! F4 is one of the most used shortcuts in Excel. It locks a reference, making it absolute to some extent depending on how many times you press it. Written in Excel terms, it "toggles absolute and relative references". If you can't [...]

F4 shortcut not working in Excel? How to fix it!2024-03-08T14:57:04+00:00

How to Move Rows in Excel (3 Fast & Easy Methods)

2024-03-08T14:56:55+00:00

How to Move Rows in Excel (3 Fast & Easy Methods) 🖋️ By Kasper Langmann, Certified Microsoft Office Specialist. 📅 Updated on February 13, 2024. Knowing how to move rows in Excel is as important as knowing how to copy and paste - it's essential. This is something you'd have to do [...]

How to Move Rows in Excel (3 Fast & Easy Methods)2024-03-08T14:56:55+00:00

The 7 Best Projectors for PowerPoint Presentations (2024)

2024-01-04T09:15:14+00:00

The 7 Best Projectors for PowerPoint Presentations (2024) Written by co-founder Kasper Langmann, Microsoft Office Specialist. All done with your PowerPoint presentation, and now it's time to rock the stage🎙 But have you checked on your projector? Does it do your presentation justice? Going out in the market – you’ll find [...]

The 7 Best Projectors for PowerPoint Presentations (2024)2024-01-04T09:15:14+00:00

The 7 Best PowerPoint Clickers on the Market (2024 Review)

2024-01-04T09:04:20+00:00

The 7 Best PowerPoint Clickers on the Market (2024 Review) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Want to step up your presentation game? A smart and reliable PowerPoint clicker is all you need🎯 It is a small wireless remote that fits in your hand. Use it to move between [...]

The 7 Best PowerPoint Clickers on the Market (2024 Review)2024-01-04T09:04:20+00:00

The 5 Best Laptops for Excel and Microsoft Office (2024)

2024-01-04T09:08:24+00:00

The 5 Best Laptops for Excel and Microsoft Office (2024) Written by co-founder Kasper Langmann, Microsoft Office Specialist. All laptops can open a spreadsheet. But as you're doing more advanced Excel tasks, and opening bigger spreadsheets, you need more power. Especially if you want to have 25 browser tabs open and [...]

The 5 Best Laptops for Excel and Microsoft Office (2024)2024-01-04T09:08:24+00:00

The 5 Best Keyboards for Excel Spreadsheets (2024 Update)

2024-02-08T14:55:16+00:00

The 5 Best Keyboards for Excel Spreadsheets (2024 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you've worked with spreadsheets for years, you already know how a good keyboard plays a part in maximizing efficiency with Excel. Maybe you came here looking for an upgrade? Tired of typing on [...]

The 5 Best Keyboards for Excel Spreadsheets (2024 Update)2024-02-08T14:55:16+00:00

The 5 Best Monitors for Excel and Spreadsheets (2024 Update)

2024-02-19T13:13:42+00:00

The 5 Best Monitors for Excel and Spreadsheets (2024 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Studies show that going from 1 to 2 monitors can increase your productivity by up to 42%. You definitely don't wanna miss that productivity increase! So, if you're looking into the best monitors [...]

The 5 Best Monitors for Excel and Spreadsheets (2024 Update)2024-02-19T13:13:42+00:00

The 5 Best Barcode Scanners for Excel Reviewed (2024 Update)

2024-02-13T11:18:50+00:00

The 5 Best Barcode Scanners for Excel Reviewed (2024 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you're using Microsoft Excel for stock, inventory, and tracking - you might as well pair it up with a barcode scanner to get data easier from the floor to the (Excel) sheet. [...]

The 5 Best Barcode Scanners for Excel Reviewed (2024 Update)2024-02-13T11:18:50+00:00