This course is not suitable for Excel 2007. Our 2007 courses can be found here Microsoft Excel 2002/2003 - Level 2 - Intermediate Dates for next course: 21-Sep, 06-Oct, 19-Oct, 02-Nov, 16-Nov, 07-Dec and 21-Dec Training Location 9 Denison St, Newcastle West Dates for next course: 12-Oct Training Location Unit 4/2 Bounty Close, Tuggerah Training Format: Classroom Duration: 1 Day Price: $363.00   This course is GST free Overview In this course students will create templates, sort and filter data, import and export data, analyse data, and collaborate on the Web. Prerequisites Completion of Microsoft Excel 2002 Level 1 or equivalent skills is recommended. Statement of Attainment This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBITU304A Produce spreadsheets from the Certificate III in Business. Successful completion of this course and the required assessments leads to a Statement of Attainment. Course Outline Lesson 1: Working with Templates Create a Workbook from an Excel Template Create a Template Create a Graphic Create a Workbook from a User-Defined Template Lesson 2: Sorting and Filtering Data Sort Data Add Subtotals to a Worksheet Filter Lists Create and Apply Custom Filters Lesson 3: Importing and Exporting Data Import Data from the Web Import Data from an External Source Export Data Save a Worksheet as a Web Page Publish a Worksheet to the Web Lesson 4: Working with Advanced Formulas Share Data Among Worksheets Create a Name for a Range of Cells Use Functions to Create Advanced Formulas Trace Cell Precedents Trace Cell Dependents Locate Errors in Formulas Lesson 5: Analysing Data Create a PivotTable Create a PivotChart Report Create Scenarios Use Solver Use Goal Seek Lesson 6: Collaborating Insert and Edit a Hyperlink Add and Edit Comments in a Worksheet Create Discussion Comments Respond to Discussion Comments

Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.