Trainings

Intermediate to Advanced MS Excel Workshop

07 Apr to 08 Apr
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 (April 7, 2022 @ 9:00 am to 12:00 nn)

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

Module 2 (April 7, 2022 @ 1:00 pm to 4:00 pm)

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

Module 3 (April 8, 2022 @ 9:00 am to 12:00 nn)

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

Module 4 (April 8, 2022 @ 1:00 pm to 4:00 pm)

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

  • May 19, 2022

    2021 Prudential ESG Report highlights Pru Life UK’s progress in sustainability

    Prudential plc, a multinational insurance company with diverse bus... Read More

  • May 19, 2022

    Why It Pays To Go Digital

    These are the advantages of utilizing cashless payments for on... Read More

  • May 16, 2022

    Foreign chamber mulls expansion in Iloilo City

    Read More