EXC13SA: Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

Start Date Time Days Price GTR Availability
October 13, 2017 09:00 (EST) 1 $355.00 Register
October 13, 2017 09:00 (EST) 1 $355.00 Register
December 08, 2017 09:00 (EST) 1 $355.00 Register
December 08, 2017 09:00 (EST) 1 $355.00 Register
January 05, 2018 09:00 (EST) 1 $355.00 Register
March 02, 2018 09:00 (EST) 1 $355.00 Register
April 13, 2018 09:00 (EST) 1 $355.00 Register
May 22, 2018 09:00 (EST) 1 $355.00 Register

Duration: 1 Day

Course Description

In this course, you will learn how to perform data analysis using Excel’s most popular features.

Prerequisites

Microsoft Office Excel 2013 – Level 2

Course Objectives

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

Audience

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

Course Content

Using Functions

  • Function Concepts
  • Absolute and Mixed References
  • Financial Functions

Projecting Figures

  • Goal Seek
  • Data Tables

What-If Scenarios

  • Scenario Concepts
  • Creating Scenarios
  • Managing Scenarios
  • Scenario Reports

Solver

  • Solver Concepts
  • Defining the Problem
  • Solving the Problem
  • Solver Reports
  • Solver Options

Auditing Workbooks

  • Auditing Concepts
  • Tracing a Worksheet
  • Evaluating Formulas
  • Locating & Correcting Errors in Formulas
  • Tracking Cells in a Workbook