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: Watch the session here, and download the Excel file to follow along. Advanced Formulas…
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: Watch the session here. Get the…
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…
Getting Started in Power BI – Parts 1 & 2 (Recorded Webinars)
Part 1 In this Introduction to Power BI recorded webinar, we look at importing data into Power BI Desktop and how to start to prepare it for Power BI visualizations. Power BI is (as the name implies!), a very powerful business intelligence tool. If Excel isn’t cutting it for your data analysis and modeling, then…
How to Create a Pivot Table in Excel? — The Easiest guide
Learn how to create a pivot table in Microsoft Excel
Excel SUMIF vs SUMIFS – The Complete Guide
This article deals with the Excel SUMIF and SUMIFS functions. You’ll learn how to use them along with their key differences. In this article, I’ll cover: Difference Between Excel SUMIF and Excel SUMIFS Functions In your Excel journey, you’ll probably come across situations where you need to find the SUM for certain values only. Located…
Create an Excel Dashboard in 5 Minutes – The Best Guide
This Excel Dashboard tutorial is suitable for users of Excel 2013/2016/2019 and Microsoft 365. Objective Create a simple interactive Excel dashboard to display critical metrics in 5 minutes. This Guide Covers: Table Of Contents Objective Excel Dashboards Explained VIDEO TUTORIAL – EXCEL DASHBOARD Create an Excel Dashboard in 8 Simple Steps FAQs Creating an Excel…
How to Make An Excel Forecast Sheet in 3 Steps – The Best Guide
This Excel Forecast Sheet tutorial is suitable for users of Excel 2016/2019 and Microsoft 365. Objective Create an Excel forecast sheet to analyze and predict future sales. Display the historical and predicted values in a line chart using the Excel forecast sheet. This Guide Covers: Excel Forecast Sheet Explained Imagine this, you have been…
Excel Dynamic Array: 8 Must-Know Formulas
This Excel Dynamic Array tutorial is suitable for users of Excel for Microsoft 365. Objective Explore Microsoft’s NEW Excel Dynamic Array Functions and use them effectively to solve problems. This guide covers: Excel Dynamic Array Explained Dealing with an Excel array is quite complicated in itself, don’t you think? What if there is a…
