Advance Excel
Working with Functions and Formulas
- Working with Named Ranges
- Array Functions (SUMIF & AVERAGEIF)
- Formula Auditing
- Formulas with Absolute References
- Text Functions
- Financial Functions
Managing Tables in Microsoft Excel
- Creating Excel Tables
- Working with Records and Filters
- Advanced Filters
Data Tools in Excel
- Text to Columns
- Remove Duplicates
- Data Validation
- Consolidate
Grouping & Outlining and Subtotals
- Outlining and Grouping Data
- Using the Subtotals Tool
What-If Analysis
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
Advanced PivotTables & Chart
- Getting Started with PivotTables
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Formatting a PivotChart
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles
- Slicers
Advanced Excel Tasks
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks
Creating HLOOKUP and VLOOKUP Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
Advanced Conditional Formatting
- Editing Standard Formatting Rules
- Using Formulas in Conditional Formatting
Advanced Lookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using Index and Match with Array Formula
Advanced Functions in Excel
- Using Error Functions
- Using Logical Functions
- Using Array Formulas
