top of page

Microsoft Excel Formulas & Functions Overload

DURATION: 16 hours (2 days)

Prerequisites

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

Course Description 

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 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. 

bottom of page