Excel Intermediate

What you'll learn

• Advanced Lookups & References: Retrieve and cross-reference data dynamically across sheets and workbooks using XLOOKUP, VLOOKUP, HLOOKUP, and INDEX/MATCH.
• Conditional Logic & Text Manipulation: Build complex decision trees using nested IF, AND, OR, and clean messy text data using string manipulation functions.
• PivotTables & PivotCharts: Summarize, group, filter, and visualize large volumes of data dynamically using advanced PivotTables, calculated fields, and PivotCharts.
• Data Integrity & Validation: Enforce data entry standards, restrict cell inputs using Data Validation rules, and trace formula dependency errors.
• Dynamic Organization: Streamline workbook management and speed up repetitive tasks using Named Ranges, Flash Fill, and advanced data filtering.