Excel 2000 Intermediate

This course is designed to advance users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae. This Excel 2000 course also instructs users in Year 2000 best practice.

Target audience

Users with a basic understanding of Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time. A working knowledge of using PCs, a keyboard and mouse, Windows 95/98/NT/2000 and some experience of creating basic spreadsheets is assumed, gained from the workplace or by prior attendance on a "Excel 2000 Introduction" course.

Course content

Excel 2000 Intermediate Intermediate spreadsheet functions and features . Year 2000 Best Practice . Reviewing the basics

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 . Changing chart elements . Changing chart data . Printing charts . Inserting ClipArt and pictures . Drawing objects . Manipulating objects

Excel and the Internet Creating hyperlinks . Saving a worksheet as a Web page . Web page preview . Sending worksheets and workbooks via e-mail

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today