PLEASE CLICK HERE to view upcoming event. Information here is outdated

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

19-20 Jun, 2023, Melia Kuala Lumpur

IPA Training is Registered with

Venue Details

Melia Kuala Lumpur
16 Jalan Imbi, 55100 Kuala Lumpur, - 55100

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


Phone : (603) 2785 2828

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