Excel - Accelerated Advanced

In this intensive 3 hour course you will cover powerful advanced features. Familiarity with the concepts covered in the introduction and intermediate courses will be assumed.


RECAP OF INTERMEDIATE

  • Linking spreadsheets
  • Consolidating data and using workbooks
  • Database and sorting
  • Word and graphic tools
  • Absolute referencing

STYLES AND ANNOTATIONS

  • Using Autoformat
  • Create, edit, use and merge styles

USING FORMULAS

  • If, date and lookup tables
  • What if analysis, Scenarios, Goal Seeking, Solver
  • Tables

CHARTS

  • Creating 2D and 3D charts
  • Graphing isolated rows
  • Creating overlay charts

REPORTS AND VIEWS

  • Using Report and View Managers

DATABASE

  • Sorting and querying
  • Database statistical functions
  • Using the Pivot table wizard

DATA ANALYSIS

  • Solving "What if" problems
  • Scenario Manager

MACROS

  • Macro recording and running
  • Automatic executing macros
  • Assign macros to buttons and graphic objects

MISCELLANEOUS CONTENT AND TIPS

  • Exchanging data with other documents
  • Setting up a workspace
  • Specifying startup directory
  • Create and use document templates
  • Protecting data

Class Details

Venue:

Level 2 Prime Property House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Dates

Date Time Cost
Tue 6 - Tue 6 August 10 am - 1 pm $205.00
Tue 27 - Tue 27 August 10 am - 1 pm $205.00

Dates don't suit? Call or E-mail.