Microsoft Excel 2007 Training - Beginner

Excellent Excel Microsoft Office Excel 2007 Training
Microsoft Office Excel 2007 Beginner

Code# : EEB100
Duration : 1 Day (8 hr)
Level : 101
Audience : Novice
Method : Classroom
Registration Fees : Early Bird-RM300, Late Bird-RM350

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
Introduction to MS Office Excel 2007
→ Getting familiar with new user interface
→ Creating, modifying and moving workbooks
→ Insert, rename, move, hide, copy, and delete sheets
→ Adding buttons to the Quick Access Toolbar (QAT)

Module #2
Data Manipulation
→ Entering, revising, finding and replacing data
→ Modifying worksheets
→ Check spelling, search for synonyms, and translate a word

Module #3
Formatting
→ Formatting Cells
→ Defining Styles
→ Applyinh workbook themes and table styles

Module #4
Basic Charts & Graphs
→ Create, Modify, and move a chart
→ Create a data table, add data, summarize the data, and rename the table

Module #5
Basic Calculations
→ Creating formulas to calculate values
→ Using AutoSum and simple statistical formula
→ Naming groups of data for better productivity

Module #6
Page Layout
→ Editing Page Setup
→ Adding Headers and Footers to Printed Pages

Module #7
Printing
→ Create a custom Headers and Footers containing a graphic
→ Preview a worksheet; change its margins, orientation, size, page breaks, and page printing order

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

{Module is last updated on 3rd Dec 2010}