| Introduction |
|
vii | |
| Navigating the Textbook and Supplemental Resources |
|
ix | |
|
|
|
|
Chapter 1 Using the Common Features of Microsoft Office 2013 |
|
|
2 | (76) |
|
Lesson 1 Microsoft Office 2013 Basics |
|
|
4 | (12) |
|
Lesson 2 Saving, Printing, and Closing Microsoft Office Files |
|
|
16 | (8) |
|
Lesson 3 Working with Existing Files |
|
|
24 | (11) |
|
Lesson 4 Using Command Options |
|
|
35 | (9) |
|
Lesson 5 Managing Program Windows |
|
|
44 | (13) |
|
Lesson 6 Using Microsoft Office Help |
|
|
57 | (7) |
|
Lesson 7 Managing Information Technology |
|
|
64 | (14) |
|
End-of-Chapter Activities |
|
|
73 | (5) |
|
|
|
|
Chapter 1 Getting Started with Microsoft Word 2013 |
|
|
78 | (106) |
|
Lesson 1 Creating Word Documents with Headers and Footers |
|
|
81 | (12) |
|
Lesson 2 Formatting Documents with Themes and Styles |
|
|
93 | (9) |
|
Lesson 3 Editing and Correcting Documents |
|
|
102 | (7) |
|
Lesson 4 Adjusting Alignment and Spacing |
|
|
109 | (8) |
|
Lesson 5 Creating Letters and Envelopes |
|
|
117 | (15) |
|
Lesson 6 Formatting Text with Fonts and Effects |
|
|
132 | (9) |
|
Lesson 7 Formatting and Sorting Lists |
|
|
141 | (7) |
|
Lesson 8 Inserting Pictures, Text Boxes, and Shapes |
|
|
148 | (11) |
|
Lesson 9 Formatting Graphics Objects |
|
|
159 | (12) |
|
Lesson 10 Working with SmartArt Graphics, Text Effects, and Page Borders |
|
|
171 | (13) |
|
End-of-Chapter Activities |
|
|
179 | (5) |
|
Chapter 2 Editing Documents and Working with Tables |
|
|
184 | (86) |
|
Lesson 11 Checking Spelling and Grammar |
|
|
187 | (10) |
|
Lesson 12 Moving a Selection |
|
|
197 | (6) |
|
Lesson 13 Copying a Selection |
|
|
203 | (5) |
|
Lesson 14 Inserting a Table |
|
|
208 | (10) |
|
Lesson 15 Aligning Tables |
|
|
218 | (8) |
|
Lesson 16 Drawing a Table |
|
|
226 | (8) |
|
Lesson 17 Performing Calculations in a Table |
|
|
234 | (7) |
|
Lesson 18 Improving a Document with Find and Replace and AutoCorrect |
|
|
241 | (11) |
|
Lesson 19 Working with Templates and Different File Types |
|
|
252 | (18) |
|
End-of-Chapter Activities |
|
|
264 | (6) |
|
Chapter 3 Creating Reports and Newsletters |
|
|
270 | (70) |
|
Lesson 20 Changing Case and Managing Document Properties |
|
|
272 | (7) |
|
Lesson 21 Formatting a One-Page Report |
|
|
279 | (11) |
|
Lesson 22 Managing Sources and Controlling Text Flow |
|
|
290 | (12) |
|
Lesson 23 Working with Newsletter Columns |
|
|
302 | (8) |
|
Lesson 24 Enhancing Paragraphs with Dropped Capitals, Borders, and Shading |
|
|
310 | (6) |
|
Lesson 25 Using Format Painter, Highlights, Symbols, and Quick Parts |
|
|
316 | (8) |
|
Lesson 26 Creating Letters and Labels with Mail Merge |
|
|
324 | (16) |
|
End-of-Chapter Activities |
|
|
336 | (4) |
|
|
|
|
Chapter 1 Getting Started with Microsoft Excel 2013 |
|
|
340 | (86) |
|
|
|
343 | (9) |
|
Lesson 2 Worksheet and Workbook Basics |
|
|
352 | (10) |
|
Lesson 3 Adding Worksheet Contents |
|
|
362 | (9) |
|
Lesson 4 Worksheet Formatting |
|
|
371 | (9) |
|
Lesson 5 More on Cell Entries and Formatting |
|
|
380 | (10) |
|
Lesson 6 Working with Ranges |
|
|
390 | (7) |
|
Lesson 7 Creating Formulas |
|
|
397 | (6) |
|
Lesson 8 Copying and Pasting |
|
|
403 | (7) |
|
Lesson 9 Techniques for Moving Data |
|
|
410 | (7) |
|
Lesson 10 Sheet, Display, and Print Operations |
|
|
417 | (9) |
|
End-of-Chapter Activities |
|
|
423 | (3) |
|
Chapter 2 Working with Formulas and Functions |
|
|
426 | (78) |
|
Lesson 11 Getting Started with Functions |
|
|
428 | (9) |
|
Lesson 12 Using Excel Tables |
|
|
437 | (8) |
|
Lesson 13 Working with the NOW Function and Named Ranges |
|
|
445 | (6) |
|
Lesson 14 Working with IF Functions |
|
|
451 | (10) |
|
Lesson 15 Working with Text Functions |
|
|
461 | (8) |
|
Lesson 16 Using Frozen Labels and Panes |
|
|
469 | (5) |
|
Lesson 17 Using Conditional Formatting and Find and Replace |
|
|
474 | (5) |
|
Lesson 18 Rotating Entries and Resolving Errors |
|
|
479 | (4) |
|
Lesson 19 Managing Worksheets and Performing Multi-Worksheet Operations |
|
|
483 | (7) |
|
Lesson 20 Modifying Print Options |
|
|
490 | (14) |
|
End-of-Chapter Activities |
|
|
500 | (4) |
|
|
|
504 | (60) |
|
Lesson 21 Building Basic Charts |
|
|
506 | (9) |
|
Lesson 22 Showing Percentages with a Pie Chart |
|
|
515 | (5) |
|
Lesson 23 Enhancing a Pie Chart |
|
|
520 | (6) |
|
Lesson 24 Adding Special Elements to a Chart or Sheet and Updating a Chart |
|
|
526 | (4) |
|
Lesson 25 Completing Chart Formatting |
|
|
530 | (9) |
|
Lesson 26 Comparing and Analyzing Data |
|
|
539 | (7) |
|
Lesson 27 Chart Printing and Publishing |
|
|
546 | (4) |
|
Lesson 28 Using Charts in Other Files |
|
|
550 | (5) |
|
Lesson 29 Making Special Purpose Charts |
|
|
555 | (9) |
|
End-of-Chapter Activities |
|
|
561 | (3) |
|
Chapter 4 Advanced Functions, PivotCharts, and PivotTables |
|
|
564 | (82) |
|
Lesson 30 Working with Hyperlinks |
|
|
566 | (8) |
|
Lesson 31 Using Advanced Sort |
|
|
574 | (8) |
|
Lesson 32 Using Advanced Filtering |
|
|
582 | (14) |
|
Lesson 33 Using Advanced Functions to Predict Trends |
|
|
596 | (7) |
|
Lesson 34 Using Advanced Functions for Data Analysis |
|
|
603 | (11) |
|
Lesson 35 Using LOOKUP Functions |
|
|
614 | (6) |
|
Lesson 36 Working with PivotTables and PivotCharts |
|
|
620 | (10) |
|
Lesson 37 Working with the Excel Data Model |
|
|
630 | (6) |
|
Lesson 38 Working with PowerPivot and Power View |
|
|
636 | (10) |
|
End-of-Chapter Activities |
|
|
641 | (5) |
|
|
|
|
Chapter 1 Getting Started with Microsoft Access 2013 |
|
|
646 | (68) |
|
Lesson 1 Planning a Database |
|
|
648 | (7) |
|
Lesson 2 Creating a Database with Access |
|
|
655 | (11) |
|
Lesson 3 Modifying and Adding Data to a Table |
|
|
666 | (7) |
|
Lesson 4 Modifying Fields in a Table |
|
|
673 | (7) |
|
Lesson 5 Importing and Protecting Data |
|
|
680 | (10) |
|
Lesson 6 Using Table Templates and Design View |
|
|
690 | (12) |
|
Lesson 7 Creating Other Objects |
|
|
702 | (12) |
|
End-of-Chapter Activities |
|
|
710 | (4) |
|
Chapter 2 Working with Queries |
|
|
714 | (60) |
|
Lesson 8 Managing Relationships Between Tables |
|
|
716 | (10) |
|
Lesson 9 Finding, Replacing, and Sorting Data |
|
|
726 | (6) |
|
|
|
732 | (5) |
|
Lesson 11 Creating a Query in Design View |
|
|
737 | (8) |
|
Lesson 12 Creating a Multi-Table Query |
|
|
745 | (6) |
|
Lesson 13 Using Criteria in a Query |
|
|
751 | (5) |
|
Lesson 14 Using Comparison Operators |
|
|
756 | (5) |
|
Lesson 15 Using Calculated Fields |
|
|
761 | (5) |
|
Lesson 16 Summarizing Data in Queries |
|
|
766 | (8) |
|
End-of-Chapter Activities |
|
|
771 | (3) |
|
Chapter 3 Working with Forms and Reports |
|
|
774 | (70) |
|
Lesson 17 Creating and Using a Form |
|
|
776 | (7) |
|
Lesson 18 Working with a Form in Layout View |
|
|
783 | (10) |
|
Lesson 19 Working with a Form in Design View |
|
|
793 | (8) |
|
Lesson 20 Working with Form Sections |
|
|
801 | (7) |
|
Lesson 21 Creating a Report |
|
|
808 | (11) |
|
Lesson 22 Modifying a Report in Design View |
|
|
819 | (6) |
|
Lesson 23 Creating Labels |
|
|
825 | (3) |
|
Lesson 24 Creating a Lookup List |
|
|
828 | (8) |
|
Lesson 25 Creating an Input Mask |
|
|
836 | (8) |
|
End-of-Chapter Activities |
|
|
842 | (2) |
|
Microsoft PowerPoint 2013 |
|
|
|
Chapter 1 Getting Started with Microsoft PowerPoint 2013 |
|
|
844 | (60) |
|
Lesson 1 Getting Started with PowerPoint |
|
|
846 | (8) |
|
Lesson 2 Working with Slides |
|
|
854 | (8) |
|
Lesson 3 Working with Headers, Footers, and Notes |
|
|
862 | (7) |
|
Lesson 4 Inserting and Formatting Pictures |
|
|
869 | (6) |
|
|
|
875 | (6) |
|
|
|
881 | (7) |
|
Lesson 7 Displaying the Presentation Outline |
|
|
888 | (4) |
|
Lesson 8 Arranging Slides |
|
|
892 | (5) |
|
Lesson 9 Adding Slide Transitions |
|
|
897 | (7) |
|
End-of-Chapter Activities |
|
|
901 | (3) |
|
Chapter 2 Working with Lists and Graphics |
|
|
904 | (58) |
|
Lesson 10 Working with Lists |
|
|
906 | (5) |
|
Lesson 11 Inserting Online Pictures |
|
|
911 | (5) |
|
Lesson 12 Inserting Symbols and Text Boxes |
|
|
916 | (6) |
|
Lesson 13 Drawing and Formatting Shapes |
|
|
922 | (10) |
|
Lesson 14 Positioning and Grouping Shapes |
|
|
932 | (9) |
|
Lesson 15 Creating WordArt |
|
|
941 | (5) |
|
Lesson 16 Creating SmartArt Diagrams |
|
|
946 | (8) |
|
Lesson 17 Creating a Photo Album |
|
|
954 | (8) |
|
End-of-Chapter Activities |
|
|
959 | (3) |
|
Chapter 3 Enhancing a Presentation |
|
|
962 | (40) |
|
Lesson 18 Modifying a Theme |
|
|
964 | (5) |
|
Lesson 19 Modifying a Background |
|
|
969 | (6) |
|
Lesson 20 Animating Slide Objects |
|
|
975 | (7) |
|
Lesson 21 Creating Multimedia Presentations |
|
|
982 | (8) |
|
Lesson 22 Working with Tables |
|
|
990 | (6) |
|
Lesson 23 Working with Charts |
|
|
996 | (6) |
| End-of-Chapter Activities |
|
1002 | (3) |
| Index |
|
1005 | |
