Microsoft Office
-
Advanced Formulas in Excel (1-Hour Recorded Webinar)
This recorded live webinar walks you through some advanced formulas in Excel. Deb Ashby, your professional trainer, kicks off the session by looking at the popular VLOOKUP formula before moving on to lookups with multiple criteria, and much more! Deb discusses: VLOOKUP with wildcards Lookups with duplicate lookup values Combining and splitting text INDEX and…
-
How to Create a Timeline in PowerPoint? 2 Proven Methods
(Note: This tutorial on how to make a flowchart in PowerPoint is suitable for PowerPoint 2013 and later versions including Office 365) Timelines are a great way to represent a sequential flow of events. Timelines are used from a high school to corporate events to show the progression of certain events, processes, and projects. In presentations,…
-
Get the Most Out of Microsoft Teams (1 Hour Recorded Webinar)
This Microsoft Teams webinar walks you through some of the essential tips and tricks to get the most out of this fantastic communication software. Teams is part of the Microsoft 365 suite and is a popular workplace messaging and videoconferencing tool, plus more! Deb Ashby, your professional trainer, discusses: What’s the difference between Teams versions?…
-
Lookup Functions in Excel – (Recorded Webinar)
This Lookup Functions in Excel webinar introduces some essential functions like VLOOKUP, HLOOKUP, and more. Excel lookup functions are a handy tool to validate and analyze your data. Deb Ashby, your professional trainer, discusses: What are Lookup Functions? A Basic Example of a Lookup VLOOKUP (Exact Match) VLOOKUP (Approx. Match) HLOOKUP The Limitations of VLOOKUP…
-
Advanced PowerPoint Hacks 2022 – (Recorded Webinar)
This Advanced PowerPoint Hacks webinar introduces some amazing tips and tricks. Microsoft PowerPoint is a great tool for creating slideshows and presentations. Deb Ashby, your professional trainer, discusses: Crop and Fill Transparent Overlays Selecting and Aligning Objects (Selection Pane) Filling Shapes the Right Way! The Morph and Advanced Morph Transition Merging Shapes The Eyedropper Tool…
-
How to Use Logical Functions in Excel ? – (Recorded Webinar)
This how-to-use Logical Functions in Excel webinar introduces some essential functions. Excel functions are a handy way to evaluate and analyze your data. Deb Ashby, your professional trainer, discusses: What are Logical Excel Functions? Simple Logical Tests Logical Operators Adding Meaning using IF Statements Using Sum and IF to Perform Logical Calculations Working with AND…
-
What’s New in Windows 11 – Recorded Webinar
In this Windows 11 tutorial, we explore all the new features introduced with the Windows 11 operating system. Specifically, we look at: Downloading and installing Windows 11 Task Bar and Start Menu Pinning items to the Task Bar Personalizing the desktop Using search Multiple desktops Widgets Snap layouts Quick Settings Microsoft Store Inbuilt applications This…