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 Core level because it covers all the Skill Standards associated with that examination.

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

Office Specialist Skill Standard	Description	Lesson	Topic
XL03S.1	Creating Data and Content
XL03S.1.1	Enter and edit cell content	Getting to Know Excel	Organizing Data
			Creating a Workbook
			Checking and Correcting Data
XL03S.1.2	Navigate to specific cell content	Getting to Know Excel	Checking and Correcting Data
		Changing Document Appearance	Changing the Appearance of Data
			Applying Styles and Formats to Data
			Making Numbers Easier to Read
XL03S.1.3	Locate, select, and insert supporting information	Getting to Know Excel	Checking and Correcting Data
XL03S.1.4	Insert, position, and size graphics	Setting Up a Workbook	Adding a Graphic to a Worksheet
XL03S.2	Analyzing Data
XL03S.2.1	Filter lists using AutoFilter	Filtering and Reordering Data	Limiting the Data That Appears on the Screen
XL03S.2.2	Sort lists	Filtering and Reordering Data	Sorting a Data List
XL03S.2.3	Insert and modify formulas	Performing Calculations on Data	Creating Formulas to Calculate Values
XL03S.2.3	Insert and modify formulas	Performing Calculations on Data	Finding and Correcting Errors in Calculations
XL03S.2.4	Use statistical, date and time, financial, and logical functions	Performing Calculations on Data	Creating Formulas to Calculate Values
XL03S.2.4		Performing Calculations on Data	Rounding Results in Statistical Functions
XL03S.2.5	Create, modify, and position diagrams and charts based on worksheet data	Creating Charts	Creating a Chart
			Customizing Chart Labels and Numbers
			Creating Diagrams
XL03S.3	Formatting Data and Content
XL03S.3.1	Apply and modify cell formats	Changing Document Appearance	Changing the Appearance of Data
			Applying Styles and Formats to Data
			Making Numbers Easier to Read
XL03S.3.2	Apply and modify cell styles	Changing Document Appearance	Applying Styles and Formats to Data
XL03S.3.3	Modify row and column formats	Setting Up a Workbook	Making Workbooks Easier to Work With
XL03S.3.3	Modify row and column formats	Setting Up a Workbook	Making Data Easier to Read
XL03S.3.4	Format worksheets	Setting Up a Workbook	Making Workbooks Easier to Work With
		Setting Up a Workbook	Adding a Graphic to a Worksheet
		Combining Data from Multiple Sources	Working with More Than One Set of Data
XL03S.4	Collaborating
XL03S.4.1	Insert, view and edit comments	Setting Up a Workbook	Managing Comments
XL03S.5	Managing Workbooks
XL03S.5.1	Create new workbooks from templates	Combining Data from Multiple Sources	Creating a Template from an Existing Worksheet
XL03S.5.2	Insert, delete and move cells	Getting to Know Excel	Organizing Data
XL03S.5.2	Insert, delete and move cells	Setting Up a Workbook	Making Workbooks Easier to Work With
XL03S.5.3	Create and modify hyperlinks	Combining Data from Multiple Sources	Linking Data to Other Workbooks
XL03S.5.4	Organize worksheets	Getting to Know Excel	Introducing Excel
		Combining Data from Multiple Sources	Creating a Template from an Existing Worksheet
		Combining Data from Multiple Sources	Working with More Than One Set of Data
XL03S.5.5	Preview data in other views	Changing Document Appearance	Making Printed Worksheets Easier to Read
XL03S.5.5	Preview data in other views	Printing	Printing Worksheets
XL03S.5.6	Customize Window layout	Setting Up a Workbook	Making Data Easier to Read
XL03S.5.6	Customize Window layout	Combining Data from Multiple Sources	Working with More Than One Set of Data
XL03S.5.7	Setup pages for printing	Changing Document Appearance	Making Printed Worksheets Easier to Read
		Changing Document Appearance	Positioning Data on a Printed Page
		Printing	Printing Worksheets
		Printing	Printing Part of a Worksheet
XL03S.5.8	Print data	Printing	Printing Worksheets
			Printing Part of a Worksheet
			Printing a Chart
XL03S.5.9	Organize workbooks using file folders	Getting to Know Excel	Saving Changes to an Existing Workbook
XL03S.5.10	Save data in appropriate formats for different uses	Getting to Know Excel	Saving Changes to an Existing Workbook
XL03S.5.10	Save data in appropriate formats for different uses	Collaborating in Excel	Saving a Workbook for the Web