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