Country :

ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2010) - 3 Days

Description
Introduction

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.

Objective

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

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 and Move Sheets

Section 3 - Protection Enail
- Protect Cells, Hide & Unhide Columns & Rows
- Create Read-Only Workbooks
- Hide and 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
- Understand Templates,
- Create, Use & 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 - Scenarios
- Create Scenarios
- Use, Edit and Delete
- Scenarios, Create Scenario Summary Reports

Section 10 - Linking &
- 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

Who Should Attend

Those who have attended any of the core modules of MS Office and would like to learn the more advanced features of MS Excel.

Other Info

Instructor-led learning

Course Provider's Profile
Over 18 years training experience.
NCC Diploma in Computer Studies (National Computer Centre - UK)
Advanced Certificate in Training and Assessment [ACTA] ( Institute for Adult Learning - Singapore)
Specilises in the Microsoft Office range of classes