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).
In this course students will gain the skills necessary to create and use pivot tables and charts, audit and analyze worksheet data, trace precedents and dependents, utilize data tools, collaborate with others by protecting worksheets and books, import and export data; convert text and validate and consolidate data; create and manage macros.
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
Excel Intermediate
Duration
15 hours
Cost
$699.00
Course Schedule:
This course is not currently scheduled.
Please sign up if you want to get this course soon.