ICDL – Perform Advanced Spreadsheet Functions (Microsoft Excel) Advanced Level 3 Days

Funding Validity Period

Course Overview

ICDL Advanced Spreadsheets is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.

Individuals with ICDL Advanced Spreadsheets certified skills can:

Produce higher quality information
Pinpoint key information quicker and more easily
Provide more sharply-defined analysis
Produce more sophisticated reports
Use advanced editing, data handling, functions and analysis features
Use macros within the spreadsheets application

Skills Acquired

By the end of this course, learners will be able to:

Produce higher quality information
Pinpoint key information quicker and more easily
Provide more sharply-defined analysis
Produce more sophisticated reports
Use advanced editing, data handling, functions and analysis features
Use macros within the spreadsheets application

Learning Modules

Overview of Module

1. Considerations in designing spreadsheets

2. Formatting

Table AutoFormat
Conditional formatting
Apply data formats
Using multiple worksheets
Insert, move and remove split
Hide and show rows, columns, worksheet
Using cell references in formula
Function syntax and categories
Logical functions
Nested functions
Mathematical functions
Statistical functions
Date and Time functions
Financial functions
Text functions
Lookup and Reference functions
Database functions
Creating Three-D worksheets
Paste Special options

3. Functions and formula

Using cell references in formula

4. Charts

Using Custom Charts
Formatting charts

5. Analysis

Managing data in a spreadsheet
PivotTables
Data Tables
Scenario Manager
Sorting a database
Auto and Advanced Filters
Subtotals

6. Validating and Auditing

Data validation
Auditing

7. Enhancing Productivity

Range Names
Using Templates
Linking data
Inserting hyperlinks and bookmarks
Import data to Excel
Macros
Using multiple worksheets
Insert, move and remove split
Hide and show rows, columns, worksheet

8. Collaborative Editing

Working with comments
File protection
Accessing and sharing data

Table AutoFormat
Conditional formatting
Apply data formats
Using multiple worksheets
Insert, move and remove split
Hide and show rows, columns, worksheet

Using cell references in formula
Function syntax and categories
Logical functions
Nested functions
Nested functions
Mathematical functions
Statistical functions
Date and Time functions
Financial functions
Text functions
Lookup and Reference functions
Database functions
Creating Three-D worksheets
Paste Special options

Using Custom Charts
Formatting charts

Managing data in a spreadsheet
PivotTables
Data Tables
Scenario Manager
Sorting a database
Auto and Advanced Filters
Subtotals

Data validation
Auditing

Range Names
Using Templates
Linking data
Inserting hyperlinks and bookmarks
Import data to Excel
Macros

Working with comments
File protection
Accessing and sharing data

Who is this course is for

Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.

Academic prerequisites

Course Fees

Fees	Company / Self Sponsored
Full Fee	$600
GST	$54
Nett Fee Payable (incl. GST)	$654