Microsoft Excel 2007
Training Course Outline
Course Duration : 2 days (14 hrs)

Introduction
This is one of the leading spreadsheet software written for personal computers. It combines the largest and most advance electronic worksheet with graphics and database management features. It is an integrated software and fast becoming a sophisticated business tool for every organization executive. Microsoft Excel for Windows is designed to give you the tools you requested. Whether you are working on a simple summary, charting sales trends or performing advanced analysis, Microsoft Excel helps you work the way you want to get your job done, no matter what job you are doing. Every level of user can appreciate the new ease-of-use features built into Microsoft Excel has been made more intuitive, more discoverable and more streamlined, so you can complete all of your work in less time. It includes the most complete set of analysis tools to help with all of your business analysis needs.

You will learn the following topics:
Chapter 1 :
1. Getting started
2. Entering Text into Worksheet
3. To set width for 1 column & multiple columns
4. AutoFit for 1 column & multiple columns
5. To hide and unhide columns or rows
6. To select cell, row and column
7. To Bold, Italic and Underline text
8. To change font type and sizes
9. Aligning text
10. Applying border, background & text color
11. Applying formulas to cells
12. Copying formula across several cells
13. Applying & copying absolute reference
14. Formatting numbers & text
15. Saving, preview & printing your worksheet
16. To set & clear off print area

Chapter 2 :
1. Opening worksheet
2. Editing existing cells
3. Deleting characters in a cell
4. Deleting content for a range of cells
5. To erase format
6. Using undo & redo
7. Inserting, deleting rows & columns
8. Moving & copying cells
9. Copy format & advance formatting
10. To use cell formats repeatedly as style
11. To use & remove a saved style

Chapter 3 :
1. Using AutoFill
2. Filling numbers & months
3. Recognizing header & footer buttons
4. Customization header & footer
5. Setting page layout
6. Insert clip art
7. Creating textbox
8. Adding text in textbox
9. Aligning text
10. Formatting textbox
11. Create & formatting WordArt
12. Spelling checking

Chapter 4 :
1. Create command links between worksheet
2. Create formula links between worksheet
3. Create links between workbook
4. Consolidate worksheet
5. Protect cells & objects
6. Unprotect worksheet
7. Create & delete password for workbooks

Chapter 5 :
1. Using tracers to audit worksheet
2. To remove arrows
3. Using comment
4. To view, edit & delete comment
5. To trace errors in a cell

Chapter 6 :
1. To create & edit pivot table
2. Show & hide details
3. Show & hide fields headers
4. To update pivot table
5. To group & ungroup
6 To format table
7. Automatic outline
8. To clear outline

Chapter 7 :
1. Creating a chart
2. Formatting a chart
3. Adding new data into chart
4. Changing the format of the chart
5. Changing the perspective
6. To remove chart

Chapter 8 :
1. Create a table
2. Adding a new records
3. Formatting & sorting the table
4. Using AutoFilter to find record
5. Deleting records from table
6. Using custom filter to search record
7. To look on the top ten list
8. Using advanced filter to search record
9. Naming the database list

Chapter 9 :
1. Using functions
2. Logical functions
3. IF function & English statement
4. AND function & English statement
6. OR function & English statement

Pre-requisites:
You should have basic Microsoft Windows operation system knowledge.
The training course will be conducted in English, unless otherwise specified.
Due to our continuous training course refinement process, the above course outline is subject to change without prior notice. All product trademarks and copyrights are the properties of their respective owners.