Byron Employment

Byron Employment. Over 71,631 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $310.00

Course Overview

Do you need to:

  • Create simple spreadsheets
  • Enter data into pre-existing spreadsheets
  • Create simple formulas
  • Generate various charts from spreadsheet data
  • Print spreadsheets and charts

Prerequisites

No pre-requisites but familiarity with the Windows environment and experience with the keyboard and mouse is desirable.

Learning Outcomes 

You should be able to:

  • Create a basic worksheet by entering text and values
  • Work with cells and cell data by using a variety of moving and copying techniques Perform calculations on data by using functions and formulas
  • Change the appearance of worksheet data by using a variety of formatting techniques
  • Use a variety of techniques to manipulate multiple worksheets in a workbook
  • Create and modify a chart by using various charting techniques
  • Apply page display settings to prepare a worksheet for printing

Course Content

Getting Started

  • What is Excel?
  • Screen Elements

Building Worksheets

  • Creating, saving and closing a worksheet
  • Entering simple formulas
  • Viewing Options
  • Printing Worksheets

Editing Worksheets

  • Navigating through a worksheet
  • Selecting, moving and copying cell contents
  • Filling a range of cells
  • The Sum Function
  • The AutoSum Button

Using Workbooks

  • Navigating Workbooks
  • Inserting and Deleting Worksheets
  • Naming Sheet Tabs
  • Grouping Worksheets
  • Copying through Worksheets

Enhancing Workbook Appearance

  • Page Setup Options
  • Using Print Preview
  • Formatting Cells
  • Using Number Formats
  • Cell Alignment
  • Formatting Text

Working with Charts

  • Creating a Chart
  • The Chart Data Table
  • Changing the Chart Type
  • Formatting Chart Components

The Help System

  • Using Online Help
  • The Office Assistant

Lunch

All publicly scheduled Wizard Training courses provide lunch for students

CLICK HERE TO BOOK THIS COURSE NOW!

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

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

Search Courses

Quick Job Search