Microsoft Excel – Advanced (Spreadsheet Analysis)

WORKSHOP DESCRIPTION

Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.

This hands-on course will teach you the important functions of this industry-standard software.

Courses offered for Excel 2010, 2013, 2016, 365

WHO SHOULD ATTEND:

• Experienced Excel users who need to analyze and manage financial models

YOU WILL LEARN:

• 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 OUTLINE

Using Functions

• Reviewing function concepts
• Exploring absolute and mixed references
• Using financial functions

Projecting Figures

• Using goal seek
• Creating data tables

Performing What-If Scenarios

• Understanding scenario concepts
• Creating scenarios
• Managing scenarios
• Preparing scenario reports

Using Solver

• Reviewing solver concepts
• Defining the problem
• Solving the problem
• Preparing solver reports
• Providing solver options

Auditing Workbooks

• Reviewing auditing concepts
• Tracing a worksheet
• Evaluating formulas
• Locating and correcting errors in formulas
• Tracking cells in a workbook

Summary and Evaluations

METHODS TO BE USED

This is a live, instructor-led workshop with hands-on exercises

Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.