Microsoft Office Specialist Skill Standards

Each Microsoft Office Specialist certification has a set of Skill Standards, which are organized into broader skill sets. To prepare for an Office Specialist exam, you should confirm that you can meet its respective standards. This course will prepare you for the Microsoft Office Specialist exam for Microsoft Office Excel 2003 at the Advanced level because it covers all the Skill Standards associated with that examination.

The following table lists the Skill Standards for the Microsoft Office Specialist Advanced Exam for Microsoft Office Excel 2003, alongside the course lessons and topics in which each of those Skill Standards is addressed.

Office Specialist Skill Standard	Description	Lesson	Topic
XL03E.1	Organizing and Analyzing Data
XL03E.1.1	Use subtotals	Organizing Data	Performing Calculations on Filtered Data
XL03E.1.2	Define and apply advanced filters	Organizing Data	Limiting the Data That Appears on the Screen
XL03E.1.3	Group and outline data	Working with Database Data and Macros	Summarizing List Data
XL03E.1.4	Use data validation	Organizing Data	Validating Data
XL03E.1.5	Create and modify list ranges	Organizing Data	Performing Calculations on Filtered Data
XL03E.1.6	Add, show, close, edit, merge and summarize scenarios	Analyzing Data	Defining and Editing Alternative Data Sets
XL03E.1.6	Add, show, close, edit, merge and summarize scenarios	Analyzing Data	Defining Multiple Alternative Data Sets
XL03E.1.7	Perform data analysis using automated tools	Analyzing Data	Working with Goal Seek and Solver
XL03E.1.7	Perform data analysis using automated tools	Analyzing Data	Analyzing Data with Descriptive Statistics
XL03E.1.8	Create PivotTable and PivotChart reports	Working with Graphics and Charts	Creating a Dynamic Chart Using PivotCharts
		Working with PivotTables	Creating and Using PivotTables
			Editing PivotTables
			Creating PivotTables from External Data
XL03E.1.9	Use Lookup and Reference functions	Working with Database Data and Macros	Locating and Retrieving Data from a Database
XL03E.1.10	Use Database functions	Working with Database Data and Macros	Summarizing List Data
XL03E.1.11	Trace formula precedents, dependents and errors	Performing Calculations on Data	Finding and Correcting Errors in Calculations
XL03E.1.12	Locate invalid data and formulas	Performing Calculations on Data	Finding and Correcting Errors in Calculations
XL03E.1.13	Watch and evaluate formulas	Performing Calculations on Data	Finding and Correcting Errors in Calculations
XL03E.1.14	Define, modify and use named ranges	Performing Calculations on Data	Naming Cell Ranges
XL03E.1.15	Structure workbooks using XML	Publishing on the Web and Using XML	Converting an Excel Workbook to XML
XL03E.1.15	Structure workbooks using XML	Publishing on the Web and Using XML	Using XML Data Capabilities and Retrieving Web Data
XL03E.2	Formatting Data and Content
XL03E.2.1	Create and modify custom data formats	Working with Excel and Other Office Programs	Using Custom Data Formats
XL03E.2.2	Use conditional formatting	Organizing Data	Changing Data Appearance Based on Value
XL03E.2.3	Format and resize graphics	Working with Graphics and Charts	Formatting and Resizing Graphics
XL03E.2.4	Format charts and diagrams	Working with Graphics and Charts	Creating a Chart
XL03E.2.4	Format charts and diagrams	Working with Graphics and Charts	Creating a Dynamic Chart Using PivotCharts
XL03E.3	Collaborating
XL03E.3.1	Protect cells, worksheets, and workbooks	Collaborating in Excel	Protecting Workbooks and Worksheets
XL03E.3.2	Apply workbook security settings	Collaborating in Excel	Protecting Workbooks and Worksheets
XL03E.3.3	Share workbooks	Collaborating in Excel	Sharing and Comparing Workbooks
XL03E.3.4	Merge workbooks	Collaborating in Excel	Sharing and Comparing Workbooks
XL03E.3.5	Track, accept, and reject changes to workbooks	Collaborating in Excel	Tracking and Managing Changes
XL03E.4	Managing Data and Workbooks
XL03E.4.1	Import data to Excel	Working with Database Data and Macros	Locating and Retrieving Data from a Database
XL03E.4.1	Import data to Excel	Working with PivotTables	Creating PivotTables from External Data
XL03E.4.2	Export data from Excel	Working with Excel and Other Office Programs	Sharing Data Between Excel and Other Office Programs
XL03E.4.2	Export data from Excel	Publishing on the Web and Using XML	Converting an Excel Workbook to XML
XL03E.4.3	Publish and edit Web worksheets and workbooks	Publishing on the Web and Using XML	Publishing Worksheets and PivotTables on the Web
XL03E.4.4	Create and edit templates	Working with Excel and Other Office Programs	Creating a Template from an Existing Worksheet
XL03E.4.5	Consolidate data	Organizing Data	Summarizing and Grouping Multiple Sets of Data
XL03E.4.6	Define and modify workbook properties	Working with Excel and Other Office Programs	Modifying Workbook Settings
XL03E.5	Customizing Excel
XL03E.5.1	Customize toolbars and menus	Working with Database Data and Macros	Creating and Modifying Macros
XL03E.5.2	Create, edit, and run macros	Working with Database Data and Macros	Introducing Macros
XL03E.5.2	Create, edit, and run macros	Working with Database Data and Macros	Creating and Modifying Macros
XL03E.5.3	Modify Excel default settings	Working with Excel and Other Office Programs	Modifying Workbook Settings