Prerequisites
Basic and Intermediate knowledge of Microsoft Excel 2003 is required with the following pre-requisites:
Working knowledge of the Microsoft Windows 2000 or XP interface.
Must have attended Excel 2003 (Basic and Intermediate)
Course Objectives
The program is designed for experienced Excel users who need to know the advance features of Excel 2003.
The objective of this program is to equip participants with skills to customize the Excel environments for office automation. Hands-on exercises related to actual business applications will help participants to reinforce concepts & features covered.
Module 1: Multiple Worksheet and Data Consolidation
Working with Multiple Worksheets
Formatting Worksheet in Group Mode
Data Consolidation
Module 2: File Linking
Creating Links between Files
Changing and Updating a Links
Copy Value without Formula
Create a Hyperlink from cell text
:: Course EXC03A ::
Module 3: Auditing Worksheet
Viewing Worksheet Formulas
Tracking the Flow of Data and Formulas
Using Auditing Toolbar
Using Circular Reference Toolbar
Data Validation
Module 4: Analyzing with Pivot Table
Understanding Pivot Table
Creating a Pivot Table
Editing and Updating a Pivot Table
Modifying the Summarize Function
Formatting Pivot Table
Show And Hide Items
New Pivot Chart s Reports
Creating a Pivot Chart from an Existing Pivot Table
Module 5: Goal Seek and Solver
Goal Seek vs. Solver
Using the Goal Seek Feature
Moving a Chart Marker to Seek a Goal
Finding the Best Solution with Solver
Module 6: Scenario Manager
Scenario Manager
Create Multiple Scenarios in a Worksheet
Edit and Deleting Scenario
Create Summaries of Results for Various Scenarios
Merge Scenarios
Module 7: Data Subtotal & Outlining
Data Subtotal
Create an Automated Subtotal or Nested Subtotal
Understand an Outline, symbols and buttons
Module 8: Macros
About Macro
Recording a Macro
Running a Macro
Assigning a Macro to the Toolbar or Button
Programme scope, delivery arrangements and suitability are confirmed during enquiry.