investors in people REC member one group many options
 

Microsoft Excel 2003 Fundamentals

Details

Time: 09:00 to 16:00
Venue: AP Courses Training Room
Cost: £295
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
  • 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