Excel 2003 - Level 1 Introduction

Course Code: EX03L1
Duration: 1 Day

Bookmark and Share

Overview

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.You will create and edit basic Microsoft Office Excel 2003 worksheets and workbooks.

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows – minimise, maximise, open and close

Delegates will learn how to

  • Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
  • Design a simple database.
  • Build a new database with related tables.
  • Manage the data in a table.
  • Query a database using different methods.
  • Design forms.
  • Generate reports.

Outline

Getting Started

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

Editing Your Worksheet

  • 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

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

Formatting

  • 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

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

Customising layout

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

Page Display & Printing Options

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

Leads to examination

There are no examinations associated with this course.

Leads to certification

There are no certifications associated with this course.

Follow on Courses