MICROSOFT EXCEL ADVANCE
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.
