Synopses & Reviews
Quickly learn the most useful features of Microsoft Office 2007 with our easy to read four-in-one guide. This fast-paced book gives you the basics of Word, Excel, PowerPoint and Access so you can start using the new versions of these major Office applications right away.Unlike every previous version, Office 2007 offers a completely redesigned user interface for each program. Microsoft has replaced the familiar menus with a new tabbed toolbar (or "ribbon"), and added other features such as "live preview" that lets you see exactly what each option will look like in the document before you choose it. This is good news for longtime users who never knew about some amazing Office features because they were hidden among cluttered and outdated menus.Adapting to the new format is going to be a shock -- especially if you're a longtime user. That's where Office 2007: The Missing Manual comes in. Rather than present a lot of arcane detail, this quick & friendly primer teaches you how to work with the most-used Office features, with four separate sections covering the four programs. The book offers a walkthrough of Microsoft's redesigned Office user interface before taking you through the basics of creating text documents, spreadsheets, presentations, and databases with:
- Clear explanations
- Step-by-step instructions
- Lots of illustrations
- Plenty of friendly advice
It's a great way to master all 4 programs without having to stock up on a shelf-load of different books. This book has everything you need to get you up to speed fast.
Office 2007: The Missing Manual is truly the book that should have been in the box.
About the Author
Christopher Grover has worked as a technical writer, advertising copywriter, and product publicist for more than 25 years. He recently launched Bolinas Road Creative, an agency that helps small businesses promote their products and services. He is the author of Flash CS5: The Missing Manual.
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
E.A. Vander Veer started out in the software trenches, lexing and yaccing and writing shell scripts with the best of them. She remained busy and happy for years writing C++ programs and wresting data from recalcitrant databases. After a stint as an Object Technology Evangelist (yes, that's an actual job title), she found a way to unite all of her passions: writing about cool computer stuff in prose any human being can understand. Books followed-over a dozen so far-including Facebook: The Missing Manual, PowerPoint 2007: The Missing Manual, JavaScript for Dummies, and XML Blueprints. She lives in Texas with her husband and daughter. Email: [email protected].
Table of Contents
The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What's New in Office 2007; The Very Basics; About This Book; Part I: Word 2007; Chapter 1: Creating, Opening, and Saving Documents; 1 What Word Does; 2 Launching Word; 3 Creating a New Document; 4 Opening an Existing Document; 5 Your Different Document Views; 6 Saving and Closing Documents; Chapter 2: Entering and Editing Text; 1 Typing in Word; 2 Selecting Text; 3 Cutting, Copying, and Pasting; 4 Finding and Replacing Text; 5 Saving Keystrokes with Quick Parts; Chapter 3: Formatting Text, Paragraphs, and Headings; 1 Formatting Basics; 2 Formatting Characters; 3 Formatting Paragraphs; 4 Creating Bulleted and Numbered Lists; 5 Setting Tabs; 6 Using Word's Rulers; 7 Fast Formatting with Format Painter; 8 Formatting with Styles; 9 Modifying Styles; 10 Managing Style Sets; Chapter 4: Setting Up the Document; 1 Choosing Paper Size and Layout; 2 Setting Document Margins; 3 Applying Page Borders; 4 Adding Headers and Footers; 5 Working with Multiple Columns; 6 Hyphenation; 7 Dividing Your Document into Sections; Chapter 5: Themes and Templates; 1 Choosing a Theme; 2 Choosing a Template; Chapter 6: Spelling, Grammar, and Reference Tools; 1 Turning on Spelling and Grammar Checking; 2 Checking Spelling; 3 Checking Grammar and Style; 4 Controlling AutoCorrect; 5 Exploring Word's Research Tools; 6 Accessing Word's Thesaurus; 7 Translating Text; 8 Checking Your Word Count; Chapter 7: Printing Word Documents; 1 Quick and Easy Printing; 2 Print Preview; 3 Choosing a Printer; 4 Printing to an Adobe PDF File; 5 Faxing with Word; 6 Changing Print Settings; 7 Printing Envelopes; 8 Printing Labels; 9 >Setting Print Options; Chapter 8: Planning with Outlines; 1 Switching to Outline View; 2 Promoting and Demoting Headings; 3 Moving Outline Items; 4 Showing Parts of Your Outline; Part II: Excel 2007; Chapter 9: Creating and Navigating Worksheets; 1 What You Can Do with Excel; 2 Excel's New Features; 3 Creating a Basic Worksheet; 4 Editing Data; 5 Navigating in Excel; 6 Saving Files; 7 Opening Files; Chapter 10: Adding Information to Worksheets; 1 Adding Different Types of Data; 2 Quick Ways to Add Data; Chapter 11: Moving Data Around a Worksheet; 1 Selecting Cells; 2 Moving Cells Around; 3 Adding and Moving Columns or Rows; Chapter 12: Managing Worksheets and Workbooks; 1 Worksheets and Workbooks; 2 Find and Replace; 3 Spell Check; Chapter 13: Formatting Cells; 1 Formatting Cell Values; 2 Formatting Cell Appearance; Chapter 14: Viewing and Printing Worksheets; 1 Controlling Your View; 2 Printing; 3 Controlling Pagination; Chapter 15: Building Basic Formulas; 1 Creating a Basic Formula; 2 Formula Shortcuts; 3 Copying Formulas; Chapter 16: Tables and Charts; 1 The Basics of Tables; 2 Sorting and Filtering a Table; 3 Charting 101; Part III: PowerPoint 2007; Chapter 17: Creating a Basic Presentation; 1 What You Can Do with PowerPoint 2007; 2 What's New in PowerPoint 2007; 3 Beginning a New Presentation; 4 Choosing a Theme for Your Presentation; 5 Adding Text; 6 Adding More Slides; 7 Moving Around Inside a Presentation; Chapter 18: Editing Slides; 1 Editing Text; 2 Reversing an Action (Undo); 3 Finding and Replacing Text Automatically; 4 Checking Spelling; 5 Adding Special Characters; Chapter 19: Formatting and Aligning Your Text; 1 Automating Text Formatting; 2 Manually Formatting Text Appearance; 3 Manually Aligning and Indenting Text; 4 Formatting Text Boxes; Chapter 20: Formatting and Laying Out Your Slides; 1 Changing Slide Layout; 2 Changing Background Color; 3 Reapplying Themes, Colors, and Fonts; Chapter 21: Editing Your Slideshow; 1 Viewing Multiple Slides; 2 Adding, Deleting, and Moving Slides; 3 Inserting Slides from Other Slideshows; 4 Editing Slide and Layout Masters; 5 Adding Headers and Footers; Chapter 22: Adding Charts, Diagrams, and Tables; 1 Creating Charts; 2 Creating Diagrams; 3 Creating Tables; Chapter 23: Delivering Presentations; 1 Setting Up a Slideshow; 2 Slideshows for Multiple Audiences; 3 Presenting Your Slideshow; 4 Creating PowerPoint Shows; 5 Emailing Your Presentation; 6 Packaging Presentations for CD; Chapter 24: Printing Presentations; 1 Printing Slides (One Slide per Page); 2 Handouts (Multiple Slides per Page); 3 Overhead Transparencies; 4 Speaker Notes; 5 Presentation Outline; Chapter 25: Images and Transitions; 1 Drawing on Slides; 2 Adding Pictures from Other Programs; 3 Slide Transitions; Part IV: Access 2007; Chapter 26: Creating Your First Database; 1 What You Can Do with Access; 2 Understanding Access Databases; 3 Getting Started; 4 Saving and Opening Access Databases; 5 The Navigation Pane; Chapter 27: Building Smarter Tables; 1 Understanding Data Types; 2 Design View; 3 Access Data Types; 4 The Primary Key; 5 Six Principles of Database Design; Chapter 28: Mastering the Datasheet; 1 Datasheet Customization; 2 Datasheet Navigation; 3 Printing the Datasheet; Chapter 29: Blocking Bad Data; 1 Data Integrity Basics; 2 Input Masks; 3 Validation Rules; 4 Lookups; Chapter 30: Linking Tables with Relationships; 1 Relationship Basics; 2 Using a Relationship; Chapter 31: Queries: Reusable Searches; 1 Query Basics; 2 Creating Queries; 3 Understanding Action Queries; Chapter 32: Creating Reports; 1 Report Basics; 2 Printing, Previewing, and Exporting a Report; 3 Formatting a Report; 4 Filtering and Sorting a Report; Chapter 33: Creating Simple Forms; 1 Form Basics; 2 Sorting and Filtering in a Form; 3 The Form Wizard; Chapter 34: Importing and Exporting Data; 1 The Case for Importing and Exporting; 2 Using the Clipboard; 3 Import and Export Operations; Part V: Appendixes; Appendix A: Customizing the Quick Access Toolbar; 1 The Quick Access Toolbar; Appendix B: Getting Help; 1 Using Office 2007's Built-in Help; 2 Using Microsoft's Office Web Site; 3 Third-Party Web Sites; Colophon;