EXCEL 2013 – 2016 – 2019 SPREADSHEET ANALYSIS

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Basic Level.

Course overview

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

Excel Spreadsheet Analysis Topics

  1. Using Functions
  2. FunctionConcepts
  3. Absolute and Mixed References
  4. Financial Functions
  5. GoalSeek
  6. DataTables
  7. What-If Scenarios
  8. ScenarioConcepts
  9. CreatingScenarios
  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
Share This Post
Have your say!
0 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>