Designed for professionals looking to elevate their data management and analysis skills, this session dives deep into advanced Excel functions that can streamline your daily tasks. Whether you're looking to master Lookups, harness the power of Index/Match, or explore the versatility of Dynamic Arrays, this course offers practical insights to help you work smarter. We'll also cover how to use functions in combination with conditional formatting and other specialty tasks to create more efficient, dynamic, and visually compelling spreadsheets.
Learner Outcomes:
• Perform Complex Data Lookups: VLOOKUP, XLOOKUP
• Implement Index/Match Combinations: INDEX, MATCH
• Master Dynamic Arrays: SORT, FILTER, UNIQUE
• Activate Conditional Formatting to Highlight Rows with a Function
• Calculate Project Workdays: NETWORKDAYS
• Calculate Start and End Times and Convert Time Formats
• Create a Running Total
Speaker Name: Dawn Monroe
Recertification Points: 1
Host: Andrea Zweifel, iaapmkebd@gmail.com
Hosted by IAAP
