Trainings

Intermediate to Advanced MS Excel Online Course

16 Feb to 22 Feb
Trainings

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 two 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 (Feb 16, 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 (Feb 16, 2021 @ 2:00 pm to 5:00 pm)

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

Module 3 (Feb 22, 2021 @ 9:00 am to 12:00 nn)

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

Module 4 (Feb 22, 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)
  • Europe-PH News

  • June 15, 2021

    Metro Manila, Bulacan ease to GCQ with 'some restrictions' by June 16

    Metro Manila (CNN Philippines, June 14) – Quarant... Read More

  • June 15, 2021

    COVID-19 vaccine deliveries and rollout in the Philippines

    (CNN Philippines) — The government is aiming to v... Read More

  • June 15, 2021

    Palace: Duterte to announce new quarantine classifications; ‘normal’ GCQ likely in NCR Plus

    MANILA, Philippines — President Rodrigo : will announce new quaran... Read More