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
- Page Orientation
- Adding Headers and Footers
- Printing a selection
- Setting a print area
- Shrink to Fit
- Adjusting page breaks within Page Break Preview
- Repeating columns and rows
- Printing Gridlines
- Setting a print area
Excel 2000 Courses
