Live Classes
Excel for Beginners – Formula Bootcamp
In this members-only recorded webinar, we show you how to get started creating formulas in Excel. This 1-hour session is perfect if you are new to Excel or are just looking to brush up on the basics. Download the Excel workbook and follow along! In this session you will learn: What are formulas and functions…
Introduction to SharePoint Online – Recorded Webinar
In this Introduction to SharePoint Online recorded live class, we look at how to get started in the latest (Microsoft 365 version of SharePoint. In this one-hour SharePoint class, we look at: What is SharePoint? An Example of a SharePoint site The SharePoint Interface and Navigation Creating a Team Site Adding Web Parts to the…
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!…
Importing and Cleaning Data in Excel
In this recorded, Excel webinar we look at how to import and clean data in Excel. Cleaning data is one of the most important skills you’ll need in Excel. In this session we look at various formulas and functions to help you clean data in Excel, we then move on to using Power Query to…
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…
Advanced Formulas in Excel – 1 Hour Recorded Webinar
In this one hour, recorded live webinar, Deb Ashby takes us through some Advanced Formulas in Excel. Deb starts by looking at logical functions and two-way lookups before moving onto combining a number of more advanced functions to solve complex problems in Excel. Here’s what she covers in detail: Logical Functions (IF, IFS, AND, OR)…
The Ultimate Zoom Tutorial
In this Zoom tutorial, we look at both beginner and advanced zoom techniques to help you have the perfect conference call. If you’re new to Zoom, then welcome to 2020! Thanks to the small issue of a global pandemic, Zoom has taken off, even faster than its name implies :-). If you’re new to this…
Ten, Awesome, PowerPoint Hacks, Tips, and Tricks – Recorded Webinar
In this month’s, member webinar we turned our attention to Microsoft PowerPoint. Specifically, some really cool tips and tricks to make your presentations look professional. If you’re presentations look like they are straight out of 1995, then you probably need to improve your PowerPoint skills. Combine the right PowerPoint Animations, Fonts, Imagery, and Icons and…
Dynamic Array Functions in Excel (XLOOKUP, FILTER, UNIQUE, XMATCH): Webinar Recording
We were once again joined by Excel expert, Deb Ashby, who took us through the Array Functions introduced in Microsoft Excel a few years ago. These functions replace and improve upon some existing functions (XLOOKUP instead of INDEX, MATCH). In this Dynamic Array session Debs covers the following Excel Functions: FILTER RANDARRAY SEQUENCE UNIQUE SORT…
How to Use OneNote: Recorded Webinar
In this OneNote tutorial, we teach you how to get started using OneNote 2019/365 Desktop edition. OneNote is an incredibly useful note-taking tool if used effectively, and it comes packed with features to help you increase your daily productivity. In this session we cover: What is OneNote and why is it useful? Creating Notebooks, Sections…
Basic Forecasting in Excel: Recorded Webinar
In this Excel tutorial, we take you through some of the formulas and functions you can use to perform basic forecasting in Excel. Forecasting is essential to make sure you plan correctly in business and is used everywhere. Excel is packed with forecasting formulas and functions aimed at helping you predict future results based on…
