Advanced EXCEL 2010-2016 For Business Applications

23-24 Oct, 2017, Kuala Lumpur

FOCUSING ON
  • Quick Overview Of Excel Essentials
  • Formatting Techniques
  • Understanding Formulas
  • Using Advanced Functions
  • Advance Time And Date
  • Protecting And Sharing Files
  • Working With Charts
  • Understanding Pivot Tables And Macro
INTRODUCTION

One of the most importance 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
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.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…

By the end of this course you will go beyond the basic features in Excel:

  1. Using multiple sheets, linking them to create formulae across sheets.
  2. Using common and advance functions, generate and format professional charts.
  3. Using advance formatting such as conditional formatting and advance data techniques such as validation and able to set up worksheet to work with others.
 
DAY 1
9:00 MODULE 1: QUICK OVERVIEW OF EXCEL ESSENTIALS
  • Excel 2016 Interface
  • Excel 2016 compare to 2013 and 2010
  • Understand common Excel applications
10:45 MODULE 2: FORMATTING TECHNIQUES
  • Worksheet planning and formatting
  • Planning of Multiple worksheets
  • Design of a practical workbook
  • Group and split tables and windows view
  • Working with multiple workbooks
  • Custom Auto fill
1:00 Lunch

2:00 MODULE 3: UNDERSTANDING FORMULAS
  • 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
  • Using if function and multi-level if functions
  • Using SumIf, sumifs, countif, countifs Functions
  • Using Index, lookup and related functions
  • Using other logical and information functions
  • Calculating using Date Function
5:00 End of Day 1
DAY 2
9:00 MODULE 5: ADVANCE TIME AND DATE
  • Understand Date and time in Excel
  • Using Time related function
10:45 MODULE 6: PROTECTING & SHARING FILES
  • Sharing a file
  • Accepting or rejecting changes
  • Inserting comments
  • Data validation
  • Import data
  • Conditioning format
1:00 Lunch

2:00 MODULE 7: WORKING WITH CHARTS
  • Creating a Chart
  • Formatting the Chart
  • Adding Labels
  • Changing the Chart Type, Data Source
  • Advance Charting Techniques
3:45 MODULE 8: UNDERSTANDING PIVOT TABLES AND MACRO
  • Creating Pivot Tables
  • Refreshing Pivot Table Report
  • Intro to Macro
  • Using Form controls
5:00 End of Course


 

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

Vistana Kuala Lumpur
9 Jalan Lumut Off Jalan Ipoh
50400 Kuala Lumpur
- 50400
Phone :(603) 4042 8000

 

IPA TRAINING IS REGISTERED WITH

 

CONTACT US

Juliany, 
O - 03 2283 6109,
M - 019 3134436
juliany@ipa.com.my 

Michelle, 
O - 03 2283 6100, 
M - 019 363 7822
michelle@ipa.com.my 

For Customised In-House Training
Yvonne,
O - 03 2283 6101, 
M - 012 2011247,

F - 03 2283 6108
 
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