Advanced Excel Training

You will gain knowledge of Excel fundamentals, data visualisation, data validations, page setup and security, Advanced Excel, Advanced formatting in Excel, pivot table work, auditing worksheets, Advanced data tools, Excel macros, and VBA programming. Workshops and practical projects are part of our curriculum.

Advanced Excel Training Overview

Our Advanced Excel training course will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.

Wait!
Before You Leave,

Enjoy an Exclusive 50% Discount on Your Course Fee.

Simply enter your details below to claim your discount and take the next step in your learning journey!

Key Topics Covered

  • Introduction To Excel
  • Basic Formatting
  • Lookup
  • Pivot Table
  • Filter
  • Paste Special
  • If Function
  • Name Manager
  • Data Validation
  • Consolidate
  • Data Import to Excel
  • Offset Dynamic Drop Down
  • Sum with Indirect Function
  • Advanced Two-Way Lookup
  • Scenario Manager
  • Goal Seek
  • Group & Ungroup
  • Subtotal
  • Data Table
  • Chart
  • Excel Production
  • Conditional Formatting
  • Macros using VBA
  • User defined functions using VBA
  • Create data entry forms using user form
  • Excel Functions