Byron Employment

Byron Employment. Over 71,438 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $310.00

Course Overview

Do you need to:

  • Create lists of data
  • Create special charts
  • Link information with other applications
  • Validate your data

Prerequisites

Excel Essentials or have a detailed understanding of the basic features of Microsoft Excel.

Delivery

Classroom

Duration

1 day

Locations

  • Public Schedule - Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Learning Outcomes

You should be able to:

  • Use Excel as a database to sort and filter lists of information such as client contact details to use for statistical purposes or to create mailing lists
  • Customise toolbars to contain buttons that access commonly used functions such as insert columns or paste values
  • Create charts including 3D charts, combine chart types to compare two sets of data and add Trendlines and Error Bars to illustrate trends and uncertainty in statistical fields
  • Print whole worksheets or selected data and solve printing problems
  • Use Data Validation to control the content added to documents

Course Content

Printing

  • Page setup options
  • Page, Margins and Header/Footer Tabs
  • Setting and removing the Print Area
  • Inserting page breaks
  • Printing selected sheets and entire workbooks
  • Printer trouble shooting

Database Features

  • Grouping selected rows or columns using the Outline feature
  • Sorting and Subtotalling lists
  • Filtering a database based on specific user defined criteria

Specialised Charting

  • Adding objects to charts such as arrows and text boxes
  • Creating and manipulating 3D charts
  • Formatting chart axes
  • Creating and applying user-defined charts
  • Combining chart types and adding a secondary axis
  • Adding Trendlines and Error Bars

Introduction to OLE

  • Linking worksheets or charts to another application
  • Turning links on and off
  • Dragging data between applications
  • Inserting files as embedded objects

Using Toolbars

  • Displaying or hiding toolbars
  • Positioning and removing toolbars
  • Adding, moving and removing buttons
  • Creating new toolbars
  • Altering and creating button images

Data Validation

  • Data validation
  • Input message
  • Error alert
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