Intermediate to Advanced MS Excel Online Course 3rd Run

ECCP eLearning

Learn beyond the normal bars and graphs so that your reports will be easier to understand. Microsoft Excel is one of the most powerful and useful business programs. It is used by millions of businesses globally primarily because it is effective and can be used by every industry there is.

In four online sessions, the participants will be able to appreciate the Excel environment and its tools; execute advance functions of Excel; create business systems such time management; sales tracking and analysis and more. In addition, participants will be able to learn pivot table.

PROGRAM OUTLINE

Module 1: September 10, 2020 (1:30PM - 4:30PM)

Formulas (Operators, Referencing Types, Defining Names
Introduction to Functions
Deep Dive on Functions
Array Formulas

Module 2: September 11, 2020 (1:30PM - 4:30PM)

3D Referencing
Nesting Functions
Nesting Functions Part 2

Module 3: September 14, 2020 (1:30PM - 4:30PM)

Nesting Function Part 3
Data Tables
Intro to Slicers and Sparklines

Module 4: September 15, 2020 (1:30PM - 4:30PM)

Intro to Pivot Table
Pivot Table & Useful properties fro creating reports
Creating Simple Dashboards (Optimizing Pivot Tables)

REGISTRATION

Slots are limited and on a first come, first served basis.

Php 6,500

ECCP Members

PHP 7,500

Non-Members

How to access the webinar: In a separate email, you will receive the link sent via ZOOM/ECCP.

For registration inquiries, email kamyr.catapang@eccp.com

Trainings