Microsoft Office
Macros and Basic VBA in Excel – Recorded Webinar
In this Macros and VBA in Excel Webinar we looked at how you create and edit a basic Macro in Excel. This webinar is aimed at users that are brand-new to Macros and VBA in Excel and teaches you the basics on how to use Macros to automate mundane tasks in Excel. In this 1-hour…
How to Create Professional Documents in Microsoft Word – Recorded Webinar
In this Professional Documents in Microsoft Word recorded webinar, we take you through a number of tips and tricks in Word to make your documents look great. Microsoft Word is incredibly feature-rich, yet many people only use the basics. In this Word tutorial, we teach you how to take your Word processing up a level!…
Compare Two Lists Using VLOOKUP
Suitable for users of Excel 2010, 2013, 2016, 2019, and Excel for Microsoft 365. OBJECTIVE Compare two lists using the VLOOKUP function in Excel. COMPARING LISTS WITH VLOOKUP EXPLAINED If you want to save yourself a huge amount of time in Excel when reconciling data, it’s worth taking the time to learn how to…
10 Microsoft Outlook Productivity Hacks
This Microsoft Outlook Productivity Hacks guide is suitable for users of Outlook 2013/2016/2019 and Outlook for Microsoft 365. OBJECTIVE Work smarter not harder in Microsoft Outlook with these 10 Outlook productivity hacks. HOW TO BE MORE PRODUCTIVE IN OUTLOOK Outlook has all bases covered when it comes to business communication. We can email, use…
Google Sheets vs Excel—The Ultimate Showdown
It’s 2021, and most of us have used both Google Sheets and Excel. But, have you ever thought about which among these tools is the better option? At some point in your career, you’d have to make the decision and choose one over the other. That’s why this Google Sheets vs Excel comparison is important….
The SUMIFS Function in Excel – SUMIF Multiple Columns
This SUMIFS Excel Function tutorial is suitable for users Excel 2013,2016, 2019 and Excel for Microsoft 365. OBJECTIVE Use the SUMIFS function in Excel to add numbers in a range of cells based on single or multiple criteria. What is the Excel SUMIFS Function? The SUMIFS Excel function is a much welcome enhancement to an…
How to Use Onedrive
This How to Use OneDrive tutorial is suitable for users of Microsoft 365. OBJECTIVE Learn how to use Microsoft OneDrive to store and manage files in the cloud. ONEDRIVE EXPLAINED OneDrive is Microsoft’s internet-based (cloud) storage platform. It’s offered for free by Microsoft to anyone with a Microsoft account and works in the same way…
How to Convert PDF to Word
This how-to convert PDF to Word tutorial is suitable for users Word 2016, Word 2019, and Word for Microsoft 365 OBJECTIVE Convert PDF File to a Microsoft Word Document. PDF FILES EXPLAINED PDF files have been around for years and have been the ‘go-to’ file format to protect a document from editing or accidental changes….
Breakout Rooms in Teams Tutorial
This Breakout Rooms in Teams tutorial is suitable for users of any version of Microsoft Teams. OBJECTIVE Use Breakout Rooms in Teams to divide meeting participants into sub-groups or rooms to facilitate brainstorming sessions, group exercises, and discussion. VIDEO TUTORIAL – BREAKOUT ROOMS IN TEAMS BREAKOUT ROOMS EXPLAINED In large meetings or training sessions,…
Productivity Hacks in Outlook – 1-Hour Recorded Class
Learn to supercharge your Outlook productivity with Simon Sez IT! In this recorded, live session, we look at a number of hints, tips and tricks to help you get the most out of Outlook, including: General best practice with email Using folders to manage mail Automatically filing mail using rules Using categories and flags Quickly…
How to Make a Formula in Excel – Excel Basics
This How to Make a Formula in Excel tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. OBJECTIVE Explore Excel functions and create simple formulas from scratch to perform calculations. FUNCTIONS AND FORMULAS EXPLAINED If Excel is known for one thing, it’s formulas. Being able to perform simple to very complex calculations by learning how to…
How to Create a Fillable Form in Word
Creating a fillable form in Word is easier than you might think. Forms are a brilliant way to capture data in the correct format. For example, if you have documents that you get people to fill out regularly, and you want some control over what those people write or the options they choose on the…