Name: Data Analysing & Reporting
Start: 2024-05-27T09:00
End: 2024-05-27T14:00
Location: AC Hotel Kuala Lumpur by Marriott (Formerly known as Vistana Kuala Lumpur)

IPA Training is Registered with

Venue Details

AC Hotel Kuala Lumpur by Marriott (Formerly known as Vistana Kuala Lumpur)
9 Jalan Lumut, Off Jalan Ipoh, 50400 Kuala Lumpur - 50400

https://www.marriott.com/en-us/hotels/kulka-ac-hotel-kuala-lumpur/overview/?scid=45f93f1b-bd77-45c9-8dab-83b6a417f6fe&y_source=1_ MTQ2NDU5MDEtNDgzL WxvY2F0aW9uLndlYnNpdGU%3D

Phone : (603) 4042 8000

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

MODULE 1: NAME RANGE
MODULE 2: WORKING WITH TABLE & DATA MANAGEMENT
MODULE 3: DYNAMIC ARRAY FUNCTIONS
MODULE 4: IF FUNCTIONS
MODULE 5: LOOKUP FUNCTIONS
MODULE 6: DATA VISUALISATION WITH CONDITIONAL FORMATTING
MODULE 7: WHAT-IF ANALYSIS
MODULE 8: PIVOT TABLE & PIVOT CHARTS
MODULE 9: SPARKLINE
MODULE 10: MANAGE & PROTECT FILE/SHEET

INTRODUCTION

This advanced Excel training course is designed specifically for spreadsheet users who are
already proficient and looking to take their skills to an advanced level.

Participants will use advanced techniques necessary to generate report using pivot tables, Advance Functions, analyze worksheet data and utilize data tools.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…

Converting and cleaning data to build impressive presentation in Excel.
Summarizing large data into dynamic reports using Query in Excel
Generating interactive reports using Pivot & Slicers
Being able to learn on data visualising techniques that will provide impactful and simplified summary of information.
Knowing about dynamic formulas to present your data.

WHO SHOULD ATTEND

This advanced Excel training course is designed specifically for spreadsheet users who are
already proficient and looking to take their skills to an advanced level.

Participants will be using advanced techniques necessary to generate report using pivot tables,
Advance Functions, analyze worksheet data and utilize data tools.

PREREQUISITES: To ensure success, each student is expected to have above average skills with Microsoft Excel.

METHODOLOGY

This training is Instructor Led Training – interactive lectures which includes discussions and
practical exercises

DAY 1

9:00	MODULE 1: NAME RANGE Understanding Named Ranges Name Range Rules Creating Named Ranges Using Named Ranges in Formulas

10.45

MODULE 2: WORKING WITH TABLE &
DATA MANAGEMENT

List Table vs Range Table
Create and manage List Table
Automatic calculation in tables
Sorting & Filtering Data in Table
Slicers in Table
Data Validation

12.00

MODULE 3: DYNAMIC ARRAY FUNCTIONS

UNIQUE Function (Office 2021 and above only)
SORT Function (office 2024 and above only)
FILTER Function (office 2024 and above only)
Sequence Function (office 2024 and above only)

1:00

Lunch

2:00	MODULE 4: IF FUNCTIONS Sumif, Countif, Sumifs, Countifs Maxifs & Minifs (Office 2019 and above only) Using AND & OR conditions Logical If & Ifs (Office 2019 and above only) If Error

3:45	MODULE 5: LOOKUP FUNCTIONS Vlookup Hlookup Vlookup Vs Index & Match Xlookup (Office 2021 and above)

5:00	End of Day 1

DAY 2

9:00	MODULE 6: DATA VISUALISATION WITH CONDITIONAL FORMATTING Applying Cel Highlights Applying Top, Bottom, and Average Rules Applying Data Bars and Icon Sets Creating a Customised Rule Editing Rules