Byron Employment

Byron Employment. Over 71,631 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $310.00

Course Overview

Do you need to:

  • Create rosters or spreadsheets using standard lists
  • Perform calculations with more complex formulas and functions
  • Format cells, rows and columns for dates, dollars or percentages
  • Link data between workbooks

Prerequisites

Excel Essentials or have a good 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 edit shortcuts to assist with inserting rows and columns
  • Use AutoFill to create lists such as days of week, months, fortnightly pay periods, roster groups
  • Work with formulas and functions to perform more accurate calculations within cells to produce totals, subtotals or averages
  • Name ranges of cells to make formulas easier to read
  • Build formulas between workbooks to allow easier data management such as inclusion of summary pages
  • Add formatting to cells, rows and columns such as currency, percentage, date and time
  • Add conditional formatting
  • Convert text to columns

Course Content

Editing Techniques

  • AutoComplete
  • Accessing useful commands using shortcut menus
  • Inserting and deleting rows and columns
  • Creating custom AutoFill lists

Working with Formulas

  • Mathematical order of operations
  • Difference between absolute and relative cell referencing
  • Changing formulas to values

Introduction to Functions

  • Looking at the syntax of functions
  • Using the Formula Palette and Paste Function
  • Quick calculations with the AutoCalculate feature
  • Manually entering formulas
  • Working with specific date functions

Creating Names

  • Defining, using and applying named ranges of cells
  • Naming formulas and values

Workbook Editing

  • Navigating workbooks
  • Moving and copying sheets
  • Linking data between workbooks
  • Using names to link workbooks
  • Creating and deleting a workspace file

Workbook Presentation

  • Custom number formatting
  • Cell protection
  • Format painter
  • Conditional formatting
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