Excel 2000 Foundation

Target Audience

Excel Foundation is designed for users who are keen to extend their understanding and knowledge of the software. To fully benefit from this course, attendees are expected to be familiar with Windows and use of the mouse. Knowledge of a previous spreadsheet package would be useful, although not essential

Pre-requisites

New or inexperienced users of Excel, those upgrading from a previous version of Excel or migration from another spreadsheet package

At the completion of the course you should be able to:

• Start Microsoft Excel, navigate workbooks, and exit correctly
• Understand the origins of and basic uses for spreadsheets
• Display and hide inbuilt toolbars
• Create, modify, save, and close a simple workbook
• Enter a range of data types and formulas
• Select ranges of cells in a workbook
• Copy and fill data in a workbook
• Edit data in a workbook
• Use the search and replace features in a workbook
• Adjust the sizing of columns and rows in a workbook
• Create formulas that perform calculations in a workbook
• Understand and use absolute referencing in a workbook
• Format cells in a workbook
• Apply a range of formatting options to numbers
• Format cells and ranges to improve the appearance of worksheet
• Create and work with functions in a workbook
• Use a variety of viewing techniques to view worksheets
• Create headers and footers for workbooks
• Create a variety of charts (graphs) in Excel

Excel Basic

The Excel Screen • Moving about the Workbook • Simple Data Entry • Selecting Ranges • Saving Workbook Formats

Copying & Filling

Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets

Editing Data

Overwriting/Editing Cell Contents • Editing Formulae/Functions • Using Undo/Redo • Search & Replace

Adjusting a Worksheet

Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns

Formulae

Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function

Absolute Referencing

Problems with Absolute/Relative Cell Referencing • Creating Absolute/Mixed References • Tracing Precedents/Dependent Cells • Circular References

Formatting in Excel

Formatting Numbers/Dates/Currency • Formatting for Effect (Bolding/Italics/Underling) • Cell/Background Colours  • Cell Alignment • Copying Formats/Automatic Formatting

Working with Functions

Summing Non-Contiguous Ranges • Average/Maximum/Minimum Functions

Viewing Worksheets

Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows

Creating Charts

The Chart Wizard  • Chart Types • Adding Title/Legends/Lables • Printing Charts

Printing

Simple Printing/Previewing • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Creating Headers & Footers (Information Fields)

You may also be interested in some of the following related courses below:

Microsoft - Excel 2000 - Intermediate
Microsoft - Excel 2000 - Power User
Microsoft - Excel 2000 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.