Name: Microsoft Excel : Intermediate to Advanced Level
Start: 2024-07-25T09:00
End: 2024-07-25T14:00
Location: CONCORDE HOTEL KUALA LUMPUR

IPA Training is Registered with

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250, Kuala Lumpur, Malaysia,

https://kualalumpur.concordehotelsresorts.com/

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 : Calculating With Formulas
Module 2 : Conditional Formatting
Module 3 : Vlookup
Module 4 : Charts
Module 5 : Logical Functions
Module 6 : Pivot Tables
Module 7 : Data Validation
Module 8 : Working With Data From Multiple
Worksheets & Workbooks
Module 9 : Text Function
Module 10 : Passwords & Security

OBJECTIVES

Microsoft Excel provides you with the relevant tools to transform data into formatted and meaningful information. It also allows you to generate great business reports, graphs and charts for business analysis and presentation.

It is an essential tool for today’s business. If you already have the basics of Microsoft Excel, this course will help bring you to the next level for greater efficiency and productivity.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…

Outlining And Managing Group Data Effectively.
Applying Proper Formula And Function.
Troubleshooting Errors.
Working With Pivot Tables
Using Vlookup For Data Handling
Creating And Using Shared Workbooks
Creating Advanced Workbooks And Worksheets, Including Advanced Formulas, Tables And Data-Analyzing Tools.

WHO SHOULD ATTEND

Professionals who want to expand their knowledge and skills in Microsoft Excel.
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff
Personnel who are expected to produce reports after fine tuning large raw data and summarise it in a simplified reporting style.
Personnel who want to use advance functions, collaborate with others and customize reports.

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 : 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

10.45

MODULE 2 : CONDITIONAL FORMATTING

How to use conditional formatting
Using conditional formatting presets
Managing and prioritising rules
Using top bottom rules
Customising data bars
Using formulas in conditional formatting

12.00

MODULE 3 : VLOOKUP

Vlookup

1:00

Lunch

2:00	MODULE 4 : CHARTS Creating a chart Using Excel’s recommended charts Formatting charts Changing chart data Filtering chart data Creating a dual axis line chart Saving a chart template

3:45	MODULE 5 : LOGICAL FUNCTIONS Function : IF , AND, OR Nested IF & AND Function Nested IF & OR Function

5:00	End of Day 1

DAY 2

9:00	MODULE 6 : PIVOT TABLES Creating A Pivot Table Changing the Layout of the Pivot Table Using Filters and Report Filters Grouping Data in Pivot table Calculation in Pivot Table Using Slicers