Microsoft Excel 2000 Intermediate

Course Aims
This training course is designed to advance users' knowledge of the features and functions within Microsoft Excel 2000 and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using Microsoft Excel to create and modify actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae.
Who Should Attend?
Users with a basic understanding of Microsoft Excel 2000 who want to consolidate and expand on their knowledge of the basic features of Excel. Note : A working knowledge of using PCs in the Microsoft Windows environment, and some experience of creating basic spreadsheets is required.
Course Outline: Microsoft Excel 2000 Intermediate
Formatting the Worksheet
· Adding Borders and Shading · AutoFormats · Copying Formats · Text Formatting · Indented Lists
Using Styles
· Creating and Applying a New Style · Modifying Styles
Navigating Worksheets and Workbooks
· Opening a Second Workbook · Working with Large Sheets · Using Zoom · Worksheet Linking
Using More Advanced Formulae
· Preventing Rounding Errors · Conditional Formulae (IF, AND and OR) · The Formula Palette · Financial Functions (PMT, FV, PV)
Productivity Features
· Protecting the Worksheet · Hiding Data · AutoCorrect · The Spelling Checker
Charts and Pictures
· Creating Charts · Choosing a Chart Type · Changing Chart Data · Printing Charts · Inserting Clip Art and Pictures · Drawing Objects · Manipulating Objects
Excel and the Internet
· Creating Hyperlinks · Working with Hyperlinks · Saving a Worksheet as a Web Page · Web Page Preview · Sending Worksheets and Workbooks Via E-mail