WORKPLACE EXCEL Everyday Excel for Business Applications (Intermediate to Advanced Level)

19-20 Oct, 2023, Melia Kuala Lumpur

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

KEN CHOO is an engineer with extensive experience in managing business operations and training. He has been an advanced user of many application software and has over 20 years of practical experience in Microsoft applications. He started providing Microsoft application training in the US during the 90s and has developed many Excel models for various applications such as production planning, sales management, vendors management for manufacturing and service industries.

His strong track record in managing performance and improvement by using Excel as a monitoring, analysis and reporting tool has given him many insights in the use of Excel in various real-world applications. Ken is also experienced in implementing management system such as ISO 22K Information Security System and he is also a PSMB registered trainer

Venue Details

Melia Kuala Lumpur
16 Jalan Imbi,
Phone : 0 3 2785 2828

https://www.melia.com/en/hotels /malaysia/kuala-lumpur/melia-kuala-lumpur

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 : Quick Overview of Excel Essentials
  • Module 2 : Worksheet Planning & Formatting Techniques
  • Module 3 : Understanding Formulas & Data
  • Module 4 : Using Advanced Functions & Formula
  • Module 5 : Advanced Time & Date
  • Module 6 : Working with Practical Data Tools & Security
  • Module 7 : Advanced Charting Techniques
  • Module 8 : Intro to Pivot Tables & Controls
COURSE OVERVIEW

Microsoft Excel is a robust data visualisation and analysis tool. It’s easy to become overwhelmed by Excel’s extensive set of functions. Excel does not have to be difficult to learn. Most corporate users aren’t concerned with using the best functions or creating a professional-level formula. What we need to do is use a few functions to help us automate our routine work and solve our numerical problems, which will eventually allow us to prepare a professional-looking document to present our case.

It is suitable for corporate users with basic level Excel skills who need to explore the more advanced functions and formulars.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Performing advance business calculation using formula and built-in functions.
  2. Preparing professional looking tables and charts for presentation.
  3. Navigating the programs and understanding what excel can do to improve your work.
  4. Using advanced techniques to manipulate complex data.
  5. Formulating advanced formula and integration of multiple built in functions.
  6. Being able to understand advanced charting techniques.
  7. Covering the latest version of excel.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
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.
  • Useful class manual are provided for each participant.
  • Participants will be given the opportunity to work on solutions to real life Excel  
Day 1
9:00

MODULE 1: QUICK OVERVIEW OF EXCEL ESSENTIALS

  • Excel Interface – what is your version?
  • How different versions of excel work together
  • Understand common Excel applications


10.45

MODULE 2: WORKSHEET PLANNING & FORMATTING TECHNIQUES

  • Worksheet planning and formatting
  • Planning of Multiple worksheets- why do you need multiple worksheets?
  • Design of a practical workbook
  • Working with multiple workbooks 

 

1:00 Lunch
2:00

MODULE 3: UNDERSTANDING FORMULAS and DATA

  • Formula vs Function – in day-to-day office application
  • Understand Relative /Absolute Cell Reference in complex functions
  • Using excel build-in Functions
  • Understand how excel functions work
  • Manipulating text and numbers
  • Using Range names

 

3:45

MODULE 4: USING ADVANCED FUNCTIONS AND FORMULA

  • How and when to use suitable functions or formulas
  • Using IF function and multi-level IF functions
  • Using SumIf, sumifs, countif, countifs and related Functions
  • Using variation of lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH etc)
  • Integrating multiple functions in a formula
  • Integrating functions with conditioning formatting
  • Is XLOOKUP right for you?
  • When to use other logical and information functions
  • Using array formular - perform multiple calculations on one or more items

 

5:00 End of Day 1
Day 2
9:00

MODULE 5: ADVANCED TIME AND DATE

  • Understand Date and time in Excel
  • Using Time related function
  • Using Time function in a formula


10.45

MODULE 6: WORKING WITH PRACTICAL DATA TOOLS AND SECURITY

  • Excel Data tools
  • Using Tables functions
  • Sharing a file, Inserting comments
  • Imported data
  • Dealing with Errors
  • Data validation, conditioning format,
  • Protecting worksheet and protecting workbook

 

1:00 Lunch
2:00

MODULE 7: ADVANCED CHARTING TECHNIQUES

  • Creating and Formatting a Chart
  • 2D,3D Charts, Design and Quick layout
  • Changing the Chart Type, Data Source
  • Advanced Charting Techniques

 

3:45

MODULE 8: INTRO TO PIVOT TABLES AND CONTROLS

  • How to add control items to your worksheets (combo boxes, list boxes, option buttons and others)
  • Creating Pivot Tables and Pivot chart in 5 minutes
  • Quick application of pivot table

 

5:00 End of Course