TUTORIALS

Excel
Teams
PowerPoint
Outlook
Power Automate
Google Sheets
Accounting
Other Apps

Featured Tutorials

  • Over 100 Free Excel tutorials

Free Excel Tutorials

Over 300 Excel Tutorials in ONE Place The links in this file are regularly updated. Check back to get the latest file. On my YouTube channel, I often get questions like: "Do you have a video on *specific* topic?" or "How can I do *this* Excel task?" Actually, a lot of the videos on my channel are from you. Get the Full

Excel

Excel What If Analysis Data Table

Excel's What-if Analysis Data Table allows you to quickly create simulations. This tutorial takes you through a simple example of how you can create a Data Table from scratch. If you've never used this feature, you need to check it out. It's like magic.

Power BI Drill-Through

What do you do when you're presenting a chart to the higher-ups and someone asks: "Show me the Details behind that?" If you've embedded your Power BI report in PowerPoint, you'll be like: "Let me show you!". Drill-through in Power BI is super easy to implement. You just need the right start. This tutorial shows you how.

Excel TEXTBEFORE TEXTAFTER Functions

Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want. Check out the post for more.

More

Teams

Office Scripts – Macros on the Web

This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

Microsoft Teams for Teachers

This Microsoft Teams guide for teachers, highlights 10 important features and tools of Teams for Education. These quick tips will make distance learning easier for teachers and students.

How to Use Microsoft Planner

In this step-by-step tutorial, learn how to use Microsoft Planner to track your tasks as well as the tasks of your team members. Microsoft Planner can be used in Microsoft Teams to make sure your team projects stay organized and on track.

More

PowerPoint

Power BI in PowerPoint

Power BI Reports in PowerPoint Building a super-cool Power BI dashboard with full interactivity (slicers, bookmarks, drill-through, etc.) can be quite satisfying. But what do you do if you need to present this interactive dashboard in a meeting where PowerPoint is your only means of presentation? Power Bi does have a

Office 2021 new Features

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

5 PowerPoint Tips

In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.

More

Outlook

Office 2021 new Features

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

Import Outlook to Excel with Power Query

Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I'll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import your Outlook data to Excel.

Mail Merge from Excel

Mail Merge is what you need if you'd like to create multiple letters, emails or documents with data from Excel. This way you can easily create invoices for your customers or send bulk personalized emails. You'll learn how to quickly get started with Merge Merge and save a ton of time.

More

Power Automate

Power Automate with Forms

It's super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

Office Scripts with Power Automate

Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

Office Scripts – Macros on the Web

This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

More

Google Sheets

Sheets – Unique List from Multiple Columns

How can you get a unique list of values based on multiple columns? Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you're done!

Top 10 Tips for Google Sheets

This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

Google Sheets QUERY Function

The Query function in Google Sheets is one of the most powerful functions in Google Sheets. It's easy to learn if you follow the rules laid out in this tutorial. You'll be able to solve any data analysis problem that comes your way.

More

Accounting

Learn Financial Analysis

The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.

Forecasting in Excel Made Simple

Did you know you can easily create a forecast in Excel? In the example, I use data from The Home Depot and forecast the next two quarters. It's really easy, even if you need to take seasonality into consideration.

More

Other Apps

Power BI Slicers

Power BI Slicers add interactivity to your reports. Managers love to slice and dice. But which Power BI slicers are available? Which should you choose? This tutorial will make you a master in Power BI slicers.

Power BI Drill-Through

What do you do when you're presenting a chart to the higher-ups and someone asks: "Show me the Details behind that?" If you've embedded your Power BI report in PowerPoint, you'll be like: "Let me show you!". Drill-through in Power BI is super easy to implement. You just need the right start. This tutorial shows you how.

What is Power BI

What is Power BI? What is Power BI used for? You see, there is a reason why companies are investing more and more in Power BI projects. Actually there are 4 reasons why Power BI is preferred to the competition. This tutorial explains it all in plain English.

More
All Tutorials