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 Fix Arrow Keys Not Moving Cells in Excel (Scroll Lock)

2022-11-21T21:12:06+00:00

How to Fix Arrow Keys Not Moving Cells in Excel (Scroll Lock) We are talking about the times when out of a sudden, your Excel sheet starts behaving weirdly. As you press the arrow keys, you are not navigated to the cells up or down, right or left. Instead, your Excel sheet starts [...]

How to Fix Arrow Keys Not Moving Cells in Excel (Scroll Lock)2022-11-21T21:12:06+00:00

How to Make a Pie Chart in Excel: Step-By-Step Tutorial

2022-11-21T20:50:04+00:00

How to Make a Pie Chart in Excel: Step-By-Step Tutorial A pie chart (also known as a circle chart) pictures the proportion of different items in a data set. It is based on the idea of a pie, where each slice represents an individual item’s contribution to the total (the whole pie). Unlike [...]

How to Make a Pie Chart in Excel: Step-By-Step Tutorial2022-11-21T20:50:04+00:00

How to Make a Histogram in Excel – and Adjust Bin Size (2022)

2022-11-21T20:02:11+00:00

How to Make a Histogram in Excel - and Adjust Bin Size (2022) We love how simple it is to create charts in Excel. Like all others, making a histogram in Excel is similarly easy and fun. It helps you with data analysis, frequency distribution, and much more. 🎯 You can plot your [...]

How to Make a Histogram in Excel – and Adjust Bin Size (2022)2022-11-21T20:02:11+00:00

The Best 11 Excel Shortcuts You’ll Ever Need (With Examples)

2022-11-19T20:20:06+00:00

The Best 11 Excel Shortcuts You'll Ever Need (With Examples) They say, "Time is money" and who doesn't want to save on money? 😃 If you are short on time too, then this article is for you. Microsoft Excel offers plenty of keyboard shortcuts to help users work swiftly and efficiently. All you [...]

The Best 11 Excel Shortcuts You’ll Ever Need (With Examples)2022-11-19T20:20:06+00:00

Number Formatting in Excel: Step-by-Step Tutorial (2022)

2022-11-19T19:18:29+00:00

Number Formatting in Excel: Step-by-Step Tutorial (2022) We all know how to apply the basic numeric and text formats to cells in Excel. But do you know how you can add a desired number of decimals, scientific notations, currency symbols, and similar formats in Excel with only a click? No? This article is [...]

Number Formatting in Excel: Step-by-Step Tutorial (2022)2022-11-19T19:18:29+00:00

How to Enter in Excel: Start a New Line in a Cell (2022)

2022-11-19T18:04:33+00:00

How to Enter in Excel: Start a New Line in a Cell (2022) Did you try pressing enter in excel expecting the cursor to move to the next line but met disappointment? Yup, we have done the same. 😁 It simply happens because, unlike text editors, Excel does not let you move to [...]

How to Enter in Excel: Start a New Line in a Cell (2022)2022-11-19T18:04:33+00:00

How to Use the RANK Function in Excel + Formula Examples

2022-11-14T21:18:33+00:00

How to Use the RANK Function in Excel + Formula Examples The RANK function of Excel finds the relative position of a number from a range of numbers. At first, this may sound like no big deal.😊 But think of a list of numbers that goes beyond hundreds of rows. Can you still [...]

How to Use the RANK Function in Excel + Formula Examples2022-11-14T21:18:33+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 Use the Excel FORECAST Function Step-by-Step (2022)

2022-11-14T20:16:35+00:00

How to Use the Excel FORECAST function Step-by-Step (2022) Forecasting makes a crucial element of every business. Accurate business forecasting can help your business progress much faster than ever. But forecasting is usually not that simple. You’d need to have specialists (statisticians mostly) on board. Or you’d need to buy specialized forecasting software. [...]

How to Use the Excel FORECAST Function Step-by-Step (2022)2022-11-14T20:16:35+00:00

How to Sum a Column in Excel Step-By-Step (2022)

2022-11-14T19:05:50+00:00

How to Sum a Column in Excel Step-By-Step (2022) Excel is great at storing and calculating numbers. The simplest of all mathematical operations is the addition function (summing up numbers). Microsoft Excel offers an in-built function to sum numbers. 😉 And you’d be amazed to see how swift and smooth it gets to [...]

How to Sum a Column in Excel Step-By-Step (2022)2022-11-14T19:05:50+00:00