Title Details

#1 Make a Document Backward Compatible.

#2 Save Office Documents as Web Pages.

#3 Automate Office Tasks with Macros.

#4 Set Document Properties.

#5 Remove Sensitive Information from Your Document.

#6 Encrypt a Document.

#7 Digitally Sign a Document.

#8 Mark a Document as Final.

#9 Enable Smart Tags.

#10 Customize the Quick Access Toolbar.

#11 Customize the Ribbon.

#12 Change the Save Settings.

2 Boost Word’s Potential.

#13 Add a Header/Footer Building Block to the Gallery.

#14 Share Building Blocks with Others.

#15 Work with the Document Map.

#16 Scan Document Content with Thumbnails.

#17 Track Changes in a Document.

#18 Compare Documents.

#19 Translate Text.

#20 Use Word’s Thesaurus and Dictionary.

#21 Create a Blog Post.

3 Jazz Up Your Work with Word.

#22 Create a Bibliography.

#23 Insert Footnotes and Endnotes.

#24 Generate a Table of Contents.

#25 Insert a Cover Page.

#26 Generate an Index.

#27 Add a Cross-Reference.

#28 Emphasize Text with Drop Caps.

#29 Summarize Information with a Chart.

#30 Add a Watermark.

#31 Wrap Text Around a Graphic.

#32 Add Line Numbers to Your Document.

4 Optimize Excel.

#33 Automate Data Entry with AutoFill.

#34 Create Projections.

#35 Insert a Comment.

#36 Track and Review Workbook Changes.

#37 Calculate Using Formulas.

#38 Speed Up Your Calculations with Functions.

#39 Audit a Worksheet for Errors.

#40 Establish What-If Scenarios.

#41 Set Goals with Goal Seek.

#42 Define and Solve Problems with Solver.

#43 Create a Database Table.

#44 Add and Edit Records Using Data Forms.

#45 Sort and Filter Records.

#46 Set Data-Validation Rules.

#47 Password-Protect Your Work.

5 Unleash Your Inner Spreadsheet.

#48 Apply Workbook Themes.

#49 Add Emphasis with Borders.

#50 Add a Background Color, Pattern, or Image.

#51 Color-Code Your Data with Conditional Formatting.

#52 Chart Your Data.

#53 Customize Your Chart with Chart Objects.

#54 Reveal Trends with Trendlines.

#55 Align Cell Data.

#56 Wrap Text for Easy Reading.

#57 Set Print Preferences.

6 Explore the Possibilities with PowerPoint.

#58 Convert a Word Document into a Presentation.

#59 Send a Presentation to Reviewers.

#60 Reuse a Slide from Another Presentation.

#61 Rehearse Timing.

#62 Record Narration.

#63 Insert Action Buttons.

#64 Insert a Hyperlink.

#65 Create a Self-Running Presentation.

#66 Write on a Slide During a Presentation.

#67 Create Speaker Notes.

#68 Print Handouts.

#69 Copy a Presentation to CD.

#70 Publish a Web Presentation.

7 Express Yourself through Presentations.

#71 Choose a Slide Layout.

#72 Create a Custom Slide Layout.

#73 Insert a Custom Slide Master.

#74 Streamline Your Presentation with Themes.

#75 Customize a Theme.

#76 Save Your Own Theme.

#77 Add a Picture to Your Presentation.

#78 Insert a SmartArt Graphic.

#79 Add Video or Sound to Your Presentation.

#80 Animate Your Slides.

#81 Create a Photo Album Presentation.

8 Make Your Data Work for You with Access.

#82 Save Time with Templates.

#83 Import Data from Excel.

#84 Collect Data with Outlook.

#85 Import Contacts from Outlook.

#86 Type Less with Default Values.

#87 Make a Field Required.

#88 Set a Field Caption.

#89 Apply Input Masks.

#90 Set Data-Validation Rules.

#91 Attach Files to Records.

#92 Insert an OLE Object.

#93 Save a Filter as a Query.

#94 Display Summary Statistics.

#95 View Object Dependencies.

#96 Document the Database.

#97 Export a Report to Word.

#98 Create Mailing Labels.

#99 Automate Access Tasks with Macros.

9 Customize Your Database and Forms.

#100 Auto-Format a Form.

#101 Change a Form’s Tab Order.

#102 Auto-Format a Report.

#103 Save Your Report as a Web Page.

#104 Jazz Up Your Forms with Pictures.

#105 Color-Code Your Data with Conditional Formatting.

#106 Summarize a Datasheet with a PivotTable.

#107 Summarize a Datasheet with a PivotChart.

10 Tap Outlook’s Inner Power through E-mail.

#108 Create a Distribution List.

#109 Customize an E-mail Signature.

#110 Encrypt a Message.

#111 Recall a Message.

#112 Set Up an Out-of-Office Reply.

#113 Manage Messages Using Rules.

#114 Filter Junk E-mail.

#115 Archive E-mails to Create Space.

#116 View Archived E-mails.

#117 Subscribe to RSS Feeds.

11 Manage Multiple Priorities with Outlook.

#118 Create an Electronic Business Card.

#119 Locate an Address with Contact Maps.

#120 Categorize an Outlook Item.

#121 Forward Outlook Information to Your Mobile Phone.

#122 Send a Calendar Snapshot.

#123 View Calendars in Overlay Mode.

#124 Record Journal Entries Automatically.

#125 Delegate a Task.