Course Outline
Microsoft Excel 2000 (Advanced)
Course code: EXC232
Duration: 2 days
Target Group
The Microsoft Excel 2000 (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 and Data Consolidation
Working with Multiple Worksheets
Formatting Worksheet in Group Mode
Consolidating Data from Multiple Worksheets
EXERCISE 1 – Consolidation
EXERCISE 2 – Consolidation
Module 2: File Linking
Creating Links between Files
Changing and Updating a Links
Deleting a Link
Hyperlink
EXERCISE 1 – File Linking
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
EXERCISE 1 – 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
Producing Solver Reports
EXERCISE 1 – Solver
Module 6: Scenario Manager
Create Multiple Scenarios in a Worksheet
Edit and Merge Scenarios
Create Summaries of Results for Various Scenarios
EXERCISE 1 – Scenario Manager
Module 7: Data Subtotal & Outlining
Create an Automated Subtotal or Nested Subtotal
Understand an Outline, symbols and buttons
EXERCISE 1 – Data Subtotal
Module 8: Macros
Recording a Macro
Running a Macro
Assigning a Macro to the Toolbar or Button
Deleting a Macro
Module 9: Workbook Sharing (Optional)
About Workbook Sharing
Set-up Shared Workbook
Limiting Shared Access
Updating Shared Workbook
Managing Conflicts in Shared Workbook
Programme scope, delivery arrangements and suitability are confirmed during enquiry.