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!


How to Use the CEILING Function in Excel – and Why! (2024)

2024-08-29T23:00:50+00:00

How to Use the CEILING Function in Excel - and Why! (2024) Just like the name suggests – the CEILING functions rounds a number up🙈 How does it round the number up? And why use the CEILING function to round figures in Excel? All of this and much more await you in the [...]

How to Use the CEILING Function in Excel – and Why! (2024)2024-08-29T23:00:50+00:00

How to Check What Version of Excel You Have (1-minute)

2024-08-28T13:13:08+00:00

How to Check What Version of Excel You Have (1 Minute) Excel is a powerful tool used by millions of people to manage data and perform calculations. But so many versions of Excel can make it confusing to know which version you have installed 🤔 But don't worry. In this article, we'll show [...]

How to Check What Version of Excel You Have (1-minute)2024-08-28T13:13:08+00:00

How to Use the FLOOR Function in Excel Step-by-Step (2024)

2024-08-29T23:01:21+00:00

How to Use the FLOOR Function in Excel Step-by-Step (2024) Are you tired of manually rounding down your numbers in Excel? Say hello to the FLOOR function! It allows you to quickly round numbers down to the nearest specified multiple. In this guide, we'll see how to use the FLOOR function in Excel. [...]

How to Use the FLOOR Function in Excel Step-by-Step (2024)2024-08-29T23:01:21+00:00

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

2024-08-29T23:02:06+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 [...]

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)2024-08-29T23:02:06+00:00

Create a Table of Contents in Excel: Step-by-Step (2024)

2024-08-29T23:02:53+00:00

Create a Table of Contents in Excel: Step-by-Step (2024) In the world of data management, organization is key. And what better way to keep track of all your valuable information than with a Table of Contents? In this guide, we'll show you how to create a Table of Contents in Excel that will [...]

Create a Table of Contents in Excel: Step-by-Step (2024)2024-08-29T23:02:53+00:00

How to Rename a Sheet in Excel: Step-by-Step Guide (2024)

2024-08-28T12:57:39+00:00

How to Rename a Sheet in Excel: Step-by-Step Guide (2024) An Excel workbook has a maximum of 1,048,576 sheets! Right, we all (or most of us) know that. But let's say you have added tens of sheets to your book. Now how can you distinguish them🤔 By name. The tutorial below will teach [...]

How to Rename a Sheet in Excel: Step-by-Step Guide (2024)2024-08-28T12:57:39+00:00

How to Add Page Numbers in Excel: Step-by-Step (2024)

2024-08-29T23:03:33+00:00

How to Add Page Numbers in Excel: Step-by-Step (2024) Yes! You heard that right. In this guide, we will be telling you how to add page numbers to Excel. It might sound new to you if you haven’t done that before. But it’s going to be interesting📝 So, let's not wait any more, [...]

How to Add Page Numbers in Excel: Step-by-Step (2024)2024-08-29T23:03:33+00:00

How to Adjust Column Width in Excel: Step-by-Step (2024)

2024-08-28T13:15:26+00:00

How to Adjust Column Width in Excel: Step-by-Step (2024) Do you find yourself scrolling back and forth in Excel? The default column width might be the problem. Excel is an incredibly powerful tool for organizing and analyzing data. But sometimes, the default column width just doesn't cut it. Learn how to adjust column [...]

How to Adjust Column Width in Excel: Step-by-Step (2024)2024-08-28T13:15:26+00:00

How to Do Subtraction in Excel (Minus Formula Guide)

2024-08-28T12:55:23+00:00

How to Do Subtraction in Excel (Minus Formula Guide) Microsoft Excel is such a powerful spreadsheet program that can help you perform calculations from the most complex ones to the most basic ones💪 One of the four basic arithmetic operations is Subtraction. Subtracting in Excel follows the same method that we learned how [...]

How to Do Subtraction in Excel (Minus Formula Guide)2024-08-28T12:55:23+00:00

Excel Guide: Clicking and Dragging the Fill Handle (2024)

2024-08-28T13:17:03+00:00

Excel Guide: Clicking and Dragging the Fill Handle (2024) Fill Handle is Excel's most powerful yet underutilized feature of all time. Whether you're working with large datasets or complex formulas, mastering Fill Handle can save you hours of manual labor. In this guide, you will learn the two most important features of Fill [...]

Excel Guide: Clicking and Dragging the Fill Handle (2024)2024-08-28T13:17:03+00:00