Name: Microsoft Excel: Beginner to Intermediate
Start: 2025-04-14T09:00
End: 2025-04-14T14:00
Location: Wyndham Grand Bangsar Kuala Lumpur

IPA Training is Registered with

Venue Details

Wyndham Grand Bangsar Kuala Lumpur
No 1, Jalan Pantai Jaya, Tower 3, 59200 Kuala Lumpur, - 59200

https://wyndhamgrand bangsarkl.com.my/

Phone : (603) 2298 1888
Fax : (603) 2298 1999

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: Introductions to the Excel Components
Module 2: Spreadsheet
Module 3: Data
Module 4: Diagrams
Module 5: Calculation
Module 6: Calculating With Formulas
Module 7: Conditional Formatting
Module 8: Sparklines
Module 9: Charts
Module 10: Date Functions
Module 11: VLOOKUP

OBJECTIVE

This course is designed to allow the participants to understand the base of Excel, how it functions, and the essential knowledge needed before going into usage of functions & formulas. The course also shows how to utilize the functions, formulas and how to manage data with Excel.

The objective of this course is to provide participants with Microsoft Excel tools and in-depth formulas and functions that are available in Excel to reduce redundant tasks, increase productivity, and create powerful reports and summaries.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…

Working On Sample Spreadsheets Doing Basic Math, Adding And Deleting Columns And Rows, And Preparing The Worksheet For Printing.
Learning The Importance Of Using Table In Data Management.
Presenting Your Data Visually Showing Trends, Patterns And Comparisons Between The Data In A Chart, Table Or Other Templates.
Learning How Excel Will Automatically Do All The Calculations For You Once You Add In The Formula.
Applying Proper Formula And Function.
Troubleshooting Errors.

WHO SHOULD ATTEND

This course is suitable for all corporate users in involved in Sales, HR, Admin, Operations, Finance, Project Management, Engineers, Supervisors, Business Executives who need to do reports with Microsoft Excel.
All Professionals who want to expand their knowledge and skills in Microsoft Excel.

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

9:00	MODULE 1: INTRODUCTIONS TO THE EXCEL COMPONENTS What functions are available in excel. Brief on shortcuts and buttons.

10.45

MODULE 2: SPREADSHEET

How to create spreadsheets.
Rename the spreadsheet.
How to save worksheet.
Open the saved worksheet.

12.00

MODULE 3: DATA

Insert raw data to the cells.
Choosing proper format for the data.
Create tables.
Setup title for the data.

1:00

Lunch

2:00	MODULE 4: DIAGRAMS How to create diagram based on data entered. Choosing proper diagram. Edit settings of the diagram. How to present diagram.

3:45	MODULE 5: CALCULATION Introduction to functions available in excel. Basic functions: plus, minus, subtraction, division Formula: how to create formulas

5:00	End of Day 1

DAY 2

9:00	MODULE 6: CALCULATING WITH FORMULAS How formulas work Using “$” in formulas SUM function MAX and MIN function AVERAGE and AVERAGEA function COUNT and COUNTA function COUNTIF & SUMIF function COUNTIFS & SUMIFS function