Byron Employment

Byron Employment. Over 71,618 Jobs Australia Wide.

Delivery Method

  • Classroom

Duration

2 Half Days

Prerequisite

Experience with Windows.

Objectives

To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel.

Methodology

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

Confirmation of Assessment Plan

This will be issued to the trainee at commencement of training session.

Expected Outcome

By the end of the course the participant should be able to use the following functions and features of Microsoft Excel.

Content

Protecting Data

  • File Protection
  • Protecting Cells
  • Hiding Rows and Columns

Range Naming

  • Defining Range Names
  • Defining Several Range Names at Once
  • Applying Names to Formulas
  • Using Names to Write Formulas
  • Documenting the Range Names

Functions

  • SUM Function
  • Statistical Functions
  • SUMPRODUCT Function
  • Financial Functions
  • The PMT Function
  • The NPER Function
  • Rounding Functions
  • The IF Function
  • Nesting Functions
  • Lookup Functions

Outlining

  • Creating an Outline
  • Using an Outline
  • Creating Manual Outlines
  • Clearing Outlines

WorkSpaces

  • Workbooks and Workspaces
  • Creating and Using a Workspace File

Importing Data

  • Why Import Data?
  • Importing Delimited ASCII
  • Importing ASCII Text

Lists

  • Sorting Lists
  • Filtering Lists
  • Custom Filtering
  • Filtering for OR Conditions
  • Logical Criteria
  • List Functions
  • Subtotaling Lists
  • Pivot Tables

Macros

  • The Macro Recorder
  • Relative and Absolute Addressing in Macros
  • Recording a Macro
  • Macro Recorder Workshop
  • Assigning Macros to Buttons  
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (08) 8941 2344
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (08) 8941 2344 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search