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 Courses Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator Courses 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 Microsoft Excel Courses? Click here Enrollment form Microsoft Excel 2002/2003 - Level 1 - Introductory This course has not been designed for Microsoft Excel 2007. For our Excel 2007 course follow this link Course start date: 19-Jan-2009, 02-Feb-2009, 16-Feb-2009, 02-Mar-2009, 16-Mar-2009, 06-Apr-2009, 20-Apr-2009, 04-May-2009, 18-May-2009, 01-Jun-2009, 15-Jun-2009 Training Location 9 Denison St, Newcastle West Course start date: 09-Feb-2009, 14-Apr-2009, 09-Jun-2009 Training Location Unit 4/2 Bounty Close, Tuggerah Training Format: Classroom Duration: 1 Day Price: $363.00 Inc GST Overview In this course, students will create, edit, format and print basic worksheets and charts in Excel 2002. Prerequisites A basic understanding of the computer operating system you are using is recommended. Course Outline Lesson 1: Getting Started Identify What You Can Do with Excel Enter Data in a Worksheet Edit Data Change Text Appearance Save a Workbook Obtain Help Lesson 2: Editing Your Worksheet Move Data to Other Cells Copy Data to Other Cells Fill Cells with a Series of Data Insert and Delete Rows and Columns. Undo and Redo an Entry Find and Replace Numbers Enter Data in a Range Verify Data in a Range Lesson 3: Performing Calculations Sum a Range of Data Use a Built-in Function Copy a Formula Create an Absolute Reference Lesson 4: Formatting Specify Numeric Format Create a Custom Numeric Format Change Font Size and Type Create and Apply Styles Add Borders to Cells Find and Replace Formats Change Column Width and Row Height Align Cell Contents Merge and Split Cells Apply an AutoFormat Lesson 5: Working with Multiple Worksheets Format Worksheet Tabs Reposition Worksheets in a Workbook Copy Worksheets Change the Number of Worksheets Lesson 6: Creating and Modifying Charts Create a Chart Modify Chart Items Format a Chart Change the Chart Type Lesson 7: Setting Page Display and Printing Options Freeze and Unfreeze Rows and Columns Set Print Titles Set Page Margins Create a Header and Footer Change Page Orientation Insert and Remove a Page Break Print a Range 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