Trainings

Intermediate to Advanced MS Excel Workshop

13 Jul to 14 Jul
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 days, the participants will be able to appreciate the Excel environment and its tools; execute advanced 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 (July 13, 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 (July 13, 2022 @ 1:00 pm to 4:00 pm)

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

Module 3 (July 14, 2022 @ 9:00 am to 12:00 nn)

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

Module 4 (July 14, 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

  • August 09, 2022

    Start ‘em young: Simple Ways to Show Kids How to Save Money

    Despite understating the importance of discussing financ... Read More

  • August 05, 2022

    JFC disappointed on transport safety board veto

    The Joint Foreign Chambers (JFC) in the Philippines, composed of s... Read More

  • July 27, 2022

    A consensus is forming around agri, tech as the hot new investment areas

    BETWEEN 1980 and 2010, the Philippines established its reputation ... Read More