MICROSOFT EXCEL ADVANCE: Pilihan Utama di Selangor, Malaysia, Kuala Lumpur (KL), Penang, Sabah, Johor Bahru (JB) IMPACT VOLUTION TRAINING & CONSULTANCY SDN BHD

Penerangan

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.

Lebih maklumat tentang IMPACT VOLUTION TRAINING & CONSULTANCY SDN BHD