Intermediate Excel

Course Content

Formulas & Functions

• Lookup Functions: VLOOKUP, HLOOKUP
• Logical Functions (Advanced): IF (Nested IFs), AND, OR, NOT
• Statistical Functions: AVERAGEIFS, COUNTIFS, SUMIFS
• Financial Functions (Intro): PMT (Loan Payments), NPV (Net Present Value)
• Text Manipulation: Combining Text Functions for Complex Tasks
• Error Handling: Using IFERROR to Manage Errors in Formulas

Conditional Formatting

• Icon Sets: Adding Icons to Data Based on Values
• Custom Conditional Formatting: Using Formulas to Define Rules
• Managing Conditional Formatting Rules: Editing and Deleting Rules

Sort & Filters

• Advanced Filtering: Using Multiple Criteria, Wildcards
• Custom Filters: Creating Custom Filter 
• Criteria Filtering with Formulas: Using Formulas in Filter Criteria

Pivot Tables

• Creating Pivot Tables: Summarizing Data with Drag-and-Drop Interface
• Formatting Pivot Tables: Changing Layout, Number Formats
• Grouping Data: Grouping Dates, Numbers, and Text
• Calculated Fields: Adding Custom Calculations to Pivot Tables

Charts

• Advanced Charting: Creating Combo Charts, Scatter Plots, Bubble Charts
• Customizing Charts: Formatting Chart Elements, Adding Images
• Chart Templates: Saving Custom Chart Formats