Business Excel For Advanced Users

25-26 Nov, 2020, AC Hotel By Marriott Kuala Lumpur (Formerly known as Vistana Kuala Lumpur)

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

KEN CHOO is a US trained engineer with more than 20 years experience in managing business, consultancy and training. He has been an advanced user of many application software and has over 20 years of practical experience in Microsoft applications. 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

AC Hotel By Marriott Kuala Lumpur (Formerly known as Vistana Kuala Lumpur)
9 Jalan Lumut off Jalan Ipoh, Kuala Lumpur 50400,
Phone : 03-4042 8000

Click For Hotel Location

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 Data
  • Module 6 - Working with Practical Data Tools and Security
  • Module 7 - Advanced Charting Techniques
  • Module 8 - Pivot Tables and Controls
INTRODUCTION

One of the most important business tools for every company. Excel is all about numbers and presentation. There’s almost no limit to what you can do with numbers in Excel, including sorting, advanced calculations, and graphing. In addition, Excel’s formatting options mean that whatever you do with your numbers, the result will always look professional! This class is designed for skilled executives who want to use excel to improve work efficiency.

  • Prerequisite for advance level: familiar with basic excel functions, able to formulate simple excel formulas. Experience working with any version of excel is essential
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
Prepare the participants to perform day-to-day office applications by using Excel to:
  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 you 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 learn about Advanced charting techniques.
  7. Covering the latest version of excel.
WHO SHOULD ATTEND
  • Admin Staff
  • HR Staff
  • Customer Service Staff
  • Sales & Operations Staff
  • Production Staff
  • Accounts Staff
  • All Staff using Excel in to collect, analyse data and present results for business purposess
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 – UNDERSTANDING FORMULAS & 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 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
  • Goal Seek
  • Sharing a file
  • Inserting comments
  • Import data
  • Dealing with Error
  • 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 – 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
  • Pivot Table Report
5:00