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!


Quick Analysis Tool in Excel: Full Tutorial

2026-01-12T16:22:05+00:00

Quick Analysis Tool in Excel: Full Tutorial Are you tired of spending hours analyzing your data in Excel? Do you wish there was a faster way to make sense of all those numbers and charts? Well, look no further than the Quick Analysis tool in Excel! This powerful tool allows you to quickly [...]

Quick Analysis Tool in Excel: Full Tutorial2026-01-12T16:22:05+00:00

How to Remove Time From Date in Excel

2026-01-16T15:43:45+00:00

How to Remove Time From Date in Excel  Excel offers a variety of ways how you can present dates. Could be a short date, a long one with the date and the day, or the one with a timestamp to it. However, at times, you might not want your date in Excel to [...]

How to Remove Time From Date in Excel2026-01-16T15:43:45+00:00

How to Center a Worksheet Horizontally in Excel

2026-01-16T15:45:31+00:00

How to Center a Worksheet Horizontally in Excel It is not as simple to print an Excel sheet as it is to print a Word document. Most of the time, when you print Excel sheets, the data is not properly aligned on the page. Your dedicated work appears unprofessional as a result 😩 [...]

How to Center a Worksheet Horizontally in Excel2026-01-16T15:45:31+00:00

How many Rows and Columns in Excel? All Answers Here

2024-08-29T23:36:40+00:00

How many Rows and Columns in Excel? All Answers Here The number of rows and columns in Excel will have you jaw-dropped 😵 How many of them does Excel have? Let’s walk through the guide below to learn that. Download our free sample workbook for this guide here and jump right in. [...]

How many Rows and Columns in Excel? All Answers Here2024-08-29T23:36:40+00:00

How to Use AutoSum in Excel: Button and Shortcut

2026-01-12T16:28:22+00:00

How to Use AutoSum in Excel: Button and Shortcut If Excel can help you with complex calculations and data analysis, then solving for the SUM in Excel is a piece of cake 🍰 The SUM function is so popular and widely used that Microsoft Excel decided to add a special button for it [...]

How to Use AutoSum in Excel: Button and Shortcut2026-01-12T16:28:22+00:00

Create a Sankey Diagram in Excel: Step-by-Step

2026-01-12T16:31:19+00:00

Create a Sankey Diagram in Excel: Step-by-Step A Sankey diagram, also known as a Sankey chart, is a lovely flow diagram 😊 It shows the overview of the flow characteristics of complex processes visually. Fun fact: 💡 This was introduced by an Irish engineer named Matthew Sankey to illustrate the energy efficiency of [...]

Create a Sankey Diagram in Excel: Step-by-Step2026-01-12T16:31:19+00:00

When You Protect a Workbook Which Feature Becomes Blocked?

2025-06-06T09:00:27+00:00

When You Protect a Workbook Which Feature Becomes Blocked? So you got your Excel workbook protected already. What does this mean for you and other users? 🤔 Well, it's definitely not the end. There are still a lot of things you can do when your Excel workbooks are protected 👍 Learn more so [...]

When You Protect a Workbook Which Feature Becomes Blocked?2025-06-06T09:00:27+00:00

How to do RANK IF in Excel to Rank With Condition

2026-01-12T16:33:39+00:00

How to do RANK IF in Excel to Rank With Condition 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 because [...]

How to do RANK IF in Excel to Rank With Condition2026-01-12T16:33:39+00:00

How to Create an Area Chart in Excel

2026-01-12T16:35:34+00:00

How to Create an Area Chart in Excel An area chart mimics the idea of a line chart. The only difference between a line and an area chart is the shading between the lines of an area chart. An area chart shades the area covered by a dataset to show its volume. That’s [...]

How to Create an Area Chart in Excel2026-01-12T16:35:34+00:00

How to Find External Links in Excel

2026-01-16T15:48:20+00:00

How to Find External Links in Excel Are you tired of manually searching through your Excel spreadsheet to find external links? Look no further! ✋ In this quick guide, we'll show you how to locate and manage all your external links in Excel within seconds. Say goodbye to wasted time and hello to [...]

How to Find External Links in Excel2026-01-16T15:48:20+00:00