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.