This is a past event. Registration is closed. View other ECCP events.

Event Details

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.



Module 1 (March 12, 2021 @ 9:00 am to 12:00 nn)

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


Module 2 (March 12, 2021 @ 2:00 pm to 5:00 pm)

  • 3D Referencing
  • Nesting Functions
  • Nesting Functions Part 2


Module 3 (March 19, 2021 @ 9:00 am to 12:00 nn)

  • Nesting Function Part 3
  • Data Tables
  • Intro to Slicers and Sparklines


Module 4 (March 19, 2021 @ 2:00 pm to 5:00 pm)

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



For registration inquiries, email samantha.ferrer@eccp.com


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

Mar 12 - 19, 2021 (GMT+8)

Add to Calendar

Tickets

ECCP Members

The rate applies for ECCP members.

₱7,500
Non-members

Non-members can participate on this given rate.

₱8,500

Speakers

Menu