Microsoft Excel 2000 Introduction Training Course in London and the UK

Excel 2000 Introduction Training Course Info

Audience: This course is designed for new users of Excel, or those whom have been self taught. We cover all aspects of creation a spreadsheet including writing formulae.

Course Duration: This is a 1 day Excel 2000 Introduction Course. Course starts at 09:30 and runs until 16:30

Excel 2000 Introduction Course Objectives: After the course, you will be able to:

Create and maintain spreadsheets
Create and edit formulae
Format and print worksheets
Perform basic list management tasks

Requirements: You do not need any previous knowledge of Excel, but should have basic windows, keyboard and mouse skills

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel 2000 Introduction / Beginners Training Course Contents

Excel Overview

A overview of the screen, navigation and basic spreadsheet concepts
Understanding workbooks, worksheets, rows, columns, cells
Various selection techniques

Entering Data

Entering, Editing and Deleting Text, Numbers, Dates
Using Auto Lists
Moving and Copying data
Inserting, Deleting and Hiding Rows & Collumns
Inserting, Deleting, Moving and Copying Sheets
Using navigation techniques

Creating and Editing Formuale

Concept of Formulae
Creating Formulae, Editing Formulae
Bodmas : Mathematical Order
Copying Formulae
Using Functions - Sum, Average, Max,Min, Count, Counta
Applying Absolute (Fixed) Referencing

Formatting and Proofing

Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns
Basic conditional formatting
Copying and Clearing Formats
Working with Styles
Spell Check, Find & Replace and AutoCorrect

Printing and Page Setup