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

How to Count How Many Times a Word Appears in Excel

2024-06-03T12:33:21+00:00

How to Count How Many Times a Word Appears in Excel When it comes to counting, Excel has a variety of functions to offer starting from the COUNT function to COUNTA, to COUNTIF and COUNTIFS function. Each of these functions has a unique counting feature of its own that aids in counting specific [...]

How to Count How Many Times a Word Appears in Excel2024-06-03T12:33:21+00:00

How to Add Commas to Numbers in Excel (Many Examples)

2024-06-03T12:32:37+00:00

How to Add Commas to Numbers in Excel (Many Examples) Try reading this number here 569000000000 😲 Failed? Or even if you managed to read it out aloud, it took you a good deal of time to parse the number? That’s alright – you are not to be blamed for it. Try reading [...]

How to Add Commas to Numbers in Excel (Many Examples)2024-06-03T12:32:37+00:00

How to Change Series Name in Excel (Step-by-Step)

2024-06-03T12:32:02+00:00

How to Change Series Name in Excel (Step-by-Step) If you frequently use Microsoft Excel to create charts and graphs, you’d know Excel is an excellent choice for data visualization through charts. While Excel can quickly visualize a given data series in the shape of charts and graphs, it also automatically names the data [...]

How to Change Series Name in Excel (Step-by-Step)2024-06-03T12:32:02+00:00

How to Paste Horizontal Data Vertically in Excel (Easy)

2024-06-03T12:31:40+00:00

How to Paste Horizontal Data Vertically in Excel (Easy) This tutorial is going to discuss some interesting methods to flip data in Excel. Fun Fact: The data remains the same, and any underlying formulas also remain the same. It is just that data sorted in a horizontal shape takes a vertical shape. In [...]

How to Paste Horizontal Data Vertically in Excel (Easy)2024-06-03T12:31:40+00:00

How to Change Legend Text & Name in Excel (Step-by-Step)

2024-06-03T12:31:01+00:00

How to Change Legend Text & Name in Excel (Step-by-Step) One of the many reasons why Excel outstands all other spreadsheet software is its excellent charts/graphs and other visual tools library. You can not only store data in Excel but also create charts and graphs out of it in Excel (very quickly and [...]

How to Change Legend Text & Name in Excel (Step-by-Step)2024-06-03T12:31:01+00:00

How to Stop Excel from Rounding (Works Every Time)

2024-06-03T12:30:27+00:00

How to Stop Excel from Rounding (Works Every Time) Excel is smart but might act a little over-smart at times (and that is never desired). One of the many instances of Excel acting over smart in places where it shouldn't be rounding off numbers automatically. Yes, rounding numbers makes them easier to understand [...]

How to Stop Excel from Rounding (Works Every Time)2024-06-03T12:30:27+00:00

How to Remove First Character in Excel (Many Examples)

2024-06-03T12:29:45+00:00

How to Remove First Character in Excel (Many Examples) Importing data into Excel from external sources? Or just got a sheet that's on you to sort but, the data looks super unstructured. This and many more reasons might make you want to remove the first character (or some beginning characters) from cells in [...]

How to Remove First Character in Excel (Many Examples)2024-06-03T12:29:45+00:00

How to Reference Another Sheet in Excel (Step-by-Step)

2024-06-03T12:29:22+00:00

How to Reference Another Sheet in Excel (Step-by-Step) An Excel sheet is quite big with 17.2 billion cells in it alone. Okay, yes. But this doesn’t mean that you necessarily must fit all your data into one sheet. Even if your data is spread across multiple sheets, you can still refer to it [...]

How to Reference Another Sheet in Excel (Step-by-Step)2024-06-03T12:29:22+00:00

How to Use Absolute Reference in Excel (Step-by-Step)

2024-06-03T12:28:23+00:00

How to Use Absolute Reference in Excel (Step-by-Step) Excel is a spreadsheet of cells – and each sheet has 17,179,869,184 cells. That’s 17.2 billion. A big number 🤯 You can use these cells to populate data and then refer them around your worksheet or workbook by using their cell reference. A cell reference [...]

How to Use Absolute Reference in Excel (Step-by-Step)2024-06-03T12:28:23+00:00

How to Add in Excel: Simple Guide for Beginners (2024)

2024-06-03T12:27:56+00:00

How to Add in Excel: Simple Guide for Beginners (2024) Adding up in Excel is a child’s play. However, there's not a single method for how you can add numbers in Excel. Many methods and smart shortcuts to achieve the sum of a given set of numbers in Excel await you in the [...]

How to Add in Excel: Simple Guide for Beginners (2024)2024-06-03T12:27:56+00:00