Excel For Business Users Everyday Excel for Business Applications (Intermediate Level)

15 Aug, 2022, Remote Online Training - Public

IPA Training is Registered with

Learn from the Best

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

 

He has strong track record in managing performance and improvement by using Excel as a monitoring and analysis tool. 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,
M - 012 2281 247
juliany@ipa.com.my

Phoebe,
M - 019 363 7822
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Yvonne,
M - 012 201 1247
yvonne@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: Using Functions & Formula
  • Module 4: Practical Charting Techniques
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.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Preparing the participants to perform day-to-day office applications by using Excel.
  2. Understanding the requirements of a strategic leader.
  3. Performing practical calculation using formula and built-in functions.
  4. Navigating the programs and understanding how excel can improve your work.
  5. Using excel techniques to manipulate complex data.
  6. Formulating advanced formula and integrating of multiple built in functions.
  7. Being able to do practical charting techniques.
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.

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

COURSE CONTENT
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 Functions & Formula

  • Formula vs Function – in day-to-day office application
  • Understand Relative /Absolute Cell Reference in complex functions
  • 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
  • Common Functions for admin and business application
3.45

Module 4: Practical Charting Techniques

  • Creating and Formatting a Chart
  • 2D,3D Charts, Design and Quick layout
  • Changing the Chart Type, Data Source
5.00 End of Course