Course

Excel: Level 01

This course will enable learners to perform advanced data operations using summarizing, data consolidations, filters ,advanced PivotTable techniques and build interactive dashboards in Excel.

24 Lessons

Outcomes:

By the end of the course, learners will be able to:

  • Perform descriptive and inferential statistical analysis in Excel
  • Use a range of reference and lookup function in data analysis
  • Perform data cleaning, preparation & validation in Excel
  • Construct and operate PivotTables using advanced techniques
  • Use advanced filters to analyse data in a list
  • Create a range of controls in a worksheet
  • Use goal seek to determine the values required to reach a desired result
  • Use Solver to solve more complex & intricate problems
  • Build dashboards in Excel
 Level:  01
Duration:  10 hours
Pre-requisites:  Excel: Level-0
 What’s next:  VBA in Excel

 

Click for information on earning credits for this course

« ‹ › » page 1 / 2