Microsoft Excel Formulas & Functions Overload

Greenbelt Mansion, Perea, Legazpi Village, Makati, Metro Manila, Philippines



Participants who want to attend this training should have at least a basic knowledge in Microsoft Excel.

 Course Description 

This course will provide you with a deeper understanding of the advanced formulas and functions that transform Microsoft Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, this course will teach contextual examples and how they can be applied in several ways. 


DATE  : March 22-23 , 2022,
DURATION: 16 hours (2 days)

Course Objectives

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

  • Write powerful and dynamic formulas from scratch. 

  • Automate, streamline, and completely revolutionize your workflow with Excel. 

  • Build and understand complex Excel functions.

  • Create dynamic Excel calculations using advanced techniques.

  • Evaluate Formulas to increase performance and find errors.

  • Bonus topic in creating Pivot Tables and Charts. 

Course Content

  • Creating name ranges and tables for formula referencing. 

  • Date Functions. 

  • Text Functions. 

  • Lookup Functions. 

  • Database Functions. 

  • Statistical Functions. 

  • Other Functions. 

  • Error Handling. 

  • Nesting Functions. 

  • Working with Pivot Tables and Pivot Charts. 


Course Schedule

Add A Review

Please enter input field

Phoenix One Knowledge Solutions
Training Courses
Training Institute

Book your course now


Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.