Course outline

Microsoft Excel 2013 Level 3 – Spreadsheet Analysis

Categories: Guaranteed To Run™, Microsoft

msp-logo

Duration: 1 Day

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

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 one of the following courses or have equivalent knowledge: Microsoft Office Excel 2013 ï¾– Level 2.

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

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

Feel free to contact us, if you want to know the price and location of this course. A Digital Revolver representative will contact you shortly to help you with your inquiry.
Please fill out the form below

  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial