Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Excel 2003 Introduction - Course outline
   
Duration One Day
Objectives To give delegates an understanding of spreadsheet concepts and to develop the skills required to build and enter data into simple spreadsheets.
Who should attend Those with little or no experience of spreadsheet concepts who require a basic introduction to Excel.
Experience needed Delegates should have reasonable mouse and keyboard skills, and should be comfortable working with Windows applications.
   
Content Introduction to Spreadsheet Concepts
Introduction to the Excel environment
Using Help

Navigating the worksheet
Entering data into the worksheet
Selecting cells/rows/columns
Deleting data
AutoComplete and AutoFill features
Working with Custom Lists
Saving/retrieving a Workbook

Creating/editing simple formulae
Using ScreenTips for formulae
The Sum function
The AutoSum button

Moving and Copying data
Cut/Copy/Collect and Paste
Dragging and dropping data
The Undo and Redo commands

Using SmartTags with Paste / AutoFill

Formatting the appearance of cells
Formatting fonts
Simple number formats
Changing row heights/column widths
Conditional formatting
Colour-coding sheets

Page Setup commands
Setting Header and Footer details
Print Preview
Printing

Working with multiple sheets
3D cell references


Introduction to charting data

   
   
 

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465
  Back to top