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
Search in posts
Search in pages

How to Switch X and Y Axis in Excel

2019-10-16T13:42:41+00:00

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

How to Switch X and Y Axis in Excel2019-10-16T13:42:41+00:00

How to Unmerge Cells in Excel

2019-10-01T15:44:32+00:00

How to Unmerge Cells in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Being able to merge and unmerge cells greatly improves reporting and presentation. By definition, merging cells in Excel is a process where you join two or more adjacent cells into one larger cell. But sometimes, mistakes happen and you [...]

How to Unmerge Cells in Excel2019-10-01T15:44:32+00:00

How to Add a Trendline in Excel

2019-10-01T15:44:41+00:00

How to Add a Trendline in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel trendline is a great way to visualize the general trend in your data.  In total, there are 6 different types of trendlines in Excel you can use depending on the type of data you have. Furthermore, you [...]

How to Add a Trendline in Excel2019-10-01T15:44:41+00:00

How to Add and Remove a Watermark in Excel

2019-10-10T12:26:49+00:00

How to Add and Remove a Watermark in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Is it possible to add a watermark on your worksheets using Excel? Absolutely! Not only is it possible, but it’s also quite easy! To this date, there’s no built-in feature or a direct way in Excel [...]

How to Add and Remove a Watermark in Excel2019-10-10T12:26:49+00:00

How to Forecast in Excel

2019-10-16T12:56:58+00:00

How to Forecast in Excel: Analyze and Predict the Future Written by co-founder Kasper Langmann, Microsoft Office Specialist. Forecasting is important in businesses as it helps determine possible trends in the future.  In days past, it’s difficult to do forecasting by paper since forecasting involves a lot of computations especially when there are [...]

How to Forecast in Excel2019-10-16T12:56:58+00:00

How to Save an Excel Chart as an Image

2019-10-01T15:45:06+00:00

How to Save an Excel Chart as an Image Written by co-founder Kasper Langmann, Microsoft Office Specialist. Microsoft Excel is a great software program where you can analyze data and visualize them with charts and graphs. And sometimes, Excel users find themselves needing to use these charts and graphs as images.  Unfortunately, there’s [...]

How to Save an Excel Chart as an Image2019-10-01T15:45:06+00:00

How to Calculate the Correlation Coefficient in Excel

2019-10-01T15:45:13+00:00

How to Calculate the Correlation Coefficient in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. The correlation coefficient helps you determine the relationship between different variables. Looking at the actual formula of the Pearson product-moment correlation coefficient would probably give you a headache. Fortunately, there’s a function in Excel called ‘CORREL’ which [...]

How to Calculate the Correlation Coefficient in Excel2019-10-01T15:45:13+00:00

How to Insert Multiple Rows in Excel

2019-10-01T15:45:24+00:00

How to Insert Multiple Rows in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Inserting rows in Excel is one of the most basic, repetitive tasks you’ll come across. Adding one is quick and easy. But how do you manage if you need to add multiple rows? Sure, you can add one [...]

How to Insert Multiple Rows in Excel2019-10-01T15:45:24+00:00

How to Calculate Age from Date of Birth in Excel

2019-10-01T15:45:33+00:00

How to Calculate Age from Date of Birth in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. As of now, Excel has no special function that would let you calculate the age using the date of birth. However, just because there’s no special function for it doesn’t mean you can’t do it [...]

How to Calculate Age from Date of Birth in Excel2019-10-01T15:45:33+00:00

How to Print Mailing Labels from Excel (Address List Example)

2019-10-15T12:47:39+00:00

How to Print Mailing Labels from Excel (Address List Example) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Using Excel provides the ideal setting for storing and curating addresses for your mass mailing and labeling projects.  Mass printing and sending of mails could be hard work especially if you don't know how to [...]

How to Print Mailing Labels from Excel (Address List Example)2019-10-15T12:47:39+00:00