Microsoft Office Specialist - Microsoft Excel XP Core

Who Should Attend: This course is designed for people wishing to formalise their knowledge with a recognised qualification. This is the first level exam for
Microsoft Excel XP.

Pre-Requisits: Have used MS Excel for a minimum of three months prior to attending or have attended a MS Excel introductory course.

Working with Cells
Use undo and redo
Clear cell content and edit cell content
Enter text, dates and numbers and Clear cell formats
Go to a specific cell
Insert, delete and move selected cells
Cut, copy, paste, paste special selected cells
Use the office clipboard
Use find and replace
Work with series (AutoFill)
Create hyperlinks

Working with Files
Use save and save as
Locate and open an existing workbook
Create a folder
Use templates to create a new workbook
Save a worksheet/workbook as a web page
Send a workbook via email
Use the office assistant

Formatting Worksheets
Apply font styles
Apply number formats
Modify size of rows and columns
Modify alignment of cell content
Adjust the decimal place
Use the format painter
Apply autoformat
Apply cell borders and shading
Merging cells
Rotate text and change indents
Define, apply and remove a style

Working with Worksheets and Workbooks
Insert and delete rows and columns
Hide and unhide rows and columns
Freeze and unfreeze rows and columns
Change the zoom setting
Move between worksheets in a workbook
Check spelling
Rename a worksheet
Insert, delete, move and copy worksheets
Link worksheets and consolidate data using 3D references.

Working with Formulas and Functions
Enter a range within a formula by dragging
Enter formulas in a cell and use the formula bar
Revise formulas
Use references (absolute and relative)
Use AutoSum
Use paste function to insert a function
Use basic functions (average, sum,count, min and max)
Enter functions using the formula palette
Use date functions (NOW and DATE)
Use financial functions (FV and PMT)
Use logical functions (IF)