Microsoft Excel 2002 Introduction Training Course in London and the UK
Our Excel Introduction course is aimed at novice users who are really complete beginners in using the application. Our aim is to build a strong foundation in Excel to provide new users with a good understanding of the basic concepts of Microsoft Excel. Our accessible but thorough approach to your training is designed to take you through the fundamentals principles of Excel and leave you with a functional knowledge of the necessary skills for today’s workplace.
We do not expect you to have any prior MS Excel skills to attend this course.
Excel 2002 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 2002 Introduction Course. Course starts at 09:30 and runs until 16:30
Excel 2002 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 2002 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 2002 Courses
