2022 Academy Intake On-going. Learn more

Microsoft Excel 2016 (Intermediate – Advanced)

About This Course

This course is designed for those with basic knowledge of Excel who wish to progress to the most complicated functions and features in Excel.

Learning Objectives

-

Prerequisites

-

Target Audience

Learners who want to create a report and perform calculation by using the Excel functions and features

Training Outline

  1. Working with Cell Reference
  2. Working with Conditional Logic
  3. Working with Lookup Tables
  4. Manipulating Information
  5. Working with Conditional Formatting
  6. Consolidating Data
  7. Managing List
  8. Working with Database
  9. Working with Charts
  10. Using Sparklines to Show Data Trends
  11. Working with PivotTable & PivotChart
  12. Using Protection in Excel
  13. Introduction to Excel Macro