Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MS Excel - Spreadsheet Analysis

( Duration: 1 Day )

The MS Excel - Spreadsheet Analysis training course provides the knowledge and skills to become familiar with advanced spreadsheet analysis features and functionality of Microsoft Excel 2013.

By attending MS Excel - Spreadsheet Analysis workshop, delegates will learn to:

  • 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

  • This MS Excel - Spreadsheet Analysis class is suitable for Anyone who needs to use Microsoft Office Excel 2013 proficiently.

COURSE AGENDA

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X