Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:
Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training
Conducting research on the latest development and requirement for training based on customer request Developing & Maintaining a sound marketing strategy
Ensure KPI and Customer Satisfaction are meet
As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.
Venue Details
Concorde Hotel Kuala Lumpur
2 Jalan Sultan Ismail,
50250 Kuala Lumpur, Malaysia,
Phone : 03 2144 2200
FOR CUSTOMISED IN-HOUSE TRAINING Jane,
03 2283 6101 Jane@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
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
10.45
MODULE 7 : DATA VALIDATION
Setting Data Validation Rules
Message & Error Alert
INDIRECT Function with Data Validation
12.00
MODULE 8 : WORKING WITH DATA FROM MULTIPLE WORKSHEETS & WORKBOOKS
