Course not currently available
Microsoft Excel 2000 Intermediate
Short course
Inhouse
Description
-
Type
Short course
-
Methodology
Inhouse
-
Duration
1 Day
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. Suitable for: 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.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- Windows
- Microsoft Excel
- Spreadsheet
- Graphics
- Microsoft excel training
- MS Excel
Course programme
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
Microsoft Excel 2000 Intermediate