Live Virtual Training (Most Popular!) > Microsoft Excel Advanced

Microsoft Excel Advanced

All versions available. Outline version below is Microsoft PowerPoint 2019. If you need assistance just chat with us LIVE.

Course Objectives

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
Input Table
Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Summarizing & Analyzing with Pivot Table and Pivot Charts
Record and Run a Macro

Target Audience

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.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Modules

Module 1 – Organize Summary and Details on Your Data
Module 2 – Planning, Forecasting & Projection of Your Data
Module 3 – Retrieve, Compare or Compiling Data with Functions
Module 4 – Present Data with Visual Report
Module 5 – Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts
Module 6 – Navigating Large Workbooks
Module 7 – Automate Task with Macros
Module 8 – Prevent User Changes with Protection

Get To Know The Trainer

Trainer Nazarudin

4.5

Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.

VIEW PROFILE