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!
How to Randomize a List in Excel (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Shuffling a list is easy to do in Excel. True, there are lots of random generators out there online. But if your data or list lives inside Excel, there’s no need to use some other platforms to [...]
How to Use Excel's Scenario Manager (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Have you been in a situation when you wanted to have different values in the same cell? Chances are, you created another sheet for it or worse, created a new file to compare your different scenarios. But did [...]
How to Use Sparklines in Excel to Show Trends (Fast & Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Excel, there are lots of graphs that you can add to your report (and Excel keeps on adding new charts). But what if you want to put a mini chart into a [...]
Circular Reference in Excel: How to Find, Enable, Use, or Remove Written by co-founder Kasper Langmann, Microsoft Office Specialist. One of the most common warnings users encounter in Excel is the circular reference error. In fact, you may already have seen a few of them already on your reports (which is probably how [...]
How to Headline Highlight Every Other Row in Excel - Fast and Easy Written by co-founder Kasper Langmann, Microsoft Office Specialist. Highlighting every other row makes it easier to read the contents of the spreadsheet. Some people also highlight their sheets to give it a bit of flair. In this article, you’ll [...]
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 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 [...]
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 [...]
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 [...]
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 [...]