Microsoft Excel
Excel 365: Beginner to Advanced
Master Excel 365: From Beginner to Advanced Excel 365 is a powerful tool professionals use for data management, analysis, and reporting. Mastering its wide range of functions can transform how you work with information, making your tasks faster, smarter, and more insightful. This guide breaks down essential techniques at every level—beginner, intermediate, and advanced—to help…
Excel Formulas for Beginners: Level 1 – Recorded Webinar
Explore essential formulas every Excel beginner needs to know.
Excel Productivity Tips & Tricks – Recorded Webinar
Explore essential formulas every Excel beginner needs to know.
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…
How to do SUMIF in Excel with Multiple Columns
SUMIF in Excel The SUMIFS function in Microsoft Excel is a powerful tool for adding up numbers based on multiple criteria, expanding on the capabilities of the older SUMIF function, which only allows for a single criterion. This tutorial guides you through using SUMIF and SUMIFS, demonstrating their application in various scenarios. The overview begins…
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…
How to Merge Excel Files
Merging Multiple Files Managing and analyzing large volumes of information is crucial in today’s data-driven world. Microsoft Excel, a powerful tool for data manipulation, offers several methods to merge files from multiple worksheets or workbooks into a single, cohesive document. Whether you are a business analyst consolidating financial reports, a researcher combining datasets, or a…
