Advanced Microsoft Excel

 

Name of Course
Advanced Microsoft Excel
Course Overview
  • Naming Cells and Ranges
  • Using an Excel Analysis Table
  • VLOOKUP
  • Concatenation
  • Overview of Quick Analysis*
  • Creating Charts
  • Data Consolidation
  • The IF Function
  • COUNTIFS and SUMIFS Functions
  • Pivot Tables and the Data Model
  • Flash Fill
  • Data Validation
  • Use SparkLines (Excel 2010 and 2013 only)