Microsoft Excel 2003 Level 1 Introduction

1 day

Course Overview

Maintaining data and calculations on paper has become a difficult task in the global and digital age. With this course, learn to migrate that paper-based data to an electronic format. This course will introduce you to Microsoft Office Excel 2003.

Course Objective

Learn to manage, edit, and print data with Microsoft Office Excel 2003. Create and edit basic Microsoft Office Excel 2003 worksheets and workbooks.

Target Student

This course is for the student who desires to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets.

Prerequisites

The student should have taken Windows XP Introduction or have equivalent knowledge.

Course Outline

Getting Started with Excel

  • An Overview of Excel
  • Navigate in Excel
  • Select Data
  • Enter Data
  • Save a Workbook
  • Obtain Help

Modifying a Worksheet

  • Move and Copy Data Between Cells
  • Fill Cells with Series of Data
  • Edit Cell Data
  • Insert and Delete Cells, Columns, and Rows
  • Find, Replace, and Go To Cell Data Spell Check a Worksheet

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create an Absolute Reference

Formatting a Worksheet

  • Change Font Size and Type
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Create a Custom Number Format
  • Align Cell Contents
  • Find and Replace Formats
  • Apply an AutoFormat
  • Apply Styles

Developing a Workbook

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets
  • Copy a Workbook

Printing Workbook Contents

  • Set a Print Title
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Insert and Remove Page Breaks
  • Print a Range

Customizing Layout

  • Split a Worksheet
  • Arrange Worksheets
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide Worksheets