Gunter S.K. Office 2010 Visual Quick Tips

Wiley Publishing, Inc., 2010. — 358 p. — ISBN: 0470577754 (e-book).
На англ. языке.Хотите узнать, что нового в Office 2010, работать более эффективно, и поднять ваши навыки работы в Word, Excel, PowerPoint, Access, Outlook, и на новый уровень? Тогда эта книга для вас. Эта книга повысит вашу производительность, предоставляя подсказки и советы, которые помогут вам работать эффективнее и быстрее.Would you like to discover what's new in Office 2010, work more efficiently, and take your Word, Excel, PowerPoint, Access, Outlook, and Publisher skills to new levels? Then this Visual Quick Tips book is for you. This book will increase your productivity by providing you with shortcuts, tricks, and tips to help you work smarter and faster.Straightforward task descriptions.
Succinct explanations.
Full-color screen shots.
Numbered steps.Learn to:
Customize the Quick Access toolbar;
Automate Office tasks with macros;
Add pizzazz with Office graphics.General Office 2010 Maximizing Tips
Customize the Quick Access Toolbar.
Customize the Ribbon.
Control the Ribbon Display.
Share a Customized Ribbon.
Preview Paste Options.
Automate Office Tasks with Macros.
Change the Default Font and Size.
Organize Notes with OneNote.Timesaving Tips for Office Files
Change the Default File Save Location.
Check Document Compatibility.
Save Office Files as PDF Documents.
Assign Document Properties.
Remove Sensitive Document Information.
Encrypt a Document.
Add a Digital Signature.
Control Author Permissions.
Mark a Document as Final.
Recover an Unsaved Document.Boosting Your Productivity in Word
Add a Header or Footer Building Block.
Share Building Blocks with Others.
Translate Text.
Create a Blog Post.
Search Through a Document.
Look Up a Synonym or Definition.
Jump Around Documents with Bookmarks.
Navigate Long Documents with the Navigation Pane.
Automate Typing with AutoText.
Fix Misspellings with AutoCorrect.
Emphasize Text with Drop Caps.
Set a New Default Line Spacing.
Quickly Insert a Horizontal Line.
Resume Numbering in an Interrupted Numbered List.
Set Off a Paragraph with a Border.
Track Changes in a Document.
Compare Documents.
Add Filler Text.
Keep Words Together with a Nonbreaking Space.
Summarize Information with a Chart.Utilizing Word’s Document Building Tools
Create a Bibliography.
Insert Footnotes and Endnotes.
Generate a Table of Contents.
Insert a Cover Page.
Generate an Index.
Add a Cross-Reference.
Add Line Numbers to Your Document.Optimizing Excel
Automatically Open Your Favorite Workbook.
Automate Data Entry with AutoFill.
Color-Code and Name Worksheet Tabs.
Keep Cells in View with a Watch Window.
Protect Cells from Unauthorized Changes.
Generate Random Numbers in Your Cells.
Freeze Headings for Easier Scrolling.
Insert a Comment in a Formula.
Join Text from Separate Cells.
Add a Calculator to the Quick Access Toolbar.
Audit a Worksheet for Errors.
Create Projections.
Establish What-If Scenarios.
Set Goals with Goal Seek.
Define and Solve Problems with Solver.
Create a Database Table.
Add and Edit Records Using Data Forms.
Sort and Filter Records.
Restrict Cell Entries with Data-Validation Rules.Polishing Your Spreadsheet Data
Apply Workbook Themes.
Change Gridline Color.
Print Gridlines.
Add Emphasis with Borders.
Add a Background Color, Pattern, or Image.
Color-Code Your Data with Conditional Formatting.
Customize Your Chart with Chart Objects.
Reveal Trends with Trendlines.
Add Sparklines.
Wrap Text for Easy Reading.
Change Cell Text Orientation.
Center-Align Printed Data.
Center Text Across Columns without Merging Cells.Increasing PowerPoint’s Potential
Convert a Word Document into a Presentation.
Organize a Presentation into Sections.
Send a Presentation to Reviewers.
Reuse a Slide from Another Presentation.
Rehearse Timings.
Record Narration.
Insert Action Buttons.
Insert a Hyperlink.
Add an Equation.
Create a Self-Running Presentation.
Write on a Slide During a Presentation.
Create Speaker Notes.
Print Handouts.
Compress Media Files.
Turn a Presentation into a Video.
Copy a Presentation to a CD.
Save a Presentation on SkyDrive.
Broadcast a Presentation.Enhancing Your Presentations
Create a Custom Slide Layout.
Insert a Custom Slide Master.
Streamline Your Presentation with Themes.
Customize a Theme.8
Save a Custom Theme.
Add a Picture to Your Presentation.
Insert a SmartArt Graphic.
Add Video or Sound to Your Presentation.
Edit a Video.
Animate Your Slides.
Create a Photo Album Presentation.Harnessing Access
Save Time with Templates.
Import Data from Excel.
Collect Data from Outlook.
Type Less with Default Values.
Make a Field Required.
Set a Field Caption.
Copy a Previous Record.
Apply Input Masks.
Set Data Validation Rules.
Attach Files to Records.
Insert an OLE Object.
Save a Filter as a Query.
Display Summary Statistics.
View Object Dependencies.
Document the Database.Customizing Your Database and Forms
Assign a Theme to a Form.
Change a Form’s Tab Order.
Jazz Up Your Forms with Pictures.
Add a Background to a Report.
Color-Code Your Data with Conditional Formatting.
Summarize a Datasheet with a PivotTable.
Summarize a Datasheet with a PivotChart.Streamlining Outlook Tasks
Add Multiple E-mail Accounts.
Create Your Own Quick Steps.
Create a Distribution List.
Customize an E-mail Signature.
Encrypt a Message.
Recall a Message.
Set Up an Out-of-Office Reply.
Manage Messages Using Rules.
Clean Up Folders and Conversations.
Filter Junk E-mail.
Archive E-mails to Create Space.
View Archived E-mails.
Subscribe to RSS Feeds.
Export a Report to Word.
Create Mailing Labels.
Automate Access Tasks with Macros.
Customizing Your Database and Forms
Assign a Theme to a Form.
Change a Form’s Tab Order.
Jazz Up Your Forms with Pictures.
Add a Background to a Report.
Color-Code Your Data with Conditional Formatting.
Summarize a Datasheet with a PivotTable.
Summarize a Datasheet with a PivotChart.Streamlining Outlook Tasks
Add Multiple E-mail Accounts.
Create Your Own Quick Steps.
Create a Distribution List.
Customize an E-mail Signature.
Encrypt a Message.
Recall a Message.
Set Up an Out-of-Office Reply.
Manage Messages Using Rules.
Clean Up Folders and Conversations.
Filter Junk E-mail.
Archive E-mails to Create Space.
View Archived E-mails.
Subscribe to RSS Feeds.
Export a Report to Word.
Create Mailing Labels.
Automate Access Tasks with Macros.Managing Multiple Priorities with Outlook
Create an Electronic Business Card.
Locate an Address with Map It.
Categorize an Outlook Item.
Send a Calendar Snapshot.
View Two Calendars in Overlay Mode.
Record Journal Entries Automatically.
Delegate a Task.Adding Power to Publisher
Find Templates Online.
Insert a Text File.
Nudge a Text Box.
Move a Page.
Automatically Fit Text.
Control Hyphenation.
Send Your Publication as an E-mail.
Save a Publication for a Commercial Printer.
Creating Pizzazz with Office Graphics.
Capture a Picture of Your Screen.
Organize Clip Art.
Find More Clip Art Online.
Remove an Image Background.
Assign Artistic Effects to a Picture.
Control Graphic Placement with Ordering.
Group Graphic Objects.
Customize Clip Art with the Ungroup Command.
Add a Caption to a Graphic.
Turn a WordArt Object into a Picture File.
Add a Custom Watermark.
Wrap Text Around a Graphic.
Organize Pictures with Picture Manager.