Tricks of the Microsoft Office 2007 Gurus

by McFedries, Paul

• ISBN13: 9780789736666
• ISBN10: 0789736667
• Edition: 1st
• Format: Paperback
• Copyright: 2007-05-16
• Publisher: Que Pub

Summary

&>Paul McFedries, an Office "insider," that will help you learn the Office applications inside and out. Designed to bridge the gap between your expectation and reality, you will go beyond the basics and learn newly discovered techniques, shortcuts, and best practices. Through real-world examples that showcase how the tips and tricks can be used in everyday business tasks,Tricks of the Microsoft Office 2007 Guruswill help you get the most out of Office 2007. Part I MICROSOFT WORD TRICKS Chapter 1 Text Tricks Chapter 2 Formatting Tricks Chapter 3 Document Tricks Chapter 4 Page Layout Tricks Part II MICROSOFT EXCEL TRICKS Chapter 5 Formula and Function Tricks Chapter 6 Workbook and Worksheet Tricks Chapter 7 Data Analysis Tricks Chapter 8 Chart Tricks III MICROSOFT POWERPOINT TRICKS Chapter 9 Slide and Presentation Tricks Chapter 10 Animation Tricks Chapter 11 Slide Show Tricks IV MICROSOFT OUTLOOK TRICKS Chapter 12 Email Tricks Chapter 13 Calendar and Contacts Tricks V MICROSOFT ACCESS TRICKS 14 Table and Query Tricks Chapter 15 Form and Report Tricks APPENDIXES Author Bio Paul McFedries is well-known as a teacher of Office, Windows, and programming, particularly VBA. He is the president of Logophilia Limited, a technical writing company. Paul has been writing programs for PCs for more than 25 years and has been developing VBA applications since Microsoft first added VBA to the Office suite in 1994. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books includeAccess 2007 Forms, Reports, and Queries(Que, 2007),Formulas and Functions with Excel 2007(Que, 2007),VBA for the 2007 Microsoft Office System(Que, 2007), andWindows Vista Unleashed(Sams, 2006).

Author Biography

Paul McFedries is the president of Logophilia Limited, a technical writing company.

Now primarily a writer, Paul has worked as a programmer, consultant, spreadsheet developer,

and Web site developer. He has written more than 50 books that have sold more than

three million copies worldwide. These books include Access 2007 Forms, Reports, and Queries

(Que, 2007), Formulas and Functions with Excel 2007 (Que, 2007), VBA for the 2007

Microsoft Office System (Que, 2007), and Windows Vista Unleashed (Sams, 2006).

Table of Contents

Microsoft Word Tricks
Text Tricks	p. 7
Keeping Table Headings in View	p. 7
Summing a Column in a Table	p. 9
Calculating Tax in an Invoice Document	p. 11
Highlighting All Instances of a Word or Phrase	p. 13
Using AutoCorrect to Insert Your Signature	p. 14
Using AutoCorrect to Enter Boilerplate Text	p. 15
Saving Boilerplate as an AutoText Building Block	p. 16
Creating a Click-and-TypeText Placeholder	p. 18
Asking a User for Text Input	p. 19
Creating a Dynamic AutoCorrect Entry	p. 20
Adding Dummy Text to a Document	p. 21
Using the RAND Function	p. 21
Using the Repeat Command	p. 22
Inserting a Hyperlink in a Document	p. 23
Creating a Hyperlink Using AutoCorrect	p. 24
Creating a Hyperlink from Scratch	p. 25
Pasting a Hyperlink in Word	p. 26
Displaying Sentence Word Counts	p. 26
Finding the Longest Sentence in a Document	p. 28
Toggling Hidden Codes and Text	p. 30
Creating a Custom Spell Check Dictionary	p. 31
From Here	p. 33
Table of Contents provided by Publisher. All Rights Reserved.