Full program description

Data Analysis Fundamentals using Microsoft Excel (10994)

What's In It For Me

Understand what is data analytics and how Microsoft Excel can be used as a data analytical tools in the office.

Course Overview

This course is scheduled for launch in Q2 2018 - Q3 2018. To express your interest in this course, please fill up our form at https://www.surveymonkey.com/r/6MBPSFV. We will contact you when we get closer to course launch date.

The main purpose of the course is to give learner the ability to add analysis capabilities to Excel spreadsheets and to provide learner with a foundation to learn about more advanced data analytics with Excel or Power BI. 

Who Should Attend

This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Course Duration

2 Days / 14 Hours

Course Outline

Reporting in Excel

  • Filtering and Formatting Data
  • Charts

Excel Tables

  • Excel Data Tables
  • Summarizing Data

Pivot Tables and Pivot 

  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts

Dashboards

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Hierarchies

  • Hierarchies
  • Time Data

The Excel Data Model

  • Using an Excel Data Model
  • External Data

Explore an Excel Data Model

  • Add Multiple Tables
  • Create Relationships
  • Add External Data

Certification Obtained and Conferred by

Awarded NTUC LearningHub Certificate of Completion

Course Objectives

After completing this course, students will be able to:

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data

Pre-requisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Advanced working knowledge of Excel spreadsheets including formulas.

Medium of Instruction & Trainer

Medium of Instruction: English

Trainer: Trainee ratio is 1:20

Price