Microsoft
Excel Formulas for Beginners – Recorded Webinar
Explore essential formulas every Excel beginner needs to know.
Using Excel for Data Forecasting and Insights – Recorded Webinar
Explore Excel data forecasting tools such as Forecast Sheet and What-If Analysis techniques.
Sorting and Filtering Data in Excel: FILTER, SORT, and SORTBY – Recorded Webinar
In this month’s webinar, you will learn about sorting and filtering data in Excel to help you organize and search your data and spreadsheets. Join your Excel expert, David Casuto, as he walks you through basic and custom sorting and filtering, clearing filters, and sorting and filtering by color. He will also teach you how…
Excel Formulas: Intermediate – Recorded Webinar
This free recorded webinar walks you through intermediate Excel formulas. This session is perfect if you have the basic foundation of Excel formulas or just want to brush up on some intermediate functions. Dave Casuto, your expert trainer, kicks off the session by looking at IF function and Data Validation before moving on to COUNTIF,…
Mastering Excel Lookups: VLOOKUP, HLOOKUP and XLOOKUP – Recorded Webinar
This month’s webinar introduces you to some essential lookup functions in Excel such as VLOOKUP, HLOOKUP, and XLOOKUP. Join David Casuto, your expert instructor, as he discusses Excel lookup functions, a handy tool for validating and analyzing data. This webinar covers the following: Watch the session here, and download the instructor demo file to follow…
Data Models, PivotTables, and Power Query in Excel – Recorded Webinar
This month’s webinar teaches you how to transform and analyze data using Data Models, PivotTables, and Power Query in Excel. Join David Casuto, your expert instructor, as he discusses PivotTables, Data Models, and Power Query. He will also cover the advantages and uses of these functions to work on your datasets, Power Pivot, and much…
Conditional Formatting in Excel – Recorded Webinar
In this month’s webinar, you will learn how to use conditional formatting in Excel to help you highlight important data visually and identify patterns and trends within your spreadsheets. Join your Excel expert, David Casuto, as he walks you through various conditional formatting preset rules and how to manage rules. He will also teach you…
Business Charts in Excel – Recorded Webinar
This month’s webinar teaches you the ins and outs of building business charts in Excel, helping you elevate your spreadsheet and Excel skills. Your Excel expert, Deborah Ashby, will walk you through standard and modern Excel charts and discuss chart best practices. You will also learn various chart types and more. This webinar covers the…
Add Interactivity with Form Controls in Excel – Recorded Webinar
In this month’s webinar, you’ll learn how to add interactivity to your spreadsheets using Form Controls and elevate your Excel game. Your Excel MVP, Deb Ashby, will discuss what Form Controls are. She’ll walk you through the types of Form Controls, such as combo boxes, checkboxes, and more, and how to create them. Deb will…
Create Formulas with LAMBDA in Excel – Recorded Webinar
In this month’s webinar, learn how to create your own formulas using LAMBDA in Excel, a powerful function that can help improve your spreadsheet efficiency. Your Excel expert, Deborah Ashby, will walk you through the concept of variables and how to use the LET function within formulas. Then, she’ll go through creating your own formulas…
Troubleshooting Errors in Excel Spreadsheets – Recorded Webinar
In this month’s webinar, you’ll learn some amazing tips and tricks for troubleshooting errors in Excel that can help improve your spreadsheet efficiency. Your Excel MVP, Deb Ashby, will walk you through some of the most common errors you will encounter when working with Microsoft Excel and help you understand what causes them. Learn how…
Introduction to Microsoft Forms – Recorded Webinar
In this recorded webinar, we dive into Microsoft Forms, where you can gain valuable insights on utilizing this powerful tool for creating surveys, quizzes, and feedback forms easily. Your expert host, Deb Ashby, will walk you through accessing Microsoft Forms and exploring the interface. Learn how to create your first form, add and edit questions,…