Data Analysis using Microsoft Excel

16-17 Dec, 2020, Webinar Classroom Training

IPA Training is Registered with

Learn from the Best

Kelvin Ng
Microsoft Office 2016 Master Specialist
Microsoft Certified Trainer

 

Kelvin Ng Choo Kent is a highly experienced digital arts instructor and master trainer with more than 17 years of experience in the office automation consultation, graphic design, animation and print production arena. He is a graduate of Malaysian Institute of Art (MIA) And holds the distinction of being certified as Adobe Certified Expert (ACE), Microsoft Office 2016 Master Specialist MCP & MCT, Certified practitioner of Neuro-Semantics, Certified practitioner of Neuro-Linguistic programming & Certified practitioner of Hypnosis & Time-Lines.


Microsoft Certification

  • MICROSOFT CERTIFIED TRAINER (MCT) SINCE 2012
  • MICROSOFT OFFICE 2016 MASTER SPECIALIST (MOS)
  • MICROSOFT OFFICE EXCEL 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE WORD 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE POWERPOINT 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE ACCESS 2016 SPECIALIST (MOS)

Professional Qualifications

  • PSMB APPROVED TRAINER
  • CERTIFIED ETHICAL HACKER (CEH)
  • ADOBE CERTIFIED EXPERT (ACE)
  • CERTIFIED PRACTITIONER OF NEURO-SEMANTICS
  • CERTIFIED PRACTITIONER OF NEURO-LINGUISTIC PROGRAMMING
  • CERTIFIED PRACTITIONER OF HYPNOSIS & TIME- LINES


AREA OF EXPERTISE
Office Tools
Microsoft Office Suite (2003, 2007, 2010, 2013, 2016), Adobe Acrobat, Microsoft Visio


Soft Skill
Effective Presentation, Train The Trainer, Microsoft Office Business Application Coaching, Effective Communication


Graphic Design

Adobe Photoshop, Adobe Illustrator, Adobe Indesign, Quarkxpress, Adobe Pagemaker, Corel Draw, Corel Photo Paint

His Clientele



Venue Details

Webinar Classroom Training

Contact us

Juliany,
M - 012 2281 247
juliany@ipa.com.my

Michelle,
M - 019 363 7822
michelle@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Yvonne,
M - 012 201 1247
yvonne@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

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.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Identifying the Excel Data used in the report.
  2. Conducting Analysis using Historical Data.
  3. Better in managing a Database and searching of information quickly.
  4. Completing an Analysis Report in a Shorter time.
  5. Make 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
DAY 1
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
12.30

End of Day 1

DAY 2
9:00

ANALYZING DATA USING PIVOTTABLE

  • Basic PivotTable Interface
  • PivotTable Layout
  • Value Field Setting
  • Grouping and Filtering
  • Calculated Fields
10.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
12.30

End of Course