DURATION
1 Day
Target Group
The Microsoft Excel 2002 (Advance) course is targeted at IT Manager, IT Executive, HR Officer, HR Manager, IT Consultant, IT Assistant, Secretary, Training Officer, Administrator, MIS Officer, MIS Manager, and Information Technologist.
Prerequisites
Basic and Intermediate knowledge of Microsoft Excel 2000 is required with the following pre-requisites:
Working knowledge of the Microsoft Windows 95 or 98 interface.
Must have attended Excel 97 or 2000 (Basic and Intermediate)
Course Objectives
The program is designed for experienced Excel users who need to know the advance features of Excel 2000. 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 & Data Consolidation
Working with Multiple Worksheets
Formatting Worksheet in Group Mode
Consolidating Data from Multiple Worksheets
Module 2 : File Linking
Creating Links between Files
Changing and Updating a Links
Deleting a Link
Hyperlink
Module 3 : Auditing Worksheet
Viewing Worksheet Formulas
Tracking the Flow of Data and Formulas
Using Auditing Toolbar
Adding Comments
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
Formatting Pivot Table
Show And Hide Items
Creating Pivot Chart
Module 5 : Goal Seek & Solver
Goal Seek vs. Solver
Using the Goal Seek Feature
Moving a Chart Marker to Seek a Goal
Finding the Best Solution with Solver
Producing Solver Reports
Module 6 : Scenario Manager
Create Multiple Scenarios in a Worksheet
Edit and Merge Scenarios
Create Summaries of Results for Various Scenarios
Module 7 : Data Subtotal & Outlining
Create an Automated Subtotal or Nested Subtotal
Understand an Outline, symbols and buttons
Module 8 : Macros
Recording a Macro
Running a Macro
Assigning a Macro to the Toolbar or Button
Deleting a Macro
Programme scope, delivery arrangements and suitability are confirmed during enquiry.