Byron Employment

Byron Employment. Over 145,636 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $350.00

Course Overview

This course will provide a thorough understanding of Microsoft Excel 2007 at the intermediate level.

Methodology

Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Total Learning Time

 1 day

Delivery Method

Classroom

Prerequisite

Attendance at an Excel Level 1 course or equivalent experience.

Objectives

Revision Exercises

  • Creating Formulas
  • Formula Summary
  • Creating a Worksheet
  • Editing a Worksheet

Absolute Cell Referencing Functions

  • Function Syntax
  • The MAX Function
  • The MIN Function
  • The IF Function
  • Financial Functions
  • Date Functions

Range Names

  • Defining Range Names
  • Names in Formulas
  • Navigating with Names
  • Using Named Constants
  • Documenting Range Names

Lists

  • Extended Formatting and Formulas
  • Adding Records
  • Sorting Data
  • Using a Data Form
  • Filtering Records
  • Subtotals
  • Outline Symbols
  • Using other Functions
  • Using Page Breaks
  • Removing Subtotals

Outlining

  • Hiding Detail
  • Showing Detail
  • Grouping Rows

Conditional Formatting

AutoFill

  • Filling Dates
  • Filling Text
  • Custom Lists

Charts

  • Changing the Chart
  • Type
  • The Legend
  • Gridlines

Formatting Charts

  • Printing Charts
  • Separate Chart Sheets
  • Coloured Sheet Tabs
  • Printing Separate Chart
  • Sheets

Lunch

All Drake Publicly Scheduled courses provide lunch to students. 

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON 1300 362 262
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL 1300 362 262 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search