Learning Microsoft Office 2010, Advanced Student Edition -- CTE/School

Introduction vii

Microsoft Word 2010

Chapter 1 Using Advanced Lists and Charts 2

Lesson 1 — Inserting text Files and Blank Pages 4

Lesson 2 — Creating and Editing Styles 10

Lesson 3 — Managing Style Formatting 17

Lesson 4 — Creating Multilevel Lists 23

Lesson 5 — Inserting Charts 29

End-of-Chapter Assessments 37

Chapter 2 Using Reusable Content and Markup Tools 40

Lesson 6 — Translating Text and Customizing Word Options 42

Lesson 7 — Using Advanced Find and Replace 51

Lesson 8 — Using Building Blocks 60

Lesson 9 — Inserting Fields from Quick Parts 67

Lesson 10 — Creating Custom Themes 73

Lesson 11 — Using Comments 79

Lesson 12 — Tracking Changes 85

Lesson 13 — Comparing Documents 92

End-of-Chapter Assessments 101

Chapter 3 Using Advanced Tables and Graphics 106

Lesson 14 — Customizing Table Styles 108

Lesson 15 — Using Advanced Table Features 115

Lesson 16 — Using Advanced Graphics 125

Lesson 17 — Linking Text Boxes 134

Lesson 18 — Creating WordArt and Watermarks 144

End-of-Chapter Assessments 151

Chapter 4 Protecting Documents and Forms 156

Lesson 19 — Creating Forms 158

Lesson 20 — Protecting Documents 166

Lesson 21 — Inspecting and Checking Documents  174

Lesson 22 — Marking a Document as Final and Using Digital Signatures 179

End-of-Chapter Assessments 187

Microsoft Excel 2010

Chapter 1 Managing Large Workbooks and Using Advanced Sorting and Filtering 192

Lesson 1 — Customizing the Excel Interface and Converting Text 195

Lesson 2 — Formatting Cells 202

Lesson 3 —Hiding and Formatting Workbook. 208

Lesson 4 — Customizing Styles and Themes. 216

Lesson 5 — Using Advanced Sort. 222

Lesson 6 — Using Advanced Filtering. 229

Lesson 7 — Customizing Data Entry. 241

Lesson 8 — Using Find and Replace. 246

Lesson 9 — Working with Hyperlinks. 252

Lesson 10 — Saving Excel Data in a Different File Format. 260

Lesson 11 — Working with Subtotals. 264

End of Chapter Assessments . 273

Chapter 2 Creating Charts, Shapes, and Templates . 278

Lesson 12 — Formatting Chart Elements. 280

Lesson 13 — Formatting the Value Axis. 287

Lesson 14 — Creating Stacked Area Charts . 295

Lesson 15 — Working with Sparklines. 301

Lesson 16 — Drawing and Positioning Shapes . 307

Lesson 17 — Formatting Shapes . 312

Lesson 18 — Enhancing Shapes with Text and Effects. 317

Lesson 19 — Working with Templates. 323

Lesson 20 — Protecting Data. 330

End-of-Chapter Assessments. 336

Chapter 3 Using the Data Analysis, Scenario, and Worksheet Auditing Features . 340

Lesson 21 — Inserting Functions and Using Logical Functions . 342

Lesson 22 — Working with Absolute References and Using Financial Functions. 348

Lesson 23 — Creating and Interpreting Financial Statements. 354

Lesson 24 — Creating Scenarios and Naming Ranges. 361

Lesson 25 — Finding and Fixing Errors in Formulas . 367

Lesson 26 — Controlling Data . 374

End-of-Chapter Assessments. 381

Microsoft Access 2010

Chapter 1 Enhancing Queries. 384

Lesson 1 — Creating Crosstab Queries. 386

Lesson 2 — Creating Queries That Find Unmatched or Duplicate Records. 394

Lesson 3 — Creating Queries That Prompt for Input . 399

Lesson 4 — Creating Action Queries. 405

Lesson 5 — Working with Advanced Query Options. 412

End-of-Chapter Assessments. 420

Chapter 2 Customizing Forms and Reports . 422

Lesson 6 — Working with Report Layouts. 425

Lesson 7 — Working with Controls. 432

Lesson 8 — Formatting Controls. 444

Lesson 9 — Grouping, Sorting, and Filtering Report Data . 451

Lesson 10 — Creating Special Forms and PivotTables. 458

Lesson 11 — Working with Subforms and Subreports. 467

Lesson 12 — Working with Charts . 475

Lesson 13 — Creating Switchboards. 485

Lesson 14 — Creating Navigation Forms. 492

End-of-Chapter Assessments. 497

Chapter 3 Enhancing Tables and Working with Macros. 500

Lesson 15 — Normalizing and Analyzing Tables. 502

Lesson 16 — Using Advanced Field and Table Properties . 512

Lesson 17 — Formatting and Correcting Datasheets. 519

Lesson 18 — Creating Macros. 523

End-of-Chapter Assessments. 529

Microsoft PowerPoint 2010

Chapter 1 Working with Masters, Comments, Handouts, and Pictures . 532

Lesson 1 — Advanced Slide Master Features . 534

Lesson 2 — Working with Notes and Handouts . 540

Lesson 3 — Working with Comments in a Presentation. 547

Lesson 4 — Exporting Slide Handouts to Word. 553

Lesson 5 — Working with Presentation Properties. 558

Lesson 6 — Making a Presentation Accessible to Everyone . 564

End-of-Chapter Assessments. 569

Chapter 2 Applying Advanced Graphic and Media Techniques. 574

Lesson 7 — Advanced Picture Formatting. 576

Lesson 8 — Advanced Multimedia Features. 583

Lesson 9 — Working with Advanced Photo Album Features. 589

Lesson 10 — Advanced Animation Features . 595

Lesson 11 — Finalizing Slide Shows. 606

Lesson 12 — Working with Actions. 612

End-of-Chapter Assessments. 618

Chapter 3 Creating Presentations Using Tables and Charts . 622

Lesson 13 — Drawing and Adjusting Tables. 624

Lesson 14 — Formatting Tables. 632

Lesson 15 — Formatting Charts. 639

Lesson 16 — Adding Objects to Your Presentation. 644

End-of-Chapter Assessments. 649

Index . 654

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.