PLEASE CLICK HERE to view upcoming event. Information here is outdated

Data Analysis using Microsoft Excel

16-17 Dec, 2020, Webinar Classroom Training

IPA Training is Registered with

Venue Details

Webinar Classroom Training


Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • Understanding Data in Microsoft Excel
  • Data Management
  • Analyzing Data Using PivotTable
  • Analyze Data using What-If-Analysis

    Limited to 20 pax only
COURSE OVERVIEW

Data analysis is defined as a cleaning, transformation and modeling process for the identification of useful information in decision making in business. Data analysis attempts to collect valuable data and make a choice based on the analysis of the data.

COURSE LEARNING OUTCOMES (CLO)
  1. Classify the Excel Data used in the report.
  2. Perform Data Analysis using Historical Data.
  3. Perform Better in managing a Database and searching of information quickly.
  4. Show an Analysis Report in a Shorter time.
  5. Distinguish informed Decision using the right Analysis Tools.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom training with real life examples for business applications.
  • Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.

    Course Requirement
  • Participants should be able to use a PC at the beginner level
  • Basic knowledge and functionality of Microsoft Excel
  • Microsoft Office 2013 and above
COURSE OUTLINE
9:00

UNDERSTANDING DATA IN MICROSOFT EXCEL

  • What is Excel Data?
  • Excel Data Type
  • Advanced Number Formatting
  • Excel Referencing | Name Range
10.45

DATA MANAGEMENT

  • Understanding Database Concept
  • Data Range vs Table
  • Cleaning up messy Data
  • Sorting & Filtering Database
  • Database Functions
1.00

Lunch

2:00

ANALYZING DATA USING PIVOTTABLE

  • Basic PivotTable Interface
  • PivotTable Layout
  • Value Field Setting
  • Grouping and Filtering
  • Calculated Fields
3.45

ANALYZE DATA USING WHAT-IF-ANALYSIS

  • Understanding What-If-Analysis
  • Applying Goal Seek to achieve Target
  • Using Data Table to Test the Variables
  • Save all data set using Scenario
5.00

End of Course