Advanced Excel

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc. Advanced Excel functions allow business organizations to increase their productivity and performance by easily sorting and filtering relevant information and using it for better decision making.


Duration

26 hrs

Course Content

  • Consolidate data across multiple sheets and workbooks
  • Working with Advanced Functions
  • Use protection for securing data
  • Analyzing Data
  • Use nested and lookup functions
  • Applying what if analysis
  • Use templates and pivot tables
  • Record simple macros and assign them

Course Certificate