Name: Excel Data Analysis Masterclass: Lookups, Logical Functions, Power Query & Pivot Table
Start: 2026-02-09T09:00
End: 2026-02-09T14:00
Location: AC Hotel Kuala Lumpur by Marriott

IPA Training is Registered with

Venue Details

AC Hotel Kuala Lumpur by Marriott
9 Jalan Lumut off Jalan Ipoh, Kuala Lumpur, Malaysia, 50400,

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

Phone : (603) 40428000

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

Session 1: Lookup and Logic Functions for Smarter Data Analysis
• Module 1: Mastering Lookup Functions
• Module 2: INDEX & MATCH
• Module 3: Logical Functions for Business Rules
• Module 4: Using IF with Other Functions
Session 2: Automation & Dynamic Reporting
• Module 5: Power Query for Data Transformation
• Module 6: Combining & Merging Multiple Tables
• Module 7: Pivot Tables for Interactive Reporting
• Module 8: Calculations in Pivot Table

INTRODUCTION

This 2-day hands-on course is designed for professionals who work extensively with Excel and want to master advanced data-handling techniques.

Participants will explore powerful Excel tools like lookup functions, logical operations, Power Query automation, and Pivot Table reporting to enhance data analysis, decision-making, and reporting efficiency.

LEARNING OBJECTIVES

Using LOOKUP functions effectively to retrieve, match, and cross-reference data
Applying logical formulas for decision-making scenarios
Cleaning, transforming, and combining data using Power Query
Summarizing and visualizing data dynamically with Pivot Tables

WHO SHOULD ATTEND

Executives, Analysts, and Professionals who handle large datasets in Excel
Admin and Operations Staff who need to automate reporting and data cleaning
Finance, HR, and Sales Personnel involved in tracking, validating, and summarizing
business data
Anyone with Basic Excel knowledge seeking to upgrade to advanced data-handling
and reporting techniques

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.

DAY 1

SESSION 1: LOOKUP AND LOGIC FUNCTIONS FOR SMARTER DATA ANALYSIS

9:00	MODULE 1: MASTERING LOOKUP FUNCTIONS VLOOKUP vs HLOOKUP : When and Why Using LOOKUP with multiple criteria

10.45

MODULE 2: INDEX & MATCH

INDEX & MATCH: Dynamic lookups beyond limitations
Approximate vs exact match scenarios

1:00

Lunch

2:00	MODULE 3: LOGICAL FUNCTIONS FOR BUSINESS RULES IF, IFS, AND, OR: Building logical statements Nested IFs and cleaner alternatives

3:45	MODULE 4: USING IF WITH OTHER FUNCTIONS Integrating IF with other functions Error handling with IFERROR and IFNA Complex formula using IF

5:00	End of Day 1

DAY 2

SESSION 2: AUTOMATION & DYNAMIC REPORTING

9:00	MODULE 5: POWER QUERY FOR DATA TRANSFORMATION Introduction to Power Query interface Importing from multiple sources: Excel, CSV, Text Cleaning data: split columns, handle blanks