Advanced Excel

Date: 7 – 8 May 2024
Virtual Instructor-Led Training (VILT).

Key Benefits of Attending
  • WORK faster with Excel to perform mundane tasks
  • SET UP and DESIGN a robust calculation model
  • APPLY the best functions and formulas to calculate your results
  • UNLEASH the power of dynamic array functions to build dynamic reports
  • IMPORT, CLEANSE and SHAPE your datasets from disparate sources using Power Query
  • CREATE a dynamic model based on multiple datasets using Power Pivot
  • SUMMARIZE data using pivot tables and custom reports