|
1 Maximize the Power of Office 2007. |
|
|
|
#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. |
|
|
|
|
|
#7 Digitally Sign a Document. |
|
|
|
#8 Mark a Document as Final. |
|
|
|
|
|
#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. |
|
|
|
|
|
|
|
#20 Use Word’s Thesaurus and Dictionary. |
|
|
|
|
|
3 Jazz Up Your Work with Word. |
|
|
|
#22 Create a Bibliography. |
|
|
|
#23 Insert Footnotes and Endnotes. |
|
|
|
#24 Generate a Table of Contents. |
|
|
|
|
|
|
|
#27 Add a Cross-Reference. |
|
|
|
#28 Emphasize Text with Drop Caps. |
|
|
|
#29 Summarize Information with a Chart. |
|
|
|
|
|
#31 Wrap Text Around a Graphic. |
|
|
|
#32 Add Line Numbers to Your Document. |
|
|
|
|
|
#33 Automate Data Entry with AutoFill. |
|
|
|
|
|
|
|
#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. |
|
|
|
|
|
#53 Customize Your Chart with Chart Objects. |
|
|
|
#54 Reveal Trends with Trendlines. |
|
|
|
|
|
#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. |
|
|
|
|
|
|
|
#63 Insert Action Buttons. |
|
|
|
|
|
#65 Create a Self-Running Presentation. |
|
|
|
#66 Write on a Slide During a Presentation. |
|
|
|
#67 Create Speaker Notes. |
|
|
|
|
|
#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. |
|
|
|
|
|
|
|
#77 Add a Picture to Your Presentation. |
|
|
|
#78 Insert a SmartArt Graphic. |
|
|
|
#79 Add Video or Sound to Your Presentation. |
|
|
|
|
|
#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. |
|
|
|
|
|
|
|
#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. |
|
|
|
|
|
#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. |
|
|
|
|
|
|
|
#112 Set Up an Out-of-Office Reply. |
|
|
|
#113 Manage Messages Using Rules. |
|
|
|
|
|
#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. |
|
|
|
|