Microsoft Excel 2007 Training - Intermediate

Excellent Excel Microsoft Office Excel 2007 Training
Microsoft Office Excel 2007 Intermediate

Code# : EEB201
Duration : 1 Day (8 hr)
Level : 201
Audience : Intermediate Student
Method : Classroom
Registration Fees : Early Bird-RM350, Late Bird-RM400

Trainee has the skills and knowledge required to create, edit, print and chart simple worksheets. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Module #1
Number Formatting Techniques
→ Formatting Time
→ Formatting Dates
→ Using Alternate Currencies
→ Creating Custom Formats

Module #2
Conditional Formatting
→ Formatting & Clearing Cells Containing Values
→ Using Top 10 Items & Data Bar for Visual Trend

Module #3
Sorting & Filtering
→ Performing An Alphabetical Sort, More Than One Column & by Rows
→ Applying, Using and Clearing A Filter & Creating Custom Filters
→ Using Wildcards in Filter

Module #4
Charting Techniques
→ Create, Modify, and Edit Charts
→ Adding Trendline & Error Bars in Charts

Module #5
Advanced Formula & Function Techniques
→ Absolute & Relative Cell Referencing
→ Using Logical, Character, Lookup & References Formula
→ Error Checking, Editing & Hiding Formula

Module #6
Basic Pivot Table
→ Create Pivot Table & Pivot Chart
→ Modifying field in Pivot Table

Module #7
More Data Manipulation
→ Text to Column
→ Data Validation
→ Remove Duplicates

Module #8
Bonus: Excel Shortcuts
→ 20 Keyboards shortcuts to improve MS Excel 2007 efficiency
**Includes MS Office Excel 2007 Manual, Practical Lab & Stationeries

{Module is last updated on 3rd Dec 2010}