TUTORIALS
Featured Tutorials
Free Excel Tutorials
Over 200 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
How to Use Checkboxes in Excel
Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas and conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.
Excel Job Interview Questions by Position
In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.
Create a Pivot Table from Multiple Sheets
Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.
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
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.
PowerPoint Hacks
Do you know these 5 PowerPoint hacks? With these you can get your PowerPoint presentation done a lot faster. Not only that, but your presentation will also look more professional.
Outlook
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.
Outlook Search the Right Way
Outlook Search feature has improved! If you use it correctly you can find exactly what you're looking for. You can even search for words inside attachments! Read the full article to learn how to use Outlook Search correctly.
Power Automate
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.
Email from Excel with Attachments
Guess what? You can send bulk personalized emails directly from Excel with attachments. You don't need any VBA or external add-ins. It's really easy to set this up.
Power Automate in Excel
Learn to combine Microsoft Excel with Power Automate and get more done! We'll look at two practical examples: Record your working hours in Excel by clicking a button on your phone - AND - Post on LinkedIn from the comfort of your Excel file.
Google Sheets
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.
Google Sheets IMPORTRANGE Function
Learn how to use IMPORTRANGE in Google Sheets. This function is great when you'd like to import data from other spreadsheets. You can also use it together with QUERY to import and append data from multiple sheets.
Accounting
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.
Excel Functions for Accounting
Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)
Financial Leverage explained
In finance, leverage (or gearing) is about using debt (other people's money) rather than equity (your own money) for the purchase of an asset. This tutorial explains when this can be good for your business and when it can ruin your business.
Other Apps
PDF Electronic Bookmarks
Electronic bookmarks in a PDF document make it easy for your readers to quickly and easily move around in the document. They don't need to scroll back to the table of the contents to jump to specific section. Learn how to set up electronic bookmarks in your PDF.
Power Automate in Excel
Learn to combine Microsoft Excel with Power Automate and get more done! We'll look at two practical examples: Record your working hours in Excel by clicking a button on your phone - AND - Post on LinkedIn from the comfort of your Excel file.
Convert PDF to Word
In this PDF to Word tutorial, I show you how to easily convert an Adobe PDF file to a Microsoft Word file. All you need is Microsoft Word (2013 or later) in a Desktop version. You can edit the outcome in Word and then save again as PDF.