ONE-DAY WORKSHOP

For up to 10 participants at your place of business

Request a Quote or More Information on this Workshop >

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, and 2016.

Other workshops on this topic: Excel – Basic | Excel – Intermediate | Excel Advanced (Data Management)

Microsoft Excel Training

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

METHODOLOGY

  • Live, instructor-led training with hands-on exercises

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

< Back to all Microsoft Office Courses

Course Code: MOB704

-MB-1