2024 Intake On-Going. Click to learn more.

Data Analysis With Microsoft Excel (Intermediate Level)

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 Microsoft Excel.

Learning Objectives

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

  • use the IF and VLOOKUP/HLOOKUP functions 
  • manipulate information 
  • apply sorting 
  • filter data 
  • use Sparklines to show data trend 
  • apply charting elements 


The learner must have attended Microsoft Excel (Basic) level training.

Target Audience

Participants who wants to create a report and perform calculation by using the Excel functions and features. 

Training Outline

  1. Working with Conditional Logic 
  2. Working with Lookup Tables 
  3. Manipulating Information 
  4. Managing List 
  5. Working with Database 
  6. Using Sparklines to Show Data Trends (ONLY available in Microsoft Excel 2010/2013/ 2016/2019/Excel for Office 365) 
  7. Working with Charts