Intermediate Excel Certification 1. Advanced Formulas and Functions Logical Functions: IF, AND, OR, NOT Lookup and Reference: VLOOKUP, HLOOKUP, INDEX, MATCH Text Functions: MID, LEN, FIND, SUBSTITUTE Date and Time: EOMONTH, WORKDAY, NETWORKDAYS Math and Statistical: ROUND, RANK, COUNTIFS, SUMIFS 2. Data Management and Analysis Data Validation: Custom rules, dynamic dropdown lists Advanced Filtering: Complex criteria Sorting: Custom sort orders, multi-level sorting Conditional Formatting: Custom formulas, multiple rules 3. Advanced Charting and Visualization Chart Types: Combo charts, scatter plots, bubble charts Customization: Secondary axes, trendlines, error bars PivotCharts: Creating and customizing Dynamic Charts: Using named ranges and OFFSET 4. PivotTables Advanced Features: Calculated fields/items, grouping Data Source Management: External data sources Customization: Formatting, slicers, timelines 5. Advanced Data Tools What-If Analysis: Data tables, Scenario Manager, Goal Seek Solver: Introduction and optimization problems Data Consolidation: Multiple ranges/sheets 6. Advanced Excel Functions Array Formulas: TRANSPOSE, MMULT Dynamic Array Functions: UNIQUE, FILTER, SORT, SEQUENCE Error Handling: IFERROR, ISERROR 7. Macros and VBA Advanced Macros: Complex macros, editing VBA code User-Defined Functions: Custom functions with VBA User Forms: Designing and using forms 8. Collaboration and Workbook Management Track Changes and Comments: Managing changes and comments Protection: Advanced workbook/worksheet protection Shared Workbooks: Managing and resolving conflicts 9. Importing and Exporting Data External Data Connections: Databases, web data, other sources Text to Columns: Splitting text using delimiters Data Import Wizard: Importing various file types (CSV, TXT) 10. Advanced Features and Tips Named Ranges: Creating and using for formulas Custom Views: Managing different data perspectives Templates: Creating and using for standardized reports