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 :

• Spreadsheet Design
• Identify the Different
• Techniques to Use

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

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

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

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

• Understand Templates,
• Create, Use & Edit Templates

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

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

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

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

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

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

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

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

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

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

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

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

• Track Changes in Worksheet
• Share Workbooks
• Merge Workbooks

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

Need to possess basic knowledge of Basic Excel 2007

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 min online assessment at the end of the course.

Any other MS Office 2007 courses

Rate this course:

Log in to submit

Comments