Call Integrity Business College on 1300 731 451
No one logged in. Log in Sign Up Now!
 
Book a course
See our Monthly Specials!
Computer Training Courses
Online Training through the MS Academy
Nationally Recognised Training
Training Vouchers
Training Schedules

National Computer Training Network

Microsoft Excel - Introduction 2003

Duration: 1 day

This course is designed for people who are new to spreadsheet or converting from another program. The learning outcomes of this course cover the basic day to day tasks required to work with an Excel spreadsheet and produce basic reports. 

Topics Include:

  • Starting Excel 
  • Creating & Saving Workbooks 
  • Editing Data
  • Formatting the Worksheet 
  • Basic Functions 
  • Previewing and Printing
  • Absolute References
  • Spreadsheet Design

Excel 2003 Introduction Course Description Excel 2003 Introduction Course Description (213 KB)

Microsoft Excel - Introduction 2007

Duration: 1 day

Excel Introduction is for people new to Spreadsheets, & for self-taught users to enhance their knowledge. It is a pre-requisite for the Advanced course. 

Topics Include:

  • Exploring Excel 
  • Using Basic Workbook Skills 
  • Working with Ranges
  • Creating Simple Formulas
  • Copying & Moving Data
  • Formatting Numbers and Text
  • Formatting Cells
  • Working with Columns & Rows
  • Using Page Setup
  • Printing
  • Worksheets
  • Using Other Functions
  • Creating & Editing Charts
  • Using Large Worksheets
  • Managing Data
  • Working with Comments
  • Drawing an Object
  • Additional Effects & Objects
  • Using AutoShapes & Diagrams
  • Using Worksheet Protection
  • Using Paste Special

Excel 2007 Introduction Course Description Excel 2007 Introduction Course Description (246 KB)

Microsoft Excel - Intermediate 2003

Duration: 2 days

This course is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this course, participants will have a thorough knowledge of Excel. 

Topics Include:

  • Absolute References 
  • Charts 
  • Working with Large Worksheets 
  • Range Names 
  • Working with Outline 
  • Paste Special
  • Multiple Worksheets
  • Natural Language Formulas
  • Drawing Objects
  • Functions
  • Linking
  • Proofing
  • Advanced Formatting
  • Data Validation
  • Working with Lists
  • Worksheet Protection
  • Comments
  • Templates
  • Sharing Workbooks
  • Online Forms (Optional) 

Excel 2003 Intermediate Course Description Excel 2003 Intermediate Course Description (222 KB)


Microsoft Excel - Advanced 2003

Duration: 2 days

This course is designed for people who have a good working knowledge of Excel, and who want to use the advanced features of Excel. By the completion of this course, participants will have a broad knowledge of Excel.

Topics Include:

  • Auditing Tools & Errors 
  • Advanced Functions 
  • Using a Database/lists 
  • Advanced Filter 
  • Scenario & Goal Seek 
  • Problem Solving
  • Consolidating Worksheets
  • Working with Views
  • Report Manager
  • Creating a Pivot Table Report
  • Macros
  • Online Forms 

Excel 2003 Advanced Course Description Excel 2003 Advanced Course Description (189 KB)


Microsoft Excel - Advanced 2007

Duration: 2 days

Excel Advanced is for people who can already create moderately complex spreadsheets, and want to add more sophistication and automation.

Topics Include:

  • Working with Outlines
  • Using Multiple Workbooks
  • Using Range Names
  • Working with Tables
  • Working with Advanced Filters
  • Using Advanced Functions
  • Advanced Charting
  • Using Templates
  • Using Auditing Tools
  • Scenarios and Goal Seeking
  • Solving Problems
  • Using Automatic Formatting and Styles
  • Using Conditional and Custom Formats
  • Working with Views
  • Consolidating Worksheets
  • Sharing Workbooks
  • Creating/Revising PivotTables
  • Using, Recording, Editing Macros
  • Creating a Macro Button

Excel 2007 Advanced Course Description Excel 2007 Advanced Course Description (244 KB)



To find out more please contact us.


Other computer courses that may be of interest:

Microsoft Office Training  Microsoft Word      Microsoft Excel    Microsoft Office Front Page    Microsoft Outlook    Microsoft Office PowerPoint    Microsoft Office Project    Microsoft Office Publisher    Microsoft Office Visio  

Select your Region

Register to our monthly newsletter
Sign up for our newsletter for
up to date news and course information.




Latest News

Diploma of IT student gets dream job  

Diploma of IT student Daniel Ryan secured his dream job as I.T Educational Support Officer/ Level 1 Help Desk Technician at Warringa Park School. Daniel says "IBC gave me the skills a.. more info...

Garry Sarney Case Study  

Student balances work and study with help from Integrity Business College Garry Sarney from Adelaide wanted to upgrade his skills in Computer Science to improve his employment prospects. .. more info...

Service Skills Australia Study  

Report highlights Integrity Business College success A recent study by Service Skills Australia titled "The Benefits of Accurately Measuring Non-Completions" (March 2011) looked into the reaso.. more info...