Byron Employment

Byron Employment. Over 71,625 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $385.00

Overview

In Excel 2002 - Level 1 you will create, edit, format and print basic worksheets and charts in Excel.

Delivery

Classroom

Duration

1 Day

Locations

  • Public Schedule - Brisbane, Melbourne, Newcastle and Sydney
  • Group Bookings - All States and Territories across Australia

Course Outline

Lesson 1: Getting Started

  • Identify What You Can Do with Excel
  • Enter Data in a Worksheet
  • Edit Data
  • Change the Appearance of Data
  • Save a Workbook
  • Obtain Help

Lesson 2: 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

Lesson 3: Performing Calculations

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

Lesson 4: Formatting

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

Lesson 5: Working with Multiple Worksheets

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Copy Worksheets
  • Change the Number of Worksheets

Lesson 6: Creating and Modifying Charts

  • Create a Chart
  • Modify Chart Items
  • Format a Chart
  • Change the Chart Type

Lesson 7: Setting Page Display and Printing Options

  • Freeze Rows and Columns
  • Set Print Titles
  • Set Page Margins
  • Create a Header and Footer
  • Change Page Orientation
  • Insert and Remove a Page Break
  • Print a Range
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search