Microsoft Excel
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…
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…
Converting Excel to Word: A Step-by-Step Guide
Embarking on the journey of converting Excel data into Word documents opens a realm of possibilities, offering a seamless blend of numerical precision and document presentation finesse. In this tutorial, we unravel two user-friendly methods. The Copy-Paste method and the Insert method. The Copy-Paste method, marked by its simplicity and speed, is perfect for quick…
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…
