...

Excel Spreadsheet Analysis – One Day (Code: 20145)

Prerequisites

To ensure your success, we recommend you first take the following course (or have
equivalent knowledge): Excel Essential training (Code: 20130)

Course Overview

Learn how to perform data analysis using Excel’s most popular features such as
Goal Seek and Solver.

Excel Spreadsheet Analysis Topics

1. Using Functions
2. Function Concepts
3. Absolute and Mixed References
4. Financial Functions
5. Goal Seek
6. Data Tables
7. What-If Scenarios
8. Scenario Concepts
9. Creating Scenarios
10.Managing Scenarios
11.Scenario Reports
12.Solver Concepts
13.Defining the Problem
14.Solving the Problem
15.Solver Reports
16.Solver Options
17.Auditing Workbooks
18.Auditing Concepts
19.Tracing a Worksheet
20.Evaluating Formulas
21.Locating & Correcting Errors in Formulas
22.Tracking Cells in a Workbook

Choose Another Popular Course

Choose Another Course
Share This Post
Have your say!
2 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Request a Quote

Request Quote Form

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.