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 3 - Advanced This course has not been designed for Microsoft Excel 2007. For our Excel 2007 courses follow this link Course start date: 24-Nov-2008, 19-Dec-2008, 23-Jan-2009, 20-Feb-2009, 20-Mar-2009, 24-Apr-2009, 22-May-2009, 19-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 1 Day Price: $363.00 Inc GST Overview In this course you will customize workbooks, work with multiple data sources, collaborate with other users, enhance spreadsheets using charts and graphic objects. Prerequisites Completion of Microsoft Excel 2002 Level 1 and 2 or equivalent skills is recommended. Lesson 1: Customising Your Workbook Applying Conditional Formatting Adding Data Validation Criteria Customizing Menus Customizing Toolbars Creating a Macro Editing a Macros Grouping and Outlining Structured Data Lesson 2: Working with Multiple Data Sources Creating a Workspace Consolidating Data Linking Cells in Different Work books Editing Links Exporting Excel Data as XML Importing XML Data into Excel Create a Web Query Lesson 3: Collaborating with Others using Workbooks Protecting Your Worksheets Protecting Your Workbook Sharing Your Workbook Setting Revision Tracking Merging Workbooks Tracking Changes Lesson 4: Enhancing Your Worksheet using Charts Charting Non-adjacent Data Modifying Chart Items Creating a Trend Line Lesson 5: Using Graphic Objects to Enhance Your Worksheet Creating Graphic Objects Resizing, Moving and Copying Graphic Objects Changing the Order of Graphic Objects. Grouping Graphic Objects Formatting Graphic Objects Inserting Clipart Modifying Clipart 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