TUTORIALS

Excel

Teams

PowerPoint

Outlook

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

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.

Show Changes in Excel

Excel Show Changes Feature lets you know who changed your data and formulas. You'll see the previous value below the current value. With Version History you can easily revert back to a previous version of your file.

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.

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.

Teams Meeting Share Your Screen

Properly sharing your screen in a Microsoft Teams meeting is really important because you want your audience to remember what you shared. Screen resolution and whether you share desktop or window is a big factor. How can you properly share a PowerPoint presentation? Let's find out.

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.

Import Outlook to Excel with Power Query

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.

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.

Power Automate with examples

Learn how to use Microsoft's Power Automate with examples. With Power Automate you get to automate boring and repetitive tasks across applications. We take a look at two examples: Bulk PDF creation and a Planner to Outlook automation.

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.

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.

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

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.

All Tutorials