Course Catalog
Microsoft Excel 2013, 2016, 2019 Level 3 - Spreadsheet Analysis
Code: EXC16SA
Duration: 1 Day
$355 USD

OVERVIEW

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.

DELIVERY FORMAT

This course is available in the following formats:

Virtual Classroom

Duration: 1 Day
Classroom

Duration: 1 Day

CLASS SCHEDULE
Call 800-798-3901 to enroll in this class!

GOALS

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
OUTLINE

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
LABS

Will Be Updated Soon!
Will Be Updated Soon!
WHO SHOULD ATTEND

This course is intended for participants who are familiar with Microsoft Office Excel 2016.

PREREQUISITES

To ensure your success, we recommend you first take the following course or have equivalent knowledge.