Microsoft Excel Formulas & Functions Overload

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

Description

Prerequisites

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. 

COURSE DETAILS  :

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. 

REGISTER FOR THE COURSE

Add A Review


Please enter input field

Book your course now

Enquiry

Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.