Byron Employment

Byron Employment. Over 71,631 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $270.00

Microsoft Excel 2003 - Advanced will assist the user to become more proficient in Excel's advanced data analysis, formatting and handling capabilities. Upon completion of this course you will be able to understand and use arrays; consolidate data; print using views and reports; apply "what if" analysis tools; create charts usig advanced techniques; and create a basic macro.

Training Method

Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.

Prerequisite

Excel 2003 Intermediate course of the equivalent amonut of experience using Excel.

Course Content

Arrays

  • Creating an Array Formula
  • Selecting and Editing an Array

 

Outlining

  • Creating an Automatic Outline
  • Hiding/Showing Detail
  • Removing an Outline
  • Changing the Outlining Default
  • Settings

 

Data Consolidation

  • Consolidating Workbooks
  • Consolidating Worksheets in a Workbook

 

Advanced Database Features

  • Database Functions
  • Pivot Table Reports

 

Data Tables

  • One Input Data Table
  • Two Input Data Table

 

Scenario Manager

  • Overview
  • Creating and Deleting a Scenario
  • Editing and Showing a Scenario
  • Scenario Reports

 

Print Reports

  • Creating a Print Report
  • Editing an Existing Print Report
  • Printing a Print Report
  • Deleting a Print Report

 

Custom Views

  • Adding and Deleting a Custom View
  • Showing a Custom View

 

Solver and Goal Seek

  • Overview
  • Goal Seek
  • Solver
  • Report Results
  • Save Scenario
  • Resetting Scenario
  • About the Solver Options Dialog Box

 

Advanced Charting

  • Editing an Existing Series of Data
  • Adding an Extra Series of Data to an Existing Chart
  • Deleting an Existing Series
  • Changing Chart Values
  • Changing the Way Data is Plotted
  • Changing the Scaling
  • Inserting Trend Lines
  • Combining Chart Types

 

Macros

  • Understanding Macros
  • Recording a Macro
  • Running a Macro
  • Understanding Macro Code
  • Adding Comments to a Macro
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9372 9381
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9372 9381 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search