Microsoft Certified Application Specialist – Excel 2007

Who Should Attend: This course is designed for people wishing to formalise their knowledge with a recognised qualification.

Pre-Requisits: Delegates should have completed an Introductory to Excel 2007 or a migration course in MS Office 2007 and be users of MS Excel 2007.

Course Length: 2 days,with an exam in the afternoon of the second day.

Creating and Manipulating Data
Create data by using auto-fill
Ensure data integrity
Find data and modify cell contents
Change the view of a worksheet
Manage worksheets
Sort and filter data

Formatting Data and Content
Format worksheets
Modify rows and columns
Format cells
Format data as a table

Constructing and Modifying Formulas
Reference data
Summarize data by using formulas
Summarise data by using subtotals
Conditionally format data by using formulas
Look up data by using formulas
Use conditional logic in formulas
Format or modify text by using formulas
Display and print formulas

Presenting Data Visually
Create and format charts
Modify charts
Apply basic conditional formatting
Insert and modify illustrations
Outline data

Collaborating and Securing Data
Manage changes to documents
Protect and share workbooks
Prepare workbooks for distribution
Save workbooks
Prepare a worksheet or workbook for printing