About this course

Course type Essentials
Course code DEX03L1
Duration 1 Day

Unsure which Excel course level will be better for you? Click here to take our free online assessment and find out!

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.

Target Audience :

This course is designed for delegates who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets.

What’s included

QA offers more benefits. Here is what's included with this course:

Key Learning Points

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

At the end of this course you will be able to:

  • Create a basic worksheet
  • Modify a worksheet
  • Perform calculations
  • Format a worksheet
  • Develop a workbook
  • Print the contents of a workbook
  • Customise the layout of the Excel window

Outline

Getting Started

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

Editing Your Worksheet

  • Move 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 and unhide worksheets

Page Display and Printing Options

  • Freeze rows and columns
  • Print titles
  • Set page margins
  • Headers and footers
  • Page orientation
  • Insert and remove page breaks
  • Print a range
Essentials

1 Day

Duration
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.