This course will help you unlock the power of Microsoft Excel 2000. You will learn how to use spreadsheets effectively, saving time and improving your performance.

Who is the course for?

Excel 2000 is ideal for people with responsibility for managing budgets, creating customer lists, presenting sales data, or maintaining simple business databases. Staff at all levels of seniority – from administrators to team leaders and senior managers – will benefit from this course. The easy-to-follow, step-by-step format is perfect for people who are completely new to Excel, while the high level of detail will suit those who have a basic understanding but want to learn more about the different features and functions. There aren’t any formal entry requirements, but basic numerical skills and some familiarity with Microsoft Windows is expected. To get the most from this course access to Microsoft Excel is advised. For a different version of Excel, we also offer courses in Excel 2003 and Excel XP. To learn how to use spreadsheets for a variety of tasks in the office or at home, why not consider ECDL 4 - Spreadsheets, which can be used to work towards the ECDL qualification.

What will you get from this course?

When you have completed this course, you will be able to: * create, modify, print and share spreadsheets * format spreadsheets * use functions and formulas to make calculations * specify data ranges * create, modify and format charts.

Course features

You can start your online course straight away and access it at any time, providing you have access to a computer with an internet connection. The course will be available for up to six months from the date first accessed. The course will show you how Excel’s features and functions work, and then you can practice them for yourself. You are in control at all times, so you can work through the course at your own pace and focus on the modules you are most interested in, or least familiar with. As you’re working through the course, you can print specific sections out to refer back to later if you wish. When you’ve finished the course, you can complete an online assessment to put your new skills to the test. The results of this test can be printed out, as a record of how well you’ve done.

Course modules

1. Excel 2000 Basics
* Introducing Excel * Screen Components * Navigating Workbooks * Creating Worksheets

2. Moving, Copying and Saving
* Moving and Copying Data * Opening, Saving and Closing

3. Formulas, Functions and Ranges
* Formulas and Functions * Working with Ranges * Relative and Absolute References * Paste Functions

4. Formatting Techniques
* Toolbar Formatting * Menu Bar Formatting * Additional Formatting Features

5. Working with Large Spreadsheets
* 3D Workbooks * Splitting, Freezing and Hiding

6. Proofing and Printing Spreadsheets
* Proofing Tools * Page Breaks and Previewing * Page Setup Options * Print Areas and Printing

7. Charting
* Creating Charts * Formatting Charts

8. Web Tools
* Creating a Web Page * Worksheets and Email

Course code

103083BT013