2022 Academy Intake On-going. Learn more

Data Analysis With Microsoft Excel (Intermediate Level)

Course Prerequisites

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 

Requirements

  • Basic understanding of data management concepts and constructs such as relational database tables
  • Know how different pieces of data logically relate to one another.

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