£ 450.00 

Skill Sets	Exam Skill Standards
Organising and Analysing Data	Use subtotals Define and apply advanced filters Group and outline data Use data validation Create and modify list ranges Add, show, close, edit, merge and summarise scenarios Perform data analysis using automated tools Create PivotTable and PivotChart reports Use Lookup and Reference functions Use Database functions Trace formula precedents, dependents and errors Locate invalid data and formulas Watch and evaluate formulas Define, modify and use named ranges Structure workbooks using XML
Formatting Data and Content	Create and modify custom data formats Use conditional formatting Format and resise graphics Format charts and diagrams
Collaborating	Protect cells, worksheets, and workbooks Apply workbook security settings Share workbooks Merge workbooks Track, accept, and reject changes to workbooks
Managing Data and Workbooks	Import data to Excel Export data from Excel Publish and edit Web worksheets and workbooks Create and edit templates Consolidate data Define and modify workbook properties
Customising Excel	Customise toolbars and menus Create, edit, and run macros Modify Excel default settings