AmCham Center for Training and Development

This 2 day intermediate MS Excel training course is designed for employees to get deeper understanding of excel, learn advance functions and make their work flow 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, and manipulate pivot table and more.

The program is delivered by hands-on professional facilitators who have decades of experience in using and teaching the program.

WHO SHOULD ATTEND?


Sales, Marketing, Operations, HR, Admin and anyone who has a desire to maximize the built-in functionalities of MS Excel and who wish to create productive but workbooks capable of presenting their required output.

TOPICS COVERED


  • Logical function 
  • Conditional functions
  • Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
  • Text functions
  • Date and me function 
  • Error functions (ISNA, ISERROR)
  • Using lookup functions
  • Creating and using names
  • Managing names
  • Validating cell entries
  • Conditional formatting
  • Outlining and consolidating data

Learning Investment

Members

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

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

Door Price: ₱10,000 | $200
-For on-site payments at the events. You may pay through credit card at the event without the additional charge. This will still require you to register before the event.

Standard Price ₱10,000
$220
Door Price ₱10,000
$200
Non-Members

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

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

Door Price: ₱12,500 | $250
-For on-site payments at the events. You may pay through credit card at the event without the additional charge. This will still require you to register before the event.

Standard Price ₱12,500
$275
Door Price ₱12,500
$250