Trainings

Intermediate to Advanced MS Excel Online Course (3rd Batch)

16 Sep to 17 Sep
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 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 as time management; sales tracking and analysis, and more. In addition, participants will be able to learn pivot tables.


Module 1 (September 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 (September 16, 2021 @ 1:30 pm to 4:30 pm)

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

Module 3 (September 17, 2021 @ 9:00 am to 12:00 nn)

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

Module 4 (September 17, 2021 @ 1:30 pm to 4:30 pm)

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

  • August 27, 2021

    NEDA: PH economy to regain pre-COVID ground by end-2022 or early 2023

    Metro Manila (CNN Philippines, August 26) — The P... Read More

  • August 27, 2021

    BIR to reinstate VAT zero-rating on exporters’ local purchases

    August 26, 2021 | 12:33 am By Beatrice ... Read More

  • August 11, 2021

    LIVE UPDATES: COVID-19 pandemic

    a minute ago PH suspends shorter quarantine polic... Read More