ICDL - Perform Advanced Spreadsheet Functions (3 Days)
COURSE SYNOPSIS
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
TARGET AUDIENCE
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.
COURSE CONTENT
Overview of Module
-
Considerations in designing spreadsheets - Formatting
Table AutoFormat
Conditional formatting
Apply data formats
Using multiple worksheets
Insert, move and remove split
Hide and show rows, columns, worksheet
- Functions and formula
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
- Charts
Using Custom Charts
Formatting charts
- Analysis
Managing data in a spreadsheet
PivotTables
Data Tables
Scenario Manager
Sorting a database
Auto and Advanced Filters
Subtotals
- Validating and Auditing
Data validation
Auditing
- Enhancing Productivity
Range Names
Using Templates
Linking data
Inserting hyperlinks and bookmarks
Import data to Excel
Macros
- Collaborative Editing
Working with comments
File protection
Accessing and sharing data
Fees
Additional Info
3 Days