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

Searchable Drop-Down Lists in Excel

It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

Excel Combine text and numbers

Learn practical and easy methods (including a hidden tip not many know about) to combine data from multiple cells into a single cell in Excel.

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

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.

PowerPoint Slide Design Tips

How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don't notice when we watch presentations we love. I've broken it down into 5 tips which you can apply to your PowerPoint slides.

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

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.

Top Excel Features for Accountants

Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.

More

Other Apps

How to Use Power BI

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!

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.

Excel – Switch Columns Multiple Values

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

More
All Tutorials