£ 550.00 

Skill Sets	Exam Skill Standards
Creating and Manipulating Data	Insert data by using AutoFill Ensure data integrity Modify cell contents and formats Change Worksheet Views
Formatting Data and Content	Format worksheets Insert and modify rows and columns Format cells and cell content Format data as a table
Creating and Modifying Formulas	Reference data in formulas Summarise data using a formula. Summarise data using subtotals. Conditionally summarise data by using a formula  Look up data by using a formula.  Use conditional logic in a formula.  Format or modify text by using formulas.
Presenting Data Visually	Create and format charts Modify charts Apply conditional formatting Insert and modify illustrations Outline data
Collaborating and Securing Data	Manage changes to workbooks Protect and share workbooks Prepare workbooks for distribution Set print options for printing data, worksheets, and workbooks Filter data by using AutoFilter Filter and sort data by using conditional formatting Filter and sort data by using cell attributes