investors in people REC member one group many options
 

Microsoft Excel 2003 Fundamentals

Details

Dates: TBC
Time: 09:00 to 16:00
Venue: AP Courses Training Room
Cost: £245
Included in the price: Learning manual for the course; lunch, refreshments and post-course support.

Course Description

Microsoft Excel 2003 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software.  The skills and knowledge acquired in Microsoft Excel 2003 Fundamentals are sufficient to be able to use and operate the software at an elementary level.

Course Design

The course is a full-day tutor-led course that combines tutoring and practical work.

Target Audience

Although Microsoft Excel 2003 Fundamentals assumes little or no knowledge of the software, it would be beneficial but not compulsory to have a general understanding of personal computers and the Windows operating system environment. The course is intended for persons pursuing Microsoft Office Specialist Certification in Microsoft Excel 2003 or for those in employment that involves using Microsoft Excel to create, maintain and populate basic spreadsheets, create charts and tables changing layout and appearance, print Excel documents using specific options and understand the concept of basic formulas and functions. 

Learning Objectives

  • On completion of Microsoft Excel 2003 Fundamentals, you should be able to:
  • Start Microsoft Excel, navigate workbooks and exit correctly
  • Create, modify, save, and close a simple workbook
  • Adjust the sizing of columns and rows in a workbook
  • Use a variety of viewing techniques to view worksheets
  • Use a range of techniques to work with worksheets
  • Select ranges of cells in a workbook
  • Understand the origins of and basic uses for spreadsheets
  • Understand and use absolute referencing in a workbooK
  • Create formulas that perform calculations in a workbook
  • Create and work with functions in a workbook
  • Copy and fill data in a workbook
  • Format cells in a workbook
  • Use the fill technique to enter data into cells

Course Content

Spreadsheets
How spreadsheets work
Spreadsheet characteristics
Spreadsheet functionality
The appropriateness of spreadsheets

Excel 2003 Orientation
Starting Excel 2003
The Excel 2003 screen
Understanding the workbook
Moving the cell pointer
Moving about the workbook
Using Go To
Menus and toolbars
Exiting Excel

A Simple Workbook
Creating a workbook
Entering data in a workbook
Saving a workbook
Opening and closing a workbook
Creating an input range
Essential formatting
Column best fit

Selecting Ranges
Selecting contiguous and non-contiguous ranges
Special selection techniques
Using special selection techniques
Selecting larger techniques
Range calculations
Selecting an entire worksheet
Selecting a row and adjacent rows
Selecting a column and adjacent columns

Formulas
Understanding formulas
Formulas that add
The SUM function
Formulas that subtract
Formulas that multiply and divide
Referential formulas
What IF formulas
More complex formulas
Formula error checking
Common error messages
Viewing and hiding formulas

Copying and Filling
Understanding copying in Excel
Using fill for quick copying
Copying from one cell to another
Copying from cell to multiple cells
Copying from many cells to many cells
Copying relative formulas
Copying to a non-contiguous range
Copying between worksheets
Copying between open workbooks

Working with Functions
Functions
Typing a SUM function
Summing non-contiguous ranges
Calculating an AVERAGE
The MAXIMUM function
The MINIMUM function

Printing
Print preview
Simple printing
Previewing larger worksheets
Page orientation
Scaling to fit
Printing to multiple pages
Creating page headers and footers
Formatting headers and footers
Printing formulas
Scale to a specific number of pages
Specifying number of copies
Printing an entire workbook
Specifying paper size
Understanding paper sizes

Charting
Using the chart wizard
Choosing the chart type
Modifying a chart
Printing a chart
Creating a pie chart
Creating a bar chart
Moving a chart
Deleting a chart
Changing a chart type
Creating a column chart
Creating a line chart
Moving a chart to another workbook
Copying a chart within a worksheet
Copying a chart within a workbook
Resizing a chart