Welcome | p. vi |
MOUS Certification | p. viii |
Advanced Formatting and Functions | p. E1 |
Unit 1 MOUS Skills | p. E2 |
Formatting Excel Worksheets Using Advanced Formatting Techniques | p. E3 |
Applying Number Formats | p. E4 |
Creating Custom Formats | p. E5 |
Formatting Large Labels | p. E8 |
Automatically Adjusting Column Widths and Row Heights | p. E9 |
Creating, Applying, and Editing Styles | p. E12 |
Using the Format Painter Button | p. E13 |
Applying Borders and Shading | p. E13 |
Turning Off Zeros | p. E15 |
Using AutoFormat | p. E19 |
Using Conditional Formatting | p. E20 |
Adjusting the Layout of a Worksheet | p. E22 |
Using the Paste Special Command | p. E25 |
Hiding and Unhiding Rows, Columns, and Sheets | p. E27 |
Using the Page Break Preview Command | p. E30 |
Changing Page Order | p. E31 |
Renaming Sheets and Selecting a Tab Color | p. E32 |
Chapter Summary | p. E36 |
Commands Review | p. E37 |
Concepts Check | p. E37 |
Skills Check | p. E38 |
Working with Templates and Workbooks | p. E43 |
Using Excel Templates | p. E43 |
Creating a New Template | p. E46 |
Editing a Template | p. E47 |
Using Multiple Workbooks | p. E50 |
Arranging Multiple Workbooks in the Desktop | p. E50 |
Using a Workspace | p. E50 |
Merging Multiple Workbooks into a Single Workbook | p. E51 |
Consolidating Data from Several Worksheets into a List | p. E52 |
Linking Workbooks | p. E54 |
Sharing Workbooks | p. E58 |
Chapter Summary | p. E64 |
Commands Review | p. E65 |
Concepts Check | p. E65 |
Skills Check | p. E66 |
Using Advanced Functions | p. E73 |
Entering a Function | p. E74 |
Financial Functions | p. E75 |
The PMT Function | p. E77 |
The PV Function | p. E78 |
Math and Trig Functions | p. E79 |
The Round Function | p. E80 |
The Rand Function | p. E80 |
The Sumif Function | p. E80 |
Statistical Functions | p. E82 |
The Countif Function | p. E82 |
Naming a Range | p. E84 |
Using a Named Range in a Formula | p. E85 |
Lookup and Reference Functions | p. E86 |
The Vlookup Function | p. E86 |
Logical Functions | p. E88 |
Using the IF Function | p. E88 |
Using Array Formulas | p. E90 |
Chapter Summary | p. E93 |
Commands Review | p. E94 |
Concepts Check | p. E9 |
Skills Check | p. E96 |
Working with Lists | p. E101 |
Creating a List | p. E102 |
Entering Data Using the Data Form | p. E102 |
Using Data Validation | p. E105 |
Validating List Data | p. E107 |
Including Input and Error Messages | p. E107 |
Sorting a List | p. E111 |
Performing a Multi-Level Sort | p. E111 |
Creating a Custom List | p. E112 |
Modifying Records | p. E115 |
Finding Records | p. E115 |
Editing Records | p. E117 |
Deleting Records | p. E117 |
Outlining a Worksheet | p. E119 |
Subtotaling a List | p. E123 |
Filtering a List | p. E126 |
Filtering a List Using AutoFilter | p. E126 |
Creating a Custom AutoFilter | p. E127 |
Filtering a List Using Advanced Filters | p. E130 |
Extracting Unique Records | p. E130 |
Using a Criteria Range | p. E131 |
Chapter Summary | p. E135 |
Commands Review | p. E136 |
Concepts Check | p. E136 |
Skills Check | p. E137 |
Expert Unit 1 Performance Assessment | p. 143 |
Assessing Proficiency | p. 143 |
Writing Activities | p. 149 |
Internet Project | p. 151 |
Job Study | p. 151 |
Interpreting and Integrating Data | p. 153 |
Unit 2 MOUS Skills | p. 154 |
Using Excel's Analysis Tools | p. 155 |
Introduction to PivotTables | p. 155 |
Creating a PivotTable | p. 157 |
Formatting and Sorting a PivotTable | p. 161 |
Managing a PivotTable Report | p. 166 |
Creating PivotChart Reports | p. 170 |
Creating Interactive PivotTables for the Web | p. 176 |
Analyzing Data Using Goal Seek | p. 179 |
Analyzing Data Using Solver | p. 180 |
Creating Scenarios | p. 185 |
Creating a Trendline on a Chart | p. 187 |
Chapter Summary | p. 191 |
Commands Review | p. 192 |
Concepts Check | p. 193 |
Skills Check | p. 193 |
Managing and Auditing Worksheets | p. 199 |
Introduction to Macros | p. 200 |
Recording a Macro | p. 200 |
Running a Macro | p. 202 |
Assigning a Macro to a Command Button | p. 204 |
Editing a Macro | p. 205 |
Working with Toolbars and Menus | p. 210 |
Floating and Docked Toolbars | p. 210 |
Hiding and Displaying Toolbars | p. 211 |
Customizing Toolbars and Menus | p. 211 |
Auditing Workbooks | p. 217 |
Displaying the Auditing Toolbar | p. 217 |
Tracing Dependents and Precedents | p. 219 |
Tracing Errors | p. 219 |
Chapter Summary | p. 220 |
Commands Review | p. 221 |
Concepts Check | p. 222 |
Skills Check | p. 222 |
Collaborating with Workgroups | p. 225 |
Benefits and Limitations of Sharing Workbooks | p. 225 |
Protecting Workbooks | p. 226 |
Applying and Removing Passwords | p. 226 |
Applying and Removing Cell, Worksheet, and Workbook Protection | p. 228 |
Tracking Changes | p. 234 |
Accepting and Rejecting Tracked Changes | p. 235 |
Creating, Editing, and Removing a Comment | p. 239 |
Merging Workbooks | p. 240 |
Working with Multiple Worksheets | p. 242 |
Chapter Summary | p. 244 |
Commands Review | p. 245 |
Concepts Check | p. 245 |
Skills Check | p. 246 |
Using Data from the Internet and Other Sources | p. 251 |
Importing from and Exporting to Text Files | p. 252 |
Importing Data from Text Files | p. 252 |
Importing Data from Word Using Drag and Drop | p. 254 |
Exporting Data to Text Files | p. 256 |
Accessing and Placing Data on the Web | p. 257 |
Publishing Excel Worksheets as HTML | p. 258 |
Importing Data from a Web Page into Excel | p. 261 |
Using Database and Web Queries | p. 262 |
Using XML to Share Excel Data of the Web | p. 267 |
Linking and Embedding Objects | p. 267 |
Chapter Summary | p. 271 |
Commands Review | p. 272 |
Concepts Check | p. 272 |
Skills Check | p. 273 |
Expert Unit 2 Performance Assessment | p. 277 |
Assessing Proficiency | p. 277 |
Writing Activities | p. 281 |
Internet Project | p. 283 |
Job Study | p. 284 |
Index | p. 285 |
Table of Contents provided by Syndetics. All Rights Reserved. |