Phone numbers for Australian College QED

 
Australian leaders in correspondence education ... Home | Site Map | Search | Browser


Powered by EZD

 

 

 

Microsoft Excel







Microsoft Excel

Microsoft Excel Spreadsheets
Certificate EXC0107A, EXC0206A, EXC0307A
Computing and Technology

This course is packed with practical activities, movies, and projects, and you will have real Excel spreadsheet assignments to undertake and submit to your tutor for feedback. In addition, you will have online access to interactive activities in the eLearning Centre to further practise and test your knowledge and skills. And you can talk with other students from all over the country in the Student Forum.

Your course is made up of tutorial workbooks (lessons), assignment projects and printed/online supplements. You have up to 5 years to complete your course and graduate or Fast Track your course over weeks or months.

Award
Depending on which level(s) you do, upon successful completion of the course you will be awarded either:

Certificate in Information Technology (MS Excel—Level 1 )
Certificate in Information Technology (MS Excel—Level 2)
Certificate in Information Technology (MS Excel—Level 3)

Microsoft Excel

MS Excel Introductory—Level 1

Tutorial 1. Excel Basics
Topic 1: Introduction
Topic 2: Creating an excel workbook
Topic 3: Examining the excel environment
Topic 4: Opening an existing workbook
Topic 5: Navigating a worksheet
Topic 6: Creating a new workbook
Topic 7: Saving a new workbook
Topic 8: Moving between workbooks
Topic 9: Closing a workbook and exiting excel

Tutorial 2. Working with Data

Tutorial 3. Editing a Worksheet

Tutorial 4. Formatting a Worksheet

Tutorial 5. Page Setup and Printing

Tutorial 6. Formulas and Functions

Tutorial 7. Modifying Workbooks


MS Excel Introductory—Level 2

Tutorial 1. Working with Lists

Tutorial 2. Working with Charts

Tutorial 3. Working With Graphics

Tutorial 4. Workgroup Collaboration

Tutorial 5. Financial and Logical Functions

Tutorial 6. Importing and Exporting Data

MS Excel Advanced—Level 3

Tutorial 1. Formatting Numbers

Tutorial 2. Working with Ranges

Tutorial 3. Customising Excel

Tutorial 4. Data Analysis Tools

Tutorial 5. Summarising Data

Tutorial 6. What-If Data Analysis

Tutorial 7. Workgroup Collaboration

 

For an outline and facts booklet, click on Free Facts Pack. Download it or have it mailed to you.