| Introduction |
|
vii | |
| Navigating the Textbook and Supplemental Print Resources |
|
ix | |
|
|
|
|
Chapter 5 Using Advanced Formatting, Lists, and Charts |
|
|
2 | (44) |
|
Lesson 36 Inserting Text Files and Blank Pages |
|
|
4 | (6) |
|
Lesson 37 Creating and Editing Styles |
|
|
10 | (8) |
|
Lesson 38 Managing Style Formatting |
|
|
18 | (11) |
|
Lesson 39 Working with Multilevel Lists |
|
|
29 | (6) |
|
Lesson 40 Inserting Charts |
|
|
35 | (11) |
|
End-of-Chapter Activities |
|
|
42 | (4) |
|
Chapter 6 Using Reusable Content and Markup Tools |
|
|
46 | (70) |
|
Lesson 41 Customizing Language and Word Options |
|
|
48 | (10) |
|
Lesson 42 Using Advanced Find and Replace |
|
|
58 | (9) |
|
Lesson 43 Using Building Blocks |
|
|
67 | (6) |
|
Lesson 44 Inserting Fields from Quick Parts |
|
|
73 | (6) |
|
Lesson 45 Creating Custom Templates, Themes, and Style Sets |
|
|
79 | (12) |
|
Lesson 46 Tracking Changes |
|
|
91 | (7) |
|
Lesson 47 Comparing Documents |
|
|
98 | (9) |
|
Lesson 48 Restricting Access to Documents |
|
|
107 | (9) |
|
End-of-Chapter Activities |
|
|
112 | (4) |
|
Chapter 7 Using Advanced Tables and Graphics |
|
|
116 | (50) |
|
Lesson 49 Customizing Table Styles |
|
|
118 | (8) |
|
Lesson 50 Using Advanced Table Features |
|
|
126 | (11) |
|
Lesson 51 Using Advanced Graphics |
|
|
137 | (9) |
|
Lesson 52 Linking Text Boxes |
|
|
146 | (9) |
|
Lesson 53 Creating WordArt and Watermarks |
|
|
155 | (11) |
|
End-of-Chapter Activities |
|
|
161 | (5) |
|
Chapter 8 Working with Long Documents |
|
|
166 | (60) |
|
Lesson 54 Working with Outlines |
|
|
168 | (8) |
|
Lesson 55 Advanced Layout Options |
|
|
176 | (8) |
|
Lesson 56 Working with Master Documents |
|
|
184 | (7) |
|
Lesson 57 Creating Custom Headers and Footers, Bookmarks, and Cross-References |
|
|
191 | (9) |
|
Lesson 58 Creating an Index |
|
|
200 | (8) |
|
Lesson 59 Managing Source Information and Generating Special Tables |
|
|
208 | (18) |
|
End-of-Chapter Activities |
|
|
220 | (6) |
|
Chapter 9 Embedding and Linking Objects, Using Mail Merge, and Creating Macros |
|
|
226 | (54) |
|
Lesson 60 Copying, Moving, and Embedding Data and Objects |
|
|
228 | (9) |
|
Lesson 61 Linking Files and Objects |
|
|
237 | (6) |
|
Lesson 62 Integrating Word and PowerPoint |
|
|
243 | (5) |
|
Lesson 63 Creating a Directory with Mail Merge |
|
|
248 | (9) |
|
Lesson 64 Using Merge to Create E-mail |
|
|
257 | (6) |
|
Lesson 65 Working with Macros |
|
|
263 | (17) |
|
End-of-Chapter Activities |
|
|
275 | (5) |
|
|
|
|
Chapter 6 Managing Large Workbooks |
|
|
280 | (66) |
|
Lesson 49 Customizing the Excel Interface and Converting Text |
|
|
282 | (8) |
|
Lesson 50 Formatting Cells |
|
|
290 | (8) |
|
Lesson 51 Hiding and Formatting Workbook Elements |
|
|
298 | (8) |
|
Lesson 52 Customizing Styles and Themes |
|
|
306 | (10) |
|
Lesson 53 Customizing Data Entry |
|
|
316 | (7) |
|
Lesson 54 Formatting and Replacing Data Using Functions |
|
|
323 | (8) |
|
Lesson 55 Working with Subtotals |
|
|
331 | (15) |
|
End-of-Chapter Activities |
|
|
341 | (5) |
|
Chapter 7 Creating Charts, Shapes, and Templates |
|
|
346 | (66) |
|
Lesson 56 Formatting Chart Elements |
|
|
348 | (7) |
|
Lesson 57 Formatting the Value Axis |
|
|
355 | (9) |
|
Lesson 58 Creating Stacked Area Charts |
|
|
364 | (8) |
|
Lesson 59 Working with Sparklines and Trendlines |
|
|
372 | (7) |
|
Lesson 60 Drawing and Positioning Shapes |
|
|
379 | (6) |
|
Lesson 61 Formatting Shapes |
|
|
385 | (5) |
|
Lesson 62 Enhancing Shapes with Text and Effects |
|
|
390 | (7) |
|
Lesson 63 Working with Templates |
|
|
397 | (15) |
|
End-of-Chapter Activities |
|
|
407 | (5) |
|
Chapter 8 Creating Macros and Using Data Analysis Tools |
|
|
412 | (54) |
|
Lesson 64 Recording a Macro |
|
|
414 | (10) |
|
Lesson 65 Using Functions |
|
|
424 | (9) |
|
Lesson 66 Working with Absolute References and Using Financial Functions |
|
|
433 | (7) |
|
Lesson 67 Creating and Interpreting Financial Statements |
|
|
440 | (7) |
|
Lesson 68 Creating Scenarios and Naming Ranges |
|
|
447 | (7) |
|
Lesson 69 Finding and Fixing Errors in Formulas |
|
|
454 | (12) |
|
End-of-Chapter Activities |
|
|
462 | (4) |
|
Chapter 9 Importing and Analyzing Database Data |
|
|
466 | (70) |
|
Lesson 70 Importing Data into Excel |
|
|
468 | (6) |
|
Lesson 71 Working with Excel Tables |
|
|
474 | (8) |
|
Lesson 72 Using Advanced Filters, Slicers, and Database Functions |
|
|
482 | (11) |
|
Lesson 73 Using Flash Fill and Data Consolidation |
|
|
493 | (8) |
|
Lesson 74 Linking Workbooks |
|
|
501 | (7) |
|
Lesson 75 Using PivotTables |
|
|
508 | (8) |
|
Lesson 76 Using PivotCharts |
|
|
516 | (8) |
|
Lesson 77 Using PowerPivot and Power View |
|
|
524 | (12) |
|
End-of-Chapter Activities |
|
|
533 | (3) |
|
Chapter 10 Collaborating with Others and Preparing a Final Workbook for Distribution |
|
|
536 | (48) |
|
Lesson 78 Tracking Changes |
|
|
538 | (10) |
|
Lesson 79 Ensuring Data Integrity |
|
|
548 | (9) |
|
Lesson 80 Protecting Data |
|
|
557 | (7) |
|
Lesson 81 Securing a Workbook |
|
|
564 | (5) |
|
Lesson 82 Finalizing a Workbook |
|
|
569 | (6) |
|
Lesson 83 Sharing a Workbook |
|
|
575 | (9) |
|
End-of-Chapter Activities |
|
|
581 | (3) |
|
|
|
|
Chapter 4 Customizing Tables and Databases |
|
|
584 | (34) |
|
Lesson 26 Normalizing and Analyzing Tables |
|
|
586 | (10) |
|
Lesson 27 Using Advanced Field and Table Properties |
|
|
596 | (8) |
|
Lesson 28 Formatting and Correcting Tables |
|
|
604 | (4) |
|
Lesson 29 Creating Macros |
|
|
608 | (10) |
|
End-of-Chapter Activities |
|
|
615 | (3) |
|
Chapter 5 Developing Advanced Queries |
|
|
618 | (32) |
|
Lesson 31 Creating Crosstab Queries |
|
|
620 | (7) |
|
Lesson 32 Creating Queries That Find Unmatched or Duplicate Records |
|
|
627 | (4) |
|
Lesson 33 Creating Queries That Prompt for Input |
|
|
631 | (6) |
|
Lesson 34 Creating Action Queries |
|
|
637 | (4) |
|
Lesson 35 Working with Advanced Query Options |
|
|
641 | (9) |
|
End-of-Chapter Activities |
|
|
647 | (3) |
|
Chapter 6 Customizing Forms and Reports |
|
|
650 | (64) |
|
Lesson 36 Working with Report Layouts |
|
|
652 | (8) |
|
Lesson 37 Working with Controls |
|
|
660 | (11) |
|
Lesson 38 Formatting Controls |
|
|
671 | (7) |
|
Lesson 39 Creating Special Forms |
|
|
678 | (5) |
|
Lesson 40 Working with Subforms and Subreports |
|
|
683 | (8) |
|
Lesson 41 Working with Charts |
|
|
691 | (8) |
|
Lesson 42 Creating Switchboards |
|
|
699 | (7) |
|
Lesson 43 Creating Navigation Forms |
|
|
706 | (8) |
|
End-of-Chapter Activities |
|
|
711 | (3) |
|
Chapter 7 Securing, Integrating, and Maintaining Data |
|
|
714 | (32) |
|
Lesson 44 Converting and Securing Data |
|
|
716 | (5) |
|
Lesson 45 Sharing Data with Word and Other Text Applications |
|
|
721 | (6) |
|
Lesson 46 Sharing Data with Excel and Access |
|
|
727 | (7) |
|
Lesson 47 Linking to Data Sources |
|
|
734 | (4) |
|
Lesson 48 Customizing Access |
|
|
738 | (8) |
|
End-of-Chapter Activities |
|
|
744 | (2) |
|
Microsoft PowerPoint 2013 |
|
|
|
Chapter 5 Working with Masters, Handouts, and Text |
|
|
746 | (48) |
|
Lesson 32 Working with Advanced Slide Master Features |
|
|
748 | (7) |
|
Lesson 33 Customizing Themes and Effects |
|
|
755 | (5) |
|
Lesson 34 Working with Notes and Handouts |
|
|
760 | (9) |
|
Lesson 35 Integrating PowerPoint with Word |
|
|
769 | (7) |
|
Lesson 36 Fine-Tuning Text Formats |
|
|
776 | (8) |
|
Lesson 37 Using Research Tools |
|
|
784 | (10) |
|
End-of-Chapter Activities |
|
|
790 | (4) |
|
Chapter 6 Working with Graphic Objects and Media |
|
|
794 | (54) |
|
Lesson 38 Applying Advanced Picture Formatting |
|
|
796 | (8) |
|
Lesson 39 Working with Advanced Multimedia Features |
|
|
804 | (6) |
|
Lesson 40 Applying Advanced Animations |
|
|
810 | (8) |
|
Lesson 41 Drawing and Adjusting Tables |
|
|
818 | (10) |
|
Lesson 42 Formatting Tables |
|
|
828 | (7) |
|
Lesson 43 Formatting Charts |
|
|
835 | (13) |
|
End-of-Chapter Activities |
|
|
844 | (4) |
|
Chapter 7 Finalizing and Sharing a Presentation |
|
|
848 | (37) |
|
Lesson 44 Making a Presentation Accessible to Everyone |
|
|
850 | (5) |
|
Lesson 45 Saving a Presentation in Other Formats |
|
|
855 | (7) |
|
Lesson 46 Working with Links and Actions |
|
|
862 | (7) |
|
Lesson 47 Working with Online Presentations |
|
|
869 | (16) |
|
End-of-Chapter Activities |
|
|
880 | (5) |
| Index |
|
885 | |
