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 Create and Use a KPI in Power BI (Step-by-Step)

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

How to Create and Use a KPI in Power BI (Step-by-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI has a basic KPI (Key Performance Indicator) visual that lets you show the progress of the actual vs the target. This is great especially if you need to measure progress or the [...]

How to Create and Use a KPI in Power BI (Step-by-Step)2019-12-28T10:05:41+00:00

Power BI isn’t available for Mac. Here’s how to fix that!

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

Power BI isn't available for Mac. Here's how to fix that! Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is a great business intelligence and analytics solution. With it, you can connect to a lot of data sources, find insights, make visualizations, share them with others, and even transform and model [...]

Power BI isn’t available for Mac. Here’s how to fix that!2019-12-28T10:05:49+00:00

How to Create a Gantt Chart in Power BI (Fast and Easy)

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

How to Create a Gantt Chart in Power BI (Fast and Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. A Gantt chart is one of the most effective ways to show project timelines. There’s just one problem when creating a Gantt chart in Power BI: Power BI has no built-in Gantt chart [...]

How to Create a Gantt Chart in Power BI (Fast and Easy)2019-12-28T10:05:57+00:00

How to Embed a Power BI Report in a Website (Fast and Easy)

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

How to Embed a Power BI Report in a Website (Fast and Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Embedding a Power BI report to a website is simple and relatively easy. You don’t need programming expertise to do it. In fact, all you have to do is copy and paste [...]

How to Embed a Power BI Report in a Website (Fast and Easy)2019-12-28T10:06:04+00:00

How to Share Power BI Reports with Your Colleagues (Easy)

2019-12-28T10:06:12+00:00

How to Share Power BI Reports with Your Colleagues (Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Knowing how to share a Power BI report with your colleagues is important. After all, your findings and insights would be pretty useless if you wouldn’t be able to share them with your organization. Fortunately, [...]

How to Share Power BI Reports with Your Colleagues (Easy)2019-12-28T10:06:12+00:00

How Forecasting in Power BI Works ( + Free Exercise File)

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

How Forecasting in Power BI Works ( + Free Exercise File) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Forecasting is important for business for a lot of reasons — improve the sense of direction, keep the business updated, improve budgeting, and others. Fortunately, it’s quite easy to do forecasting in Power BI. [...]

How Forecasting in Power BI Works ( + Free Exercise File)2019-12-28T10:06:18+00:00

How to Create a Calculated Column in Power BI (Step-by-Step)

2019-12-28T10:06:24+00:00

How to Create a Calculated Column in Power BI (Step-by-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. A calculated column in Power BI lets you add new data on your table and use them to create visuals. Though it’s not that difficult, familiarity with DAX (Data Analysis Expression) formulas as well as [...]

How to Create a Calculated Column in Power BI (Step-by-Step)2019-12-28T10:06:24+00:00

Power BI Best Practices: 10 Guidelines to Always Follow

2019-12-28T10:06:40+00:00

Power BI Best Practices: 10 Guidelines to Always Follow Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is one of the best business intelligence and analytics solutions out there. Whether you’re a new user or an advanced designer, you should always strive to improve the performance and security of your designs. [...]

Power BI Best Practices: 10 Guidelines to Always Follow2019-12-28T10:06:40+00:00

How to Create a Histogram in Power BI [Step-by-Step Guide]

2019-12-28T10:06:50+00:00

How to Create a Histogram in Power BI [Step-by-Step Guide] Written by co-founder Kasper Langmann, Microsoft Office Specialist. A Power BI histogram chart is a great way to illustrate the frequency distribution of your data.  There’s just one problem in creating a histogram in Power BI: You can’t find a built-in histogram visualization. [...]

How to Create a Histogram in Power BI [Step-by-Step Guide]2019-12-28T10:06:50+00:00

How to Use Filters in Power BI (Step-By-Step Tutorial)

2019-12-28T10:07:07+00:00

How to Use Filters in Power BI (Step-By-Step Tutorial) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI filters help you see the data you want to focus on.  For new Power BI users, setting up filters for reports might be a bit confusing especially that there are different types of filters. [...]

How to Use Filters in Power BI (Step-By-Step Tutorial)2019-12-28T10:07:07+00:00