Microsoft Excel 365 Level 4 – Spreadsheet Analysis

Microsoft Excel 365 Level 4 – Spreadsheet Analysis

Category:
Microsoft Office 2013-365/
microsoft_excel_2010
Duration: 1 Day
Certificate of Completion

Who should attend?
Prerequisites:
Course Objectives:

This course is intended for participants who are familiar with Excel 365.
Microsoft Excel 365 Level 2 and 3
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.

Course Content
Using Functions:
Projecting Figures:
What-If Scenarios:
Solver:
Auditing Concepts:

Function Concepts; Absolute and Mixed References; Financial Functions
Goal Seek; Data Tables
Scenario Concepts; Creating Scenarios; Managing Scenarios; Scenario Reports
Solver Concepts; Defining and Solving the Problem; Solver Reports; Solver Options
Tracing a Worksheet; Evaluating and Correcting Errors in Formulas; Tracking Cells

  • Please enter a number from 1 to 12.
  • This field is for validation purposes and should be left unchanged.
Upcoming Course Dates
Contact us to schedule your flexible training dates

There are no reviews yet.

Be the first to review “Microsoft Excel 365 Level 4 – Spreadsheet Analysis”