Microsoft Excel 2013, 2016, 2019 Level 3 - Spreadsheet Analysis
Code:
EXC16SA
Duration:
1 Day
|
$355
USD
|
In this course you will learn how to perform data analysis using most popular features such as Goal See and Solver. Sign up today for this Global Knowledge course and attend in-class or virtually from anywhere.
This course is available in the following formats:
Duration: 1 Day
Duration: 1 Day
Call 800-798-3901 to enroll in this class! |
Upon completion of the course, participants will be able to accomplish the following:
- Use absolute and mixed references in a formula, as well as using financial functions
- Use the Goal Seek feature and data tables
- Create and manage scenarios, as well as create scenario reports
- Define and solve problems with Solver, as well as create reports
- Understand and utilize the various tools used to audit workbooks
Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
Analyzing and Presenting Data
Create Sparklines
- Sparklines
- Types of Sparklines
- The Sparkline Tools Design Tab
Create Scenarios
- Scenarios
- The What-If Analysis Tools
- The Scenario Manager Dialog Box
Perform a What-If Analysis
- Add-In Types
- Goal Seek Feature
- The Solver Tool
Perform a Statistical Analysis with the Analysis ToolPak
- Analysis ToolPak
- The Data Analysis Dialog Box
Create Interactive Data with Power View
- The Power View Add-In
- Enabling Power View
- Creating a Power View
Auditing Workbooks
- Auditing Concepts
- Tracing a Worksheet
- Evaluating Formulas
- Locating & Correcting Errors in Formulas
- Tracking Cells in a Workbook
Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
Analyzing and Presenting Data
Create Sparklines
- Sparklines
- Types of Sparklines
- The Sparkline Tools Design Tab
Create Scenarios
- Scenarios
- The What-If Analysis Tools
- The Scenario Manager Dialog Box
Perform a What-If Analysis
- Add-In Types
- Goal Seek Feature
- The Solver Tool
Perform a Statistical Analysis with the Analysis ToolPak
- Analysis ToolPak
- The Data Analysis Dialog Box
Create Interactive Data with Power View
- The Power View Add-In
- Enabling Power View
- Creating a Power View
Auditing Workbooks
- Auditing Concepts
- Tracing a Worksheet
- Evaluating Formulas
- Locating & Correcting Errors in Formulas
- Tracking Cells in a Workbook
This course is intended for participants who are familiar with Microsoft Office Excel 2016.