Course not currently available
Microsoft Excel 2000 Intermediate
-
The Tutor and the facilities were ok but it was not reaching my classroom expectations. I would prefer to get feedback from other students or teachers. I didn't find the session interactive. It's better to do it from your home or office through the internet. Online training may work satisfactorily.
← | →
Short course
In Birmingham ()
Description
-
Type
Short course
-
Level
Intermediate
-
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
-
The Tutor and the facilities were ok but it was not reaching my classroom expectations. I would prefer to get feedback from other students or teachers. I didn't find the session interactive. It's better to do it from your home or office through the internet. Online training may work satisfactorily.
← | →
Course rating
Recommended
Centre rating
Boulanger
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