Who should attend?
Prerequisites:
Course Objectives:
Microsoft Excel 365 Level 4 – Spreadsheet Analysis
Microsoft Excel 365 Level 4 – Spreadsheet Analysis
Duration: 1 Day |
Certificate of Completion |
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
Be the first to review “Microsoft Excel 365 Level 4 – Spreadsheet Analysis” Cancel reply
Duration: 1 Day |
Certificate of Completion |
There are no reviews yet.