By using our website you agree to our use of cookies.

Excel 2003 Level 1

1 Day Course
Hands On
Code DEX03L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Getting Started (4 topics)

  • Enter data in a worksheet
  • Edit data
  • Change the appearance of data
  • Save a workbook

Editing Your Worksheet (8 topics)

  • Moving data to other cells
  • Copy data to other cells
  • Fill cells with a series of data
  • Insert and delete rows and columns
  • Undo and Redo an entry
  • Find and replace numbers
  • Enter data in a range
  • Verify data in a range

Performing Calculations (4 topics)

  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference

Formatting (9 topics)

  • Number Formats
  • Custom number formats
  • Font Size and Type
  • Styles
  • Borders and Colours to cells
  • Column Width and Height
  • Align Cell Contents
  • Merge and Center Cells
  • AutoFormat

Working with multiple worksheets (3 topics)

  • Format worksheets Tabs
  • Reposition Worksheets in a workbook
  • Copy Worksheets

Customising layout (4 topics)

  • Split a worksheet
  • Arrange worksheets
  • Freeze and unfreeze rows and columns
  • Hide & Unhide worksheets

Page Display & Printing Options (7 topics)

  • Freeze rows and columns
  • Print Title
  • Set Page Margins
  • Headers and Footers
  • Page Orientation
  • Insert and remove page breaks
  • Print a range

Prerequisites

To ensure your success, we recommend you first take the following course or have equivalent knowledge: Microsoft Office Windows XP: Introduction If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

User Microsoft Office Training Courses

Course PDF

Print

Sections