Byron Employment

Byron Employment. Over 71,631 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $385.00

Course Outline

Students will learn basic worksheets skills and how to work with data in worksheets.

Delivery

Classroom

Duration

1 Day

Locations

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

Prerequisite

This course requires a basic understanding of computers, such as basic mouse and keyboard operations, point and click, double-click operations.

Course Outline

Lesson 1: Excel Basics

  • The Paper Spreadsheet
  • The Excel Program
  • The Workbook Environment


Lesson 2: Entering Data and Navigating in a Worksheet

  • Entering and Correcting Data
  • Saving a File
  • Using Formulas
  • Opening a Second File
  • Navigation and Movement Techniques


Lesson 3: Modifying a Workbook

  • Working with Ranges
  • Working with Functions
  • Editing Cell Contents


Lesson 4: Moving and Copying Data

  • Inserting Rows and Ranges
  • Moving Data
  • Copying Data
  • Absolute References
  • Using the Fill Series Feature


Lesson 5: Formatting a Worksheet

  • Formatting a Worksheet
  • Number Formats and Text Alignment
  • Copying and Pasting Formats
  • Special and Custom Formatting


Lesson 6: Printing a Worksheet

  • Checking Spelling
  • Using the Print Preview Command
  • Printing a Large Worksheet
  • Additional Print Options


Lesson 7: Introduction to the Workbook Environment

  • Using a Multiple-sheet Workbook
  • Creating a Chart
  • Outlining
  • Spreadsheet Solutions

Course Includes

  • Certified trainer
  • Courseware
  • Online post support service (up to 6 months)
  • Free repeat privileges (up to 6 months)

Cancellation/Transfer Policy

New Horizons Learning Centres requires at least 5 business days notice should you wish to cancel or transfer the course, otherwise full fee is chargeable. Substitutions however, can be made at any time.
 

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