Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

In this course, you will learn how to perform data analysis using Excel 2013's most popular features such as Goal Seek and Solver.

    May 21 2021

    Date: 05/21/2021 - 05/21/2021 (Friday - Friday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

    May 21, 2021 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 23 2021

    Date: 09/23/2021 - 09/23/2021 (Thursday - Thursday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

    September 23, 2021 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Oct 15 2021

    Date: 10/15/2021 - 10/15/2021 (Friday - Friday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Microsoft Excel 2013 Level 3 - Spreadsheet Analysis

    October 15, 2021 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

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

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

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!