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

19 Dec, 2022, AC Hotel Kuala Lumpur by Marriott (Formerly known as Vistana Kuala Lumpur)

IPA Training is Registered with

Venue Details

AC Hotel Kuala Lumpur by Marriott (Formerly known as Vistana Kuala Lumpur)
9 JALAN LUMUT OFF JALAN IPOH,, KUALA LUMPUR, MALAYSIA, 50400,

https://www.marriott.com/en-us/hotels/kulka-ac-hotel-kuala-lumpur/overview/?scid=45f93f1b-bd77-45c9-8dab-83b6a417f6fe&y_source= 1_MTQ2NDU5MDEtND gzLWxvY2F0aW9uLndlYnNpdGU%3D


Fax : 0 3-40428000

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

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.

COURSE LEARNING OUTCOMES (CLO)
  1. Identify and prepare the participants to perform day-to-day office applications by using Excel.
  2. Begin and perform practical calculation using formula and built-in functions.
  3. Identify the programs and understand how excel can improve your work.
  4. State advanced formula and integrate of multiple built in functions.
  5. Recognise and able to do practical charting techniques.
  6. Able to use excel techniques to manipulate complex data.
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