Excel Intermediate

Excel: Intermediate

Course Outline

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

				Suite 2/2 Shepherd Street GPO Box 1815 Darwin NT 0801 Phone: 08-89412344 Fax: 08-89410141 Email: dcainfo@iinet.com.au