Training Overview

This two-day intermediate Microsoft Excel training course is designed for employees to get a deeper understanding of Excel, learn advanced functions, and make their workflow more efficient. By the end of the program, attendees will be able to maximize MS Excel to generate business reports, data consolidation, use V Lookup, manipulate pivot tables, and more. The training will be facilitated by hands-on professional facilitators who have decades of experience in using and teaching the program.



TOPICS COVERED:

  1. Logical functions
  2. Conditional functions
  3. Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
  4. Text functions
  5. Date and time functions
  6. Error functions (ISNA, ISERROR)
  7. Using lookup functions
  8. Creating and using names
  9. Managing names
  10. Validating cell entries
  11. Advanced filtering
  12. Conditional formatting
  13. Outlining and consolidating data
  14. Creating subtotals
  15. PivotTables and PivotCharts
  16. Working with PivotTables
  17. Modifying PivotTable data
  18. Formatting PivotTables
  19. Using PivotCharts
  20. Exporting and importing text files
  21. Exporting and importing MS Access files
  22. Goal Seek
  23. Scenarios
  24. Data Tables
  25. Running and recording a macro
  • Working with VBA code

Learning Investment

Individual Members

Use this ticket if your company is a member of AmCham Philippines. Please also select one of the following payment options:

Early Bird Promo: ₱7,000 + 10% | $140
(Until April 30, 2022, 05:00 PM)


Standard Price: ₱8,000 + 10% | $160
-For online payments through credit card or Paypal, with an additional tariff due to service charge. Ensures a quick entrance to the event.

Standard Price ₱8,000
$160
Individual Non-Members

For non-member company of AmCham. Please select one of the following payment options:

Early Bird Promo: ₱8,000 + 10% | $160
(Until April 30, 2022, 05:00 PM)

Standard Price: ₱9,000 + 10% | $180
- For online payments through credit card or Paypal, with an additional tariff due to service charge. Ensures a quick entrance to the event.

Standard Price ₱9,000
$180
Group of 5 Members

Use this ticket if you or your company are a group of 5 members of AmCham Philippines.

Standard Price: ₱30,000 + 10% | $600
- For online payments through credit card or Paypal, with an additional tariff due to service charge. Ensures a quick entrance to the event.

Standard Price ₱30,000
$600
Group of 5 Non-Members

Use this ticket if you or your company are a group of 5 non-members of AmCham Philippines.

Standard Price: ₱35,000 + 10% | $700
-For online payments through credit card or Paypal, with an additional tariff due to service charge. Ensures a quick entrance to the event.

Standard Price ₱35,000
$700