MS Excel Advanced Course

Excel Advanced is for Excel Experts: you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

Content:

• General
  • Editing Standard Formatting Rules
  • Input Validate rules
  • Using Formulas in Conditional Formatting
  • Group and Outline
  • Filter and Sorting
• Excel Tables and Advanced Filter
  • Working with Excel tables
  • Copy specific datasets from sheets, workbooks or external data
• Consilidate
• Goal seek, consolidate and scenarios
• Using Form Templates
  • Creating Templates
• Advanced Excel Lookup Functions
  • VLookup Function
  • Hlookup Function
  • Using the Index Function, Using the Match Function, Index and Match Together
  • Using the Indirect Function
• Excel Advanced Functions
  • Using Error, Logical, Array, Rounding Functions
• Advanced Excel Pivot Table Tools
  • Importing Pivot Table Data,
  • Calculated Fields in Pivot Tables,
  • Showing Pivot Data as a Percentage,
  • Creating Custom Pivot Tables Styles
  • Pivot Charts
• Excel Macros
  • Creating, amending and deleting macros
  • Running macros
  • Macro menus, toolbars and shortcuts