
|
Microsoft
Excel Spreadsheets
Certificate EXC0107, EXC0206, EXC0307
Information Technology
Learning
Method: Correspondence with online support
|
 |
|
|
| Course Outline |
|
MS Excel 2007
Introductory - Certificate in Information Technology
(Ms Excel—Level 1) EXC7107A
Module
1. Excel Basics
Module 2. Working with Data
Module 3. Editing a Worksheet
Module 4. Formatting a Worksheet
Module 5. Page Setup and Printing
Module 6. Formulas and Functions
Module 7. Modifying Workbooks
Intermediate - Certificate in Information Technology
(Ms Excel—Level 2) EXC7207A
Module
1. Working with Lists
Module
2. Working with Charts
Module
3. Working With Graphics
Module
4. Workgroup Collaboration
Module
5. Financial and Logical Functions
Module 6. Managing Workbooks
Advanced - Certificate in Information Technology
(Ms Excel—Level 3) EXC7307A
Module
1. Importing and Exporting Data
Module
2. Working with Ranges
Module
3. Customising Excel
Module
4. Data Analysis Tools
Module
5. Summarising Data
Module
6. What-If Data Analysis
Module
7. Workgroup Collaboration |
MS Excel 2010
Introductory - Certificate in Information Technology
(Ms Excel—Level 1) EXC10107A
Module
1. Excel Basics
Module 2. Working with Data
Module 3. Editing a Worksheet
Module 4. Formatting a Worksheet
Module 5. Page Setup and Printing
Module 6. Formulas and Functions
Module 7. Modifying Workbooks
Intermediate - Certificate in Information Technology
(Ms Excel—Level 2) EXC10207A
Module
1. Working with Lists
Module
2. Working with Charts
Module
3. Working With Graphics
Module
4. Workgroup Collaboration
Module
5. Financial and Logical Functions
Module 6. Managing Workbooks
Advanced - Certificate in Information Technology
(Ms Excel—Level 3) EXC10307A
Module
1. Importing and Exporting Data
Module
2. Working with Ranges
Module
3. Customising Excel
Module
4. Data Analysis Tools
Module
5. Summarising Data
Module
6. What-If Data Analysis
Module
7. Workgroup Collaboration
|
|
Learn more about the Microsoft Excel Spreadsheets course with your Free Facts Pack. Download it or have it mailed to you. |
|
| |

Our clients include: Coles Myer Ltd, Australian Government, University
of NSW, ANZ Bank, Fjord Manufacturing, Camera Farm, Altitude Corporation,
Japan Motor Group, NSW Cricket Association, Mission Australia, Allswell
Life Style Management, Australia Wide Holidays Pty Ltd, Harvey World Travel,
Active Trade Solutions, Gold Coast City Council, Greenline Australia,
CSIRO ...
|