TUTORIALS
Featured 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
Bulk Import PDF Files to Excel
Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy-paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the PDF data is immediately imported to Excel.
Excel Organizational Data Types
Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.
Excel VSTACK Function
This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.
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.
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.
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.
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.
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.
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.
Excel tips & tricks – stop doing these 7 things in Excel
Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.
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.
Other Apps
Excel Organizational Data Types
Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.
Power BI Tips & Tricks
Power BI can do THAT? Learn 10 quick tips to enhance your Power BI dashboards: Conditionally format charts, create a separate measures table, customize your own tool tips and a lot more.
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!