| It means this book has been approved by the Microsoft Office Specialist program to be certified courseware for learning Microsoft Office Outlook 2003 and preparing for the certification exam. This book will prepare you fully for the Microsoft Office Specialist exam at the specialist and expert levels for Microsoft Office Excel 2003. Each certification level has a set of objectives, which are organized into broader skill sets. Throughout this book, content that pertains to a Microsoft Office Specialist objective is identified with the Microsoft Office Specialist logo and objective number below the title of the topic:  Excel 2003 Specialist Objectives | Objective | Skill | Page | | XL03S-1 | Creating Data and Content | | XL03S-1-1 | Enter and edit cell content | 30-36 | XL03S-1-2 | Navigate to specific cell content | 8-9, 46-47, 114 | XL03S-1-3 | Locate, select and insert supporting data | 128-129 | XL03S-1-4 | Insert, position, and size graphics | 130-131, 156-157 | | XL03S-2 | Analyzing Data | | XL03S-2-1 | Filter lists using AutoFilter | 202 | XL03S-2-2 | Sort lists | 200-201 | XL03S-2-3 | Insert and modify formulas | 34, 54-57, 59-61, 64 | XL03S-2-4 | Use statistical, date and time, financial, and logical functions | 71-72 | XL03S-2-5 | Create, modify, and position diagrams and charts based on worksheet data | 146-147, 177-179 | | XL03S-3 | Formatting Data and Content | | XL03S-3-1 | Apply and modify cell formats | 92-93, 96-97, 101-107 | XL03S-3-2 | Apply and modify cell styles | 110-113 | XL03S-3-3 | Modify row and column formats | 81-85, 98-99 | XL03S-3-4 | Format worksheets | 74, 78-79, 108-109 | | XL03S-4 | Collaborating | | XL03S-4-1 | Insert, view and edit comments | 242-243 | | XL03S-5 | Managing Workbooks | | XL03S-5-1 | Create new workbooks from templates | 4-5 | XL03S-5-2 | Insert, delete and move cells | 39-45 | XL03S-5-3 | Create and modify hyperlinks | 270-271 | XL03S-5-4 | Organize worksheets | 74-77 | XL03S-5-5 | Preview data in other views | 116-117, 123, 269 | XL03S-5-6 | Customize Window layout | 15, 78-79, 86-87 | XL03S-5-7 | Setup pages for printing | 116-120, 122 | XL03S-5-8 | Print data | 120-121, 124 | XL03S-5-9 | Organize workbooks using file folders | 20-21 | XL03S-5-10 | Save data in appropriate formats for different uses | 22-23, 250-251, 254-255, 272-273 | | Excel 2003 Expert Objectives | Objective | Skill | Page | | XL03E-1 | Organizing and Analyzing Data | | XL03E-1-1 | Use subtotals | 66-67 | XL03E-1-2 | Define and apply advanced filters | 203 | XL03E-1-3 | Group and outline data | 212-213 | XL03E-1-4 | Use data validation | 214 | XL03E-1-5 | Create and modify list ranges | 195, 204-205 | XL03E-1-6 | Add, show, close, edit, merge, and summarize scenarios | 220-221 | XL03E-1-7 | Perform data analysis using automated tools | 216-219, 222-223 | XL03E-1-8 | Create PivotTable and PivotChart reports | 206, 210-211 | XL03E-1-9 | Use Lookup and Reference functions | 224-225 | XL03E-1-10 | Use Database functions | 213 | XL03E-1-11 | Trace formula precedents , dependents and errors | 70 | XL03E-1-12 | Locate invalid data and formulas | 68-69 | XL03E-1-13 | Watch and evaluate formulas | 68-69 | XL03E-1-14 | Define, modify and use named ranges | 62-64 | XL03E-1-15 | Structure workbooks using XML | 252-253 | | XL03E-2 | Formatting Data and Content | | XL03E-2-1 | Create and modify custom data formats | 92-93 | XL03E-2-2 | Use conditional formatting | 94 | XL03E-2-3 | Format and resize graphics | 134-136, 156-159 | XL03E-2-4 | Format charts and diagrams | 148, 180-181, 184-185, 190-191 | | XL03E-3 | Collaborating | | XL03E-3-1 | Protect cells, worksheets, and workbooks | 234-235 | XL03E-3-2 | Apply workbook security settings | 234-238 | XL03E-3-3 | Share workbooks | 240-241 | XL03E-3-4 | Merge workbooks | 246 | XL03E-3-5 | Track, accept, and reject changes to workbooks | 244-245 | | XL03E-4 | Managing Data and Workbooks | | XL03E-4-1 | Import data to Excel | 250-251, 264-265 277-278 | XL03E-4-2 | Export data from Excel | 254-255 | XL03E-4-3 | Publish and edit Web worksheets and workbooks | 274 | XL03E-4-4 | Create and edit templates | 88-90 | XL03E-4-5 | Consolidate data | 260-261 | XL03E-4-6 | Define and modify workbook properties | 286-287 | | XL03E-5 | Customizing Excel | | XL03E-5-1 | Customize toolbars and menus | 294-298 | XL03E-5-2 | Create, edit, and run macros | 227-228, 230-231 | XL03E-5-3 | Modify Excel default settings | 290-291 | | |
