Font size:

This course provides you with the knowledge and skills to become familiar with advanced spreadsheet analysis features and functionality of Microsoft Excel 2013.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 60-day access to online mentoring via chat from Microsoft Office experts.

Certification:

This course prepares you for Microsoft exams 77-427 and 77-428: Excel 2013, which are required for the MOS: Microsoft Office Excel 2013 Expert certification.



Highlights:
  • Create formulas using absolute and mixed references and financial functions
  • Use the Goal Seek feature and data tables
  • Create and manage scenarios and scenario reports
  • Define and solve problems with Solver, and create Solver reports
  • Understand and utilize the various tools used to audit workbooks

Audience:

Anyone who needs to use Microsoft Office Excel 2013 proficiently


1. Using Functions

  • Function Concepts
  • Absolute and Mixed References
  • Financial Functions

2. Projecting Figures

  • Goal Seek
  • Data Tables

3. What-If Scenarios

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

4. Using Solver

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

5. Auditing Workbooks

  • Auditing Concepts
  • Tracing a Worksheet
  • Evaluating Formulas
  • Locating and Correcting Errors in Formulas
  • Tracking Cells in a Workbook
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
ON Ottawa3/2/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002651546
ON TORONTO3/2/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002651548
NC Cary3/2/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day295.002641220
Virtual Live3/2/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day295.002649633
ON Ottawa4/13/2018 8:30:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002651550
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 5 of 5 items