About this Course

ICDL Advanced Spreadsheets is a high level certification program which presents candidates 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:

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

Course Outline :

Section 1 - Introduction

• Spreadsheet Design
• Identify the Different Techniques to Use

Section 2 - Formatting

• Split Windows
• Use Conditional Formatting
• Use Format as a Table
• Use Paste Special
• Transpose Data
• Copy & Move Sheets

Section 3 - Protection

• Protect Cells 
• Hide & Unhide Columns & Rows
• Create Read-Only Workbooks
• Hide & Unhide Worksheets & Workbooks
• Protect Workbooks
• Hide Formulas

Section 4 - Cell Comments

• Use Cell Comments
• Display Comments
• Create, Edit & Delete Comments

Section 5 - Names

• Use Names
• Create and Delete Names for Cell Ranges
• Paste and Apply Names
• Use Names in Formulas
• Use Names with Go To

Section 6 - Templates

• Create and Understand Templates,
• Use Templates
• Edit Templates

Section 7 - Formulas

• Display and Check Formulas
• Understand Formulas that Produce Errors
• Use Mixed Cell Referencing
• Create Custom Number Formats

Section 8 - Outlines

• Create an Outline
• Expand and Collapse Outline
• Level Details

Section 9 - Scenerios

• Create Scenarios
• Use, Edit and Delete
• Scenarios, Create Scenario Summary Reports

Section 10 - Linking and Importing

• Link Cells, Link between Worksheets &   Workbooks
• Link to a Word Document
• Use Hyperlinks
• Importing Delimited Data
• Consolidate using 3D-Sum

Section 11 - Sorting

• Sort Data, Perform Multiple
• Sorts, Create and Use
• Custom Lists, Perform Custom Sorts

Section 12 - Lists

• Filter Lists using the AutoFilter
• Use Custom Criteria with AutoFilter, Advanced   Filter using Complex Criteria
• Extract Filtered Data
• Add Subtotals to Lists

Section 13 - Pivot Tables

• Understand PivotTables
• Create a PivotTable
• Update a PivotTable
• Filter, Group and Sort Data in a PivotTable

Section 14 - Functions

• Use Date and Time Functions
• Use Lookup Functions
• Use Mathematical and Statistical Functions
• Use Financial Functions
• Use Text and Database Functions
• Use Nested Functions

Section 15 -Charts

• Add and Remove Data Series
• Change Chart Types
• Change Chart Axis Scales
• Create Combination Charts
• Add Images to Charts

Section 16 - Data Tables

• Create a One Input Data Table
• Create a Two Input Data Table

Section 17 - Macros

• Understand Macros
• Record and Run a Macro
• Assign a Macro to the Quick
• Access Toolbar

Section 18 - Auditing

• Use Auditing Tools
• Trace Precedents and Dependents
• Add and Remove Tracer Arrows, Trace Errors
• Add Data Validation

Section 19 - Tracking Changes

• Track Changes in Worksheet
• Share Workbooks
• Merge Workbooks

Course Duration : 24 Hours

Target Audience

For beginner and professional who in need of Advanced Excel knowledge in order to produce charts and data analysis.

Pre-requisites

Need to possess basic knowledge of Basic Excel 2013

Certification

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 60 minutes online assessment at the end of the course.

Course Pathway

Any other ICDL courses or Excel for Payroll,CPF and Salary

Rate this course:

Log in to submit

Comments