Advanced Excel

In this course, students will learn how to use Excel to perform advanced calculations to facilitate decision-making and the acquisition of insight. Topics covered include Power Pivot, descriptive statistics, logic functions, VLOOKUP and HLOOKUP, and data simulations (Goal Seek, What-If Analysis, and Solver).

Who Is This Course For? 

beginners

What Will You Learn? 
How to use Power Pivot to filter and model simple datasets.
How to use input values to determine output values using Goal Seek and What-If Analysis.
How to frame problems using decision variables, objectives, and constraints.
How to identify and solve optimization problems.
How to run statistical analysis using the Data Analysis Toolpak.
How to perform VLOOKUP and HLOOKUP to access list data.
Prerequisite 

basic Excel

Duration 
15 hours
Cost 
$499.00
Tags 

Course Schedule:

This course is not currently scheduled. Please sign up if you want to get this course soon.