Tailored Courses for IT and Business Professionals

Microsoft Excel 2003 Guided Tour

Objectives

This course will enable Excel users to design Excel worksheets for a variety of reporting, budgeting, and numerical forecasting tasks.

Duration

One Day

Delegates will learn ...

  • how to build, manage, save, retrieve, and print Excel worksheets
  • the application of formatting choices and printing options
  • shortcuts that make the time spent in Excel more productive
  • an overview of Excel's advanced features

Prerequisites

Knowledge of the windows environment is a prerequisite. Delegates need not have prior knowledge of spreadsheets. This course is suitable for new users to MS Excel or users who are self taught and have been using MS Excel for a few of months. Delegates may like to review the recommended pre-course text: Patrick Blattner, Using Microsoft Excel 2003 prior to attending. Although this may enhance a delegates enjoyment of the course it is not a requirement.

Suggested Next Courses

Microsoft Excel 2003 Power User

Topics covered

Getting started

  • The Excel working environment
  • Menus, Toolbars, Workbooks
  • The help system

Introduction to worksheets and workbooks

  • Creating, Opening, Saving and Closing a file
  • Some examples of where we're heading
  • Practical examples of usage of Excel
  • "What-if" analysis

More detail on creating a basic worksheet

  • Entering and editing data
  • Working with ranges
    • Naming ranges
    • Working with long text

Movement techniques

  • Movement techniques in worksheets
  • Introduction to workbooks

Using functions

  • Working with functions
  • Screen tips for functions
  • Functions with 3-D references
  • The Function Wizard

Moving and copying data

  • Moving data
  • Copying data
  • Filling series of data

Modifying worksheets

  • Editing cell contents
  • Absolute and Relative cell references
  • Dealing with circular cell references
  • Inserting rows and ranges
  • Checking the spelling of a worksheet

Formatting techniques

  • Formatting cell contents
  • Working with dates
  • Advanced formatting
  • Copying and pasting formats
  • Printing a worksheet

Using Print Preview

  • Printing the entire worksheet
  • Printing specified ranges

Introduction to Excel charting

  • Creating a chart