MICROSOFT EXCEL ADVANCE di Kuala Lumpur (KL)

Public Program JB • November 18, 2020
 

Date	Time	Venue
18/11/2020 - 19/11/2020	9:00 am - 5:00 pm	Trove Hotel Johor Bahru

COURSE OBJECTIVES

• Give participant a systematic understanding of a spreadsheet ad its benefits
• Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment

Upon completion of this program, participants should be able to: 

• Create Subtotal Using The Subtotal Function – Analyze Data Using Pivot Tables 
• Perform What If Analysis Using:
  • Goal Seek  
  • Solver
  • InputTable  
  • Scenarios
• Record A Macro
• Create A simple Macro And Assign Macro To A Toolbar Button

 
COURSE PREREQUISITES

Basic knowledge of Microsoft Excel (Foundation & Intermediate) is essential with the follow pre-requisites:

• Have attended Microsoft Excel – Foundation &  Intermediate Level; OR
• Able to switch between task applications
• Able to Perform IF and VLOOKUP Functions
• Able to Perform NESTED Functions
• Able To Define And Use Range Names
• Able To Use Auto And Advanced Filter

WHO SHOULD ATTEND 

This course is designed for Clerks, Officers,  Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.