Eligibility · Site Map · Policies & Procedures · FAQs

• Home
• About Us
• Contact Us
• Career Search
• News
• Downloads
• Jobs@Axiom
• Room Hire

Download the 2010 short course training schedule now!

Axiom E-Learning - Online courses

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	- Select - Ayr Charters Towers Ingham Brisbane - Springhill Brisbane - Milton Townsville Cairns Mackay
  Category	- Select - Business/Professional Development Computer Applications Financial Hospitality Multimedia/Web/Graphic Design Other Safety TAA - Training and Assessment Transport
  Course	- Select -

  ---
• Browse Online / CD courses

  Category

  - Select - Business Computer Apps Financial Hospitality Web/Design Other Safety/Transport TAA Safety/Transport

  Course

  - Select - Word Learning CDs 2003 Introduction ;Word Learning CDs 2003 Intermediate ;Word Learning CDs 2003 Advanced ;Access Learning CDs 2003 Introduction ;Access Learning CDs 2003 Intermediate ;Access Learning CDs 2003 Advanced ;Excel Learning CDs 2003 Introduction ;Excel Learning CDs 2003 Intermediate ;Publisher Learning CDs 2003 Intro-Adv ;Outlook Learning CDs 2003 Advanced ;Office Macros Learning CDs 2003 ;Publisher Learning CDs 2003 Introduction ;Publisher Learning CDs 2003 Intermediate ;Publisher Learning CDs 2003 Advanced ;PowerPoint Learning CDs 2003 Introduction ;PowerPoint Learning CDs 2003 Intermediate ;PowerPoint Learning CDs 2003 Advanced ;Access Learning CDs 2003 Introduction ;Excel Learning CDs 2003 Advanced ;Excel Learning CDs 2003 Intro-Adv ;PowerPoint Learning CDs 2003 Intro-Adv ;Word Learning CDs 2003 Intro-Adv ;

  ---

  Course	Excel Learning CDs
  Level	Intro-Adv
  Version	2003
  Duration (days)	N/A
  Fee	$315

• Browse Qualifications and Traineeships

  Traineeships	- Select - Asset Business Financial Hospitality IT Other Retail Safety/Transport TAA Web/Design

• Search by date

  Please enter a date range below to find available courses

  From  to

Provider: 1816

Excel Learning CDs 2003 Intro-Adv
Course aim This course aims to develop skills using Microsoft Excel to produce and edit spreadsheet documents to an advanced level. Course outline --INTRODUCTION LEVEL-- INTRODUCTION • Exploring Excel • Data Types • Navigating • Selecting Data • Noncontiguous Selection WORKBOOK BASICS • Entering Data • Dates - Numbers • Fill Handles • Fill Options • Save EDITING WORKSHEETS • Replace/Edit Data • Cut, Copy & Paste • Drag & Drop • Delete Data • Rows & Columns • Change Width & Height • AutoFit • Data Validation FORMATTING DATA • Format Toolbar • Font Format • Merge & Centre • Format Cells • Indent • Borders & Shading • Layout Options • Add Graphics ADVANCED FORMATTING • Number Formats • Decimals • Special Features • Dates • Custom Formats • Create Custom Format • Conditional Format • AutoFormat REUSABLE FORMATS • Using Templates • Creating Styles • Modifying Styles • Creating Template • Use/Save Worksheet --INTERMEDIATE LEVEL-- BASIC FORMULAS • Syntax - Create Formula • Create & Edit • Relative & 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 Box & Button • AutoCalculate • Date & Time Functions • Logical Functions WORKING WITH NAMES • Create Names • Range Names & Functions • 3-D Names • Use Names • 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 --ADVANCED LEVEL-- PROTECTING DATA • Worksheet View • Cell Protection • Allow Range Editing • Protect Sheet • Protect Workbook SHARING WORKBOOK • Set Up for Sharing • Comments • Email for Review • View Changes • Track Changes • Compare Side by Side DATABASE • Defining Databases • Components • Using Forms • Filtering SORTING DATABASE • Freeze Panes • Sort Buttons • Sort Columns • Sort Order DATABASE FUNCTION • DFunction Syntax • Modify Function • And vs Or • Record Count • VLookup FILTERING • AutoFilter • Multiple & Custom Filters • Advanced Filters • Copy to Location SUBTOTALS • Working with Subtotals • Count Subtotal • Average Subtotal • Grouping • Linking Workbooks Pre-requisites None	Course Excel Learning CDs Level Intro-Adv Version 2003 Duration (days) N/A Fee $315 Brochure Print version OR Call now on: 07 3510 8018 OR - Select an option - Contact me Remind me Tell a friend Request on-site training Contact me Your name: Your email address: Your phone number: Remind me Your name: When? Your email address: Your phone number: Tell a Friend Your email: Your friend's email: Note: Request on-site training Your name: Your email address: Your phone number: 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