Section: courses -- Category: it-training -- Page: course_details

Excel 2003 Essential Skills

Course Information

This one day course is designed to introduce delegates to the concepts and functionality of an electronic spreadsheet.
Delegates will be able to use Excel efficiently and confidently by creating spreadsheets encompassing simple financial and mathematical functions.

Pre-requisites

Those attending this course should have a basic understanding of the Windows environment and be comfortable with a mouse.

Course Objectives

By the end of the course delegates will be able to:

  • Recognise the different elements that comprise and Excel workbook
  • Create and save Excel workbooks
  • Manipulate worskheets in terms of naming, moving, adding and deleting
  • Enter data into a new and existing worksheet
  • Apply formatting to change the appearance of text
  • Apply cell borders and shading
  • Change the appearance of numeric data using shortcut icons and menus
  • Calculate using simple mathematical functions
  • Calcualate using built-in functions
  • Modify page margins, orientation and scaling
  • Apply headers and footers to the printed page
  • Print the whole worksheet or specific areas of the worksheet only
  • Utilise the Office Assistant & Help features

What you will learn:

Lesson 1 – Tour of Excel

Menus
Toolbars
Task Pane

Lesson 2 – Creating and Saving a Workbook

Autofill and Editing Data
Row & Column widths
Inserting Rows & Columns
Selecting / Deselecting
Renaming Worksheets
Inserting Blank Worksheets
Moving Worksheets
Copying and Deleting Worksheets

Lesson 3 – Entering and Editing Data

Creating and Editing Custom Lists
Cut, Copy and Paste
Creating a New Workbook

Lesson 4 – Creating Formulae

Creating simple calculations
AutoSum
Numeric Order
Absolute Cell Referencing

Lesson 5 – Functions

Sum
Average
Max
Min

Lesson 6 – Number Formatting

Quick Format Icons
Currency Formatting

Lesson 7 – Preparing to Print

Cell and Font Formatting
Page Setup
Printing

Related Courses

Excel 2003 Intermediate

Ideal for those looking to build on their basic Excel skills. You will lea…

Excel 2003 Advanced

Designed to enhance existing spreadsheet skills and invaluable to those han…

Excel 2003 Graphing for Impact - Intermediate

This one day modular course will enable you to use graphs for added impact…

Excel 2003 Advanced Plus

Specifically designed for those who wish to use Excel with a high degree of…

Excel 2003 VBA Programming

This two-day course is designed to introduce and explore the capabilities o…

Latest News

News Feed [RSS]

Customise

Just call us on +44 (0)1923 650365 to find out more.

Customise your Course

Post Course Support

See our wide range of post course support services.

Post Course Support