Workplace Excel For Advanced Users

20-21 Jun, 2022, Remote Online Training - Public

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

Remote Online Training - Public

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 and Data
  • Module 4: Using Advanced Functions and Formula
  • Module 5: Advanced Time and Date
  • Module 6: Working With Practical Data Tools and Security
  • Module 7: Advanced Charting Techniques
  • Module 8: Intro to Pivot Tables and Controls
INTRODUCTION
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. Explain advance business calculation using formula and built-in functions.
  2. Preparing professional looking tables and charts for presentation.
  3. Describe the programs and understand what excel can do to improve your work.
  4. Using advanced techniques to manipulate complex data.
  5. Perform advanced formula and integration of multiple built in functions.
  6. Being able to learn on Advanced charting techniques.
  7. Covering the latest version of excel.
WHO SHOULD ATTEND
It is suitable for corporate users such as Admin officers, Finance, Engineers, Supervisors, Business Executive with some basic-level Excel skills who need to explore the more advanced functions and applications
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

*Prerequisite: participant must have some experience in using excel and able to formulate basic formula. Preferable using excel 2016 and newer.

DAY 1
9:00

Module 1: Quick Overview of Excel Essentials

  • Excel Interface – what is your version?
  • How different versions of excel work together 2007, 2010, 2016 and the latest 2020 version
  • 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: Using 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 the new 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 Course
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

  • 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 min
  • Quick application of pivot table

 

5:00 End of Course