Trainings

Intermediate to Advanced MS Excel Online Course (2nd Batch)

12Marto19Mar
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 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)
  • Europe-PH News

  • March 18, 2024

    Milestone Achieved: ECCP Celebrates Restart of EU-Philippines FTA Negotiations

    Manila, Philippines – The European Chamber of Commerce of the Phil... Read More

  • March 15, 2024

    ECCP representatives participate in Asia Sustainability Week, bringing insights to race to Net Zero Philippines

    On March 11 to 13, the ECC... Read More

  • March 14, 2024

    Mazars C-Suite Barometer 2024

    With insights from around 800 executives across 30 countri... Read More