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
Mentor(s)
Cynthia V. Marcello
Data Diva
Duration
15 hours
Cost
$499.00
Course Schedule:
This course is not currently scheduled.
Please sign up if you want to get this course soon.