O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Office Specialist Expert Skill Standards

Skill Number

Skill Set and Skills

Page

XL03E-1

Organizing and Analyzing Data

 

XL03E-1-1

Use subtotals

Adding a Graphic to a Document

XL03E-1-2

Define and apply advanced filters

Defining a Valid Set of Values for a Range of Cells

XL03E-1-3

Group and outline data

Varying Your Data to Get a Desired Result

XL03E-1-4

Use data validation

Working with More Than One Set of Data

XL03E-1-5

Create and modify list ranges

Protecting Workbooks and Worksheets

XL03E-1-6

Add, show, close, edit, merge, and summarize scenarios

???

XL03E-1-7

Perform data analysis using automated tools

Creating Dynamic Lists with PivotTables, Creating Dynamic Lists with PivotTables, Editing PivotTables

XL03E-1-8

Create PivotTable and PivotChart reports

Creating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required