Description

When analyzing data in Excel, simple summary functions that add, count, and average are valuable. However, functions for categorizing and comparing your data separate the professionals from the amateurs. In this session, we will help you create a compelling skill set in Excel with useful and powerful functions.

• Categorizing your data with logical functions like IF and AND
• Comparing and combining data with XLOOKUP, FILTER, and other reference functions
• Summarize with SUMIFS, COUNTIFS, and AVERAGEIFS
• Work effectively with dates and times with NETWORKDAYS and other date functions