Advanced MS Excel Capabilities Workshop

23 Aug to 24 Aug

This two-day workshop covers advanced features of MS Excel 2007/2010/2013. This advanced training is designed to enhance the knowledge and skills of the nominated participants in using and maximizing MS Excel.

At the end of this workshop, participants are expected to be capable of creating various data visualizations, pivot tables and electronic dashboards, end-products that simplify and significantly enhance their work throughput and productivity.

Course Overview

This advanced course on MS Excel (covering the 2007/2010 and 2013 versions) is designed to enable participants to understand, practice and eventually apply techniques and features that significantly result to higher work throughput, improved data presentation through visualization and better grasp of data handling.

Who Should Attend

Anyone who has a desire to maximize the built-in functionalities of MS Excel and who wish to address creating productive but powerful electronic workbooks capable of presenting their required output using the powerful features of formatted tables tightly coupled with pivot tables and in turn become the foundation for all related business intelligence presentations, to name a few.

Course Outline

Day 1

  1. Customize the Excel 2007/2010 Program Window
  2. Work with Data and Excel Tables
  3. Apply Visual Effects
  4. Perform Calculations on Data
  5. Create Dynamic Worksheets by Using Pivot Tables
  6. Create Dynamic Charts

Day 2

  1. Using Search and Validation Tools
  2. Analyze Alternative Data Sets
  3. Automate Repetitive Tasks by Using Macros
  4. Work with other Microsoft Office Programs

Learning Investment:

Php 11,000 + 12% VAT

Register Now!

For confirmations and more information, please contact
Ms. Jasmin Runez of ECCP at 845 1324
or email

  • Europe-PH News

  • September 29, 2022

    Turkish Airlines has been chosen the Best Airline in Europe in 2022 Skytrax World Airline Awards

    Flying to new records after the most significant crisis of aviatio... Read More

  • September 29, 2022

    Euro biz group, EU envoy laud British oil giant’s local unit for sustainability efforts

    THE European Chamber of Commerce of the Philippines (ECCP), with t... Read More

  • September 22, 2022

    IKEA says holidays to boost foot traffic, sales

    SWEDISH furniture retailer IKEA is expecting more foot traffic and... Read More