Advanced Excel

Working with Functions and Formulas

  • Working with Named Ranges
  • Array Functions
  • Formula Auditing
  • Formulas with Absolute References
  • Text Functions
  • Financial Functions
  • Nested IF

Analyzing Data with Tables

  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

Data Tools in Excel

  • Data Validation
  • Consolidate
  • Sparkline
  • Date Functions
  • Age Calculations

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 Useful Pivot-Driven Views
  • Adding Interactivity with Pivot 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
  • Using the Indirect Function

Advanced Functions in Excel

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions