Please choose the course you would like to do using the browser below.

  • Text search all courses
    Please enter a search term below i.e. white for Whitecard

  • Browse Short courses
    Campus
    Category
    Course

  • Browse Online / CD courses
    Category
    Course

    CourseExcel Learning CDs
    LevelIntermediate
    Version2003
    Duration (days)N/A
    Fee$315
  • Browse Qualifications and Traineeships
    Traineeships

  • Search by date
    Please enter a date range below to find available courses
    From  to 







Provider: 1816

Excel Learning CDs 2003 Intermediate

 
Course aim
This course aims to develop skills using Microsoft Excel to produce and spreadsheets to an Intermediate level.
Course outline
THIS COURSE IS DELIVERED VIA LEARNING CDS & CONTAINS THE FOLLOWING TRAINING TOPICS:

BASIC FORMULAS
• Formula Syntax
• Create Formula
• Create & Edit Formulas
• Relative Reference
• Absolute Reference
• Complex Formulas
• Formula Rules

FORMULA AUDITING
• Tracing
• Evaluate Formula
• Circle Invalid Data
• Watch Window

BASIC FUNCTIONS
• Function Syntax
• Common Functions
• Building Functions
• Paste Function Box
• Paste Function Button
• AutoCalculate
• Date & Time Functions
• Logical Functions

WORKING WITH NAMES
• Create Names
• Range Names
• 3-D Names
• Use Names
• Range Functions
• Paste References
• Edit Range

ORGANISATION
• Worksheets
• Copy Worksheets
• Consolidate Data
• Tab Naming

CHARTS
• Chart Wizard
• Define Data
• Layout Options
• Position Options
• Charting Toolbar
• Format Options
• 3-D Charts
• Modify Data

SAVE & PRINT
• Save Options
• Save As Web Page
• View Saved Files
• Print Setup
• Page Setup Options
• Print Area
Pre-requisites
None
CourseExcel Learning CDs
LevelIntermediate
Version2003
Duration (days)N/A
Fee$315
BrochurePrint version






OR

Call now on: 07 3510 8018

OR




Related courses
Classes


Online / Distance

 · Excel Learning CDs 2003 Intro-Adv
 · Outlook Learning CDs 2003 Advanced
 · PowerPoint Learning CDs 2003 Intro-Adv
 · Publisher Learning CDs 2003 Intro-Adv
 · Word Learning CDs 2003 Intro-Adv