Event Details

(We've reached the maximum participation count for this training. Registration is now closed).



This instructor-led Advanced course on Microsoft Excel is intended for experienced participants who want

to maximize the potential of Excel in terms of Formulas, Analysis, and other features. This course will also

make the users be Experts of MS Excel and stepping stone to be Microsoft Certified Office Specialist

(MOS).


At the end of this course, the participant should be able to:

  • Advance way of referencing Formulas
  • Master Lookup Functions
  • Master Logical and Test Functions
  • e adept in Nesting Functions
  • More advanced use of Data Validation
  • Analyze and Summarize Data using Pivot Tables
  • Familiarize with Analytical Features and other add-ins of Excel
  • Automating Excel task thru Macro recording

After the completion of this course, you can now consider yourself as an Expert in Excel maximizing the

application capability and ready to create your own templates. Performing advanced calculations and

analysis in large data sets will be faster, more reliable, and accurate.

Speakers

  • Edward Jiongco (Phoenix One)

    Edward Jiongco

    Phoenix One

    He is a trainer/instructor of I.T., Soft-skills and Business courses with established track record over 12 years of experience in teaching, training, business development and consultation with computer colleges and top companies. Edward became a Department Head for computer studies at Asian College of Science and Technology Caloocan. Acquired the Chief Expert title during the TESDA skills competition last 2005. Proficient high ranking Instructor based on evaluations with an average score of 8.21 out of 9 with 1355 feedbacks.

    Edward has managed various marketing activities as part of sales and communicates with the clients to provide solutions based on their requirements. Provided project management consultations and feasibility studies. Presented automation procedures using Excel Macro programming to different companies.

    view more

Tickets

ANZCHAM Members

This is available to all ANZCHAM Members in good standing.

Standard Price ₱5,000
Non-Members and Guests
Standard Price ₱6,000