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 Find the Absolute Value in Excel (ABS Function)

2020-08-11T13:19:52+00:00

How to Find the Absolute Value in Excel (ABS Function) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Numbers in Excel could either be positive or negative. Sometimes, due to formulas and calculations, the resulting numbers could be negative. Unfortunately, there are cases where you would want all the numbers in your spreadsheet [...]

How to Find the Absolute Value in Excel (ABS Function)2020-08-11T13:19:52+00:00

How to Mail Merge Using an Excel Spreadsheet and Word

2020-08-11T13:20:01+00:00

How to Mail Merge Using an Excel Spreadsheet and Word Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you’re not a fan of using expensive email platforms to send emails to a large list, knowing how to using mail merge is one of your best options. By using a combination of Microsoft [...]

How to Mail Merge Using an Excel Spreadsheet and Word2020-08-11T13:20:01+00:00

Power BI Tutorial: Start Learning Power BI Today (For Free)

2020-02-07T09:58:40+00:00

Power BI Tutorial: Start Learning Power BI Today (For Free) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is a great business intelligence and analytics solution. Though packed with lots of functionality, it’s still fairly easy to use. However, not everyone has a knack for technology. That’s why we created [...]

Power BI Tutorial: Start Learning Power BI Today (For Free)2020-02-07T09:58:40+00:00

The 10 Best Power BI Visuals to Get Inspiration From

2019-12-28T09:41:47+00:00

The 10 Best Power BI Visuals to Get Inspiration From Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is one of the best business intelligence and analytics solutions. Microsoft’s BI solution is especially popular with its stunning and interactive visuals. And if you’ve been working with Power BI, it’s not hard [...]

The 10 Best Power BI Visuals to Get Inspiration From2019-12-28T09:41:47+00:00

How to Do Table Visualization in Power BI (Step-By-Step)

2019-12-28T10:04:25+00:00

How to Do Table Visualization in Power BI (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI has a table visualization you can use to view detailed data and the exact values. It’s exactly how a table in a spreadsheet program like Microsoft Excel looks like. How to create a table [...]

How to Do Table Visualization in Power BI (Step-By-Step)2019-12-28T10:04:25+00:00

How to Create Groups in Power BI: Get Overview of Your Data

2019-12-28T10:04:33+00:00

How to Create Groups in Power BI: Get Overview of Your Data Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Power BI Desktop, you can easily group the data points in visuals easily. It’s a great idea especially if you want to categorize the data points. So how do you create groups [...]

How to Create Groups in Power BI: Get Overview of Your Data2019-12-28T10:04:33+00:00

How to Set up Data Refresh in Power BI (Automatic & Manual)

2019-12-28T10:04:41+00:00

How to Set up Data Refresh in Power BI (Automatic & Manual) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is a great business intelligence and analytics tool you can use to visualize findings from your data quickly. However, it’s important to make sure your data is updated or else the [...]

How to Set up Data Refresh in Power BI (Automatic & Manual)2019-12-28T10:04:41+00:00

How to Create and Use Maps in Power BI (Ultimate Guide)

2019-12-28T10:05:18+00:00

How to Create and Use Maps in Power BI (Ultimate Guide) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Using a Power BI map is a great way to visualize data that represent locations. With visually appealing maps and easy-to-understand content, your users will be able to gain more insight into your data. [...]

How to Create and Use Maps in Power BI (Ultimate Guide)2019-12-28T10:05:18+00:00

How to Insert Images in Power BI (Step-by-Step)

2020-07-13T14:46:25+00:00

How to Insert Images in Power BI (Step-by-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Images are important for a lot of reasons. One of them is their ability to get the audience’s attention. In fact, that’s one of the reasons why Microsoft designed the visuals in Power BI to look stunning. [...]

How to Insert Images in Power BI (Step-by-Step)2020-07-13T14:46:25+00:00

Power BI: Desktop vs. Online – Pros and Cons

2020-07-13T14:41:22+00:00

Power BI: Desktop vs. Online — Pros and Cons Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is one of the most popular business intelligence and analytics solution in the world. But a lot of people get confused with Power BI products especially with the desktop and online versions. What’s the [...]

Power BI: Desktop vs. Online – Pros and Cons2020-07-13T14:41:22+00:00