About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
Training Information Technology Forsythes Group
Courses & Certifications Desktop Applications Microsoft Product Courses Microsoft Word Courses Microsoft Excel Courses Microsoft Access Courses Microsoft Outlook Courses Microsoft Project Courses MS PowerPoint Courses Updating to Office 2007 InfoPath 2003 Microsoft Visio Microsoft Publisher Microsoft Frontpage Windows XP Adobe Product Courses Adobe Acrobat 8 Adobe InDesign CS Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator CS Adobe Flash CS3 Dreamweaver 8 Dreamweaver MX MYOB Accounting Corel Draw v12 Crystal Reports Level 1 Crystal Reports Level 2 Technical Professional Development Need further information on Excel Courses? Click here Enrollment form Microsoft Excel 2002/2003 - Level 2 - Intermediate This course has not been designed for Microsoft Excel 2007. For our Excel 2007 courses follow this link Course start date: 02-Dec-2008, 16-Dec-2008, 20-Jan-2009, 03-Feb-2009, 17-Feb-2009, 03-Mar-2009, 17-Mar-2009, 07-Apr-2009, 21-Apr-2009, 05-May-2009, 19-May-2009, 02-Jun-2009, 16-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 1 Day Price: $363.00 Inc GST 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. 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.

	2008 Forsythes IT & Training - All Rights Reserved	Privacy Policy	Terms & Conditions	Site Map	Links & Resources	Home	Website Design - Indelible Image