OTHER TUTORIALS

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.

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.

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.

Outlook Reply Templates

Easily create template replies in Outlook by saving your common responses. You can save it with all the formatting you want. Let me show you how.

Electronic Signatures

In this tutorial I'll show you 3 free options you can use to create and insert your electronic signature in a PDF document, WORD or any other document of your choice. This makes it easy to sign pdf or other documents really fast.

Excel vs. Google Sheets

Let's take a look at 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

Google Sheets vs Excel

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

OneNote Tips and Features

Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.

Windows 10 Top Tips & Tricks

Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!

Practical Excel Dashboard (Excel Hash 2019)

A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given four Excel features and asked to create a solution

Top 5 Excel Interview Questions

Top 5 Excel Interview Questions Over the past three decades, Excel has become the de facto standard spreadsheet program for businesses and individuals around the world.  Excel accounts for an estimated 800 million users which translates to approximately 80% of all spreadsheet users. When entering the business world, a user whose

  • 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

Excel Dynamic Arrays – Excel will never be the same

Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for

  • #ExcelHash challenge Excel

First Excel Hash Challenge between 6 MVPs

What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from Excel on Fire and myself: Leila Gharani. On September

Excel Power Query, Power Pivot & Power BI Resources

Excel Power Query, Power Pivot & Power BI Resources Some useful resources that will make you a data analysis pro A popular question from readers is: "Do you have any Power Query or Power Pivot courses?" I don't. At least not yet. But let me share with you my list of