Schedule	Course List
		Excel Introduction
	Microsoft Excel  Intermediate One-Day Course	Excel Advanced

Course Outline 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. Delegates Requirement A working knowledge of using PCs, a keyboard and mouse, Windows 95/98 and some experience of creating basic spreadsheets is required, and either gained from the workplace or by prior attendance on a "Windows 95/98 User Introduction" or "MS Excel Introduction" course. Who should attend Users with a basic understanding of MS Excel  who want to consolidate and expand on their knowledge of the basic features in a short space of time.

MS Excel  Intermediate Intermediate Spreadsheet Functions and Features 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   Excel Introduction   Excel Advanced

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 Clip Art 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

Site Map