Microsoft Excel : Intermediate to Advanced Level

25-26 Jul, 2024, Wyndham Grand Bangsar Kuala Lumpur

IPA Training is Registered with

Learn from the Best

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

Wyndham Grand Bangsar Kuala Lumpur
Jalan Pantai Baharu, Jaya Tower 3,

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

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…
  1. Outlining And Managing Group Data Effectively.
  2. Applying Proper Formula And Function.
  3. Troubleshooting Errors.
  4. Working With Pivot Tables
  5. Using Vlookup For Data Handling
  6. Creating And Using Shared Workbooks
  7. 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

  • Consolidating Data from Multiple Sources
  • Consolidating With Formulas
  • Linking Cells with other Sheets & Workbooks
  • Repairing Broken Links

 

1:00 Lunch
2:00

MODULE 9 : TEXT FUNCTION 

  • REPLACE , SUBSTITUTE , LEN & TRIM
3:45

MODULE 10 : PASSWORDS & SECURITY

  • Adding Open & Modify Password
  • Protecting cells with password
  • Protecting Worksheets
  • Hiding Formula

 

5:00 End of Course