Excel 2010: Intermediate (Student Manual)

✍ Scribed by Axzo Press

• Publisher: Axzo Press
• Year: 2011
• Tongue: English
• Leaves: 289
• Edition: Student
• Category: Library

✦ Synopsis

This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts. Course manual comes with CertBlaster exam prep software (download). This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2010.

✦ Table of Contents

Contents......Page 6
Introduction......Page 8
Topic A: About the manual......Page 9
Topic B: Setting your expectations......Page 12
Topic C: Re-keying the course......Page 16
Using multiple worksheets and workbooks......Page 18
Topic A: Using multiple workbooks......Page 19
Topic B: Linking worksheets with 3-D formulas......Page 23
Topic C: Linking workbooks......Page 27
Topic D: Managing workbooks......Page 33
Unit summary: Using multiple worksheets and......Page 36
Advanced formatting......Page 38
Topic A: Using special number formats......Page 39
Topic B: Using functions to format text......Page 46
Topic C: Working with styles......Page 50
Topic D: Working with themes......Page 57
Topic E: Other advanced formatting......Page 64
Unit summary: Advanced formatting......Page 77
Outlining and subtotals......Page 80
Topic A: Outlining and consolidating data......Page 81
Topic B: Creating subtotals......Page 91
Unit summary: Outlining and subtotals......Page 94
Cell and range names......Page 96
Topic A: Creating and using names......Page 97
Topic B: Managing names......Page 106
Unit summary: Cell and range names......Page 111
Tables......Page 114
Topic A: Sorting and filtering data......Page 115
Topic B: Advanced filtering......Page 123
Topic C: Working with tables......Page 130
Unit summary: Tables......Page 142
Web and sharing features......Page 146
Topic A: Saving workbooks as Web pages......Page 147
Topic B: Using hyperlinks......Page 155
Topic C: Sharing workbooks......Page 161
Unit summary: Web and sharing features......Page 164
Advanced charting......Page 166
Topic A: Chart formatting options......Page 167
Topic B: Combination charts......Page 175
Topic C: Graphical elements......Page 187
Unit summary: Advanced charting......Page 196
Documenting and auditing......Page 198
Topic A: Auditing features......Page 199
Topic B: Comments in cells and workbooks......Page 203
Topic C: Protection......Page 211
Topic D: Workgroup collaboration......Page 216
Unit summary: Documenting and auditing......Page 228
Templates and settings......Page 230
Topic A: Changing application settings......Page 231
Topic B: Using built-in templates......Page 238
Topic C: Creating and managing templates......Page 242
Unit summary: Templates and settings......Page 249
PivotTables and PivotCharts......Page 252
Topic A: Working with PivotTables......Page 253
Topic B: Rearranging PivotTables......Page 264
Topic C: Formatting PivotTables......Page 269
Topic D: Using PivotCharts......Page 273
Unit summary: PivotTables and PivotCharts......Page 276
Course summary......Page 280
Topic A: Course summary......Page 281
Topic B: Continued learning after class......Page 283
Glossary......Page 284
Index......Page 286

✦ Subjects

Библиотека;Компьютерная литература;Microsoft Office;Microsoft Excel;