Byron Employment

Byron Employment. Over 71,639 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $385.00

Course Overview

In this course you will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

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: Working with Templates

  • Create a Workbook from an Excel Template
  • Create a Template
  • Create a Graphic
  • Create a Workbook from a User-Defined Template

Lesson 2: Sorting and Filtering Data

  • Sort Data
  • Add Subtotals to a Worksheet
  • Filter Lists
  • Create and Apply Custom Filters

Lesson 3: Importing and Exporting Data

  • Import Data from the Web
  • Import Data from an External Source
  • Export Data
  • Save a Worksheet as a Web Page
  • Publish a Worksheet to the Web

Lesson 4: Working with Advanced Formulas

  • Share Data Among Worksheets
  • Create a Name for a Range of Cells
  • Use Functions to Create Advanced Formulas
  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas

Lesson 5: Analyzing Data

  • Create a PivotTable Report
  • Create a PivotChart Report
  • Create Scenarios
  • Use Solver
  • Use Goal Seek

Lesson 6: Collaborating

  • Insert and Edit a Hyperlink
  • Add and Edit Comments in a Worksheet
  • Create Discussion Comments
  • Respond to Discussion Comments
     
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