• +60 11-1088 8118
  • Mon - Fri 9am - 6pm

Data Analysis Using Microsoft Excel

About Data Analysis Using Microsoft Excel

This Advanced Microsoft Excel training class is designed for participants to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, and collaborate with others.

Course Duration

Who Should Attend This Course?

Participants who have intermediate skills with Microsoft Excel.

What Will You Learn?

At the completion of the training, candidates will be able to:
  • Create a Pivot Table
  • Audit and Analyse Worksheet Data
  • Utilize Data tools and Collaborate with others

Programme Outline

“MODULE 1: MANAGING DATA
  • Consolidating Information
  • Removing Duplicates
  • Configuring Data Validation
  • Converting Text to Columns
MODULE 2: OUTLINING AND GROUPING DATA
  • Outlining Data
  • Showing and Hiding Outline Details
  • Grouping Data
  • Creating Subtotals
  • Removing Outlining and Grouping
MODULE 3: DATA VISUALIZATION
  • Understand Types of Charts
  • Box & Whisker compare sets of data
  • Creating a Treemap Chart
  • Creating a Waterfall Chart
MODULE 4: ANALYZING DATA
  • Using Goal Seek
  • Using Data Tables
MODULE 5: USING SOLVER
  • Setting up the Worksheet
  • Running Solver
  • Generating Reports and Scenarios with Solver
  • Modifying Constraints
  • Setting Solver Options
MODULE 6: PIVOT TABLE
  • Creating a Basic PivotTable
  • Creating a Basic PivotChart
  • Using the PivotTable Fields Pane
  • Adding Calculated Fields
  • Sorting Pivoted Data
  • Filtering Pivoted Data
  • Creating Calculated Items
  • Creating Calculated Fields

Trainer

SENTHIVALU KRISHNASAMY

Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia

About Us

Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.

Services

  • Corporate Training
  • Competency Assessment
  • e-Learning
  • Platform Development

Help

© Copyright 2020 Elev8 asia sdn bhd - All Rights Reserved