Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

New – Learn how to perform data analysis using Excel’s most popular features.

GK# 6660

Course Overview

TOP

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

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

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

TOP
Viewing outline for:

Classroom Live Outline

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 and Correcting Errors in Formulas
  • Tracking Cells in a Workbook

Prerequisites

TOP

To ensure your success, we recommend you first take one of the following courses or have equivalent knowledge: Microsoft Office Excel 2013 – Level 2.

Who Should Attend

TOP

This course is meant for people with a sound working knowledge of Microsoft Excel 2013.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll