Synopses & Reviews
Dive into the essential features in Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007. This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle what’s new in your favorite Microsoft Office programs—and challenge yourself to new levels of mastery Expertly manage your inbox, contacts, and business information Master sophisticated document-layout and formatting techniques Build spreadsheets to help you perform complex calculations and data analysis Design databases, build data-collection forms, and manipulate data Learn advanced techniques for creating charts and reports Create dynamic slides using themes, custom slide layouts, and special effects Explore Office Groove 2007 and Windows SharePoint Services for powerful collaboration Configure security and privacy settings to help thwart worms, viruses, and malware Write macros using Microsoft Visual Basic for Applications and work with Office Open XML
CD includes: Fully searchable eBook—plus bonus chapters 30+ sample files—spreadsheets, databases, code, and XML Resources for customizing, configuring, and troubleshooting programs Links to demos, webcasts, training courses, and blogs Visual references for finding commands in the Microsoft Office Fluent user interface Online resources for InfoPath 2007, OneNote 2007, Project 2007, and Visio 2007 Windows Vista Product Guide eReference and other eBooks
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Synopsis
A comprehensive reference guide to Microsoft Office 2007 provides a host of timesaving tips, tricks, shortcuts, solutions, workarounds, and troubleshooting guidelines for Microsoft Access, Excel, Outlook, Word, PowerPoint, and other applications, exploring the new features and capabilities of Office 2007 and featuring a CD-ROM containing Microsoft Office 2007 tools, eBooks, source code, and more. Original. (Intermediate/Advanced)
Synopsis
Dive into the essential features in Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007. This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle what’s new in your favorite Microsoft Office programs—and challenge yourself to new levels of mastery!
- Expertly manage your inbox, contacts, and business information
- Master sophisticated document-layout and formatting techniques
- Build spreadsheets to help you perform complex calculations and data analysis
- Design databases, build data-collection forms, and manipulate data
- Learn advanced techniques for creating charts and reports
- Create dynamic slides using themes, custom slide layouts, and special effects
- Explore Office Groove 2007 and Windows SharePoint Services for powerful collaboration
- Configure security and privacy settings to help thwart worms, viruses, and malware
- Write macros using Microsoft Visual Basic for Applications and work with Office Open XML
CD includes:
- Fully searchable eBook—plus bonus chapters!
- 30+ sample files—spreadsheets, databases, code, and XML
- Resources for customizing, configuring, and troubleshooting programs
- Links to demos, webcasts, training courses, and blogs
- Visual references for finding commands in the Microsoft Office Fluent user interface
- Online resources for InfoPath 2007, OneNote 2007, Project 2007, and Visio 2007
- Windows Vista Product Guide eReference and other eBooks
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Synopsis
Get expert techniques and best practices for creating professional-looking documents, slide presentations, and spreadsheets -- and apply these skills with Microsoft Word, PowerPoint®, and Excel® in Office 2010 or Office for Mac 2011. This practical guide provides constructive advice and timesaving tips to help you produce compelling content that delivers. You'll work smarter, not harder!
- Plan and design presentations and reports that get your message across
- Determine the best ways to use templates and themes in Word, PowerPoint, and Excel
- Learn how to use tables and styles to make complex documents more presentable
- Make a lasting impression with professional-quality graphics and media
- Use proven tips and shortcuts to get more from slide masters and layouts
- Design PivotTables for more effective data analysis and reporting
- Customize your content with Microsoft Visual Basic® for Applications (VBA)
About the Author
Stephanie Krieger, Microsoft Office MVP, is a consultant, trainer, and author who specializes in developing custom enterprise solutions using Microsoft Office. She teaches clients how to build great documents easily by helping them understand how Microsoft Office applications “think.” Stephanie contributes regularly to websites on Microsoft.com.
Beth Melton has been a computer instructor and developer since 1995. Along with developing custom Microsoft Office solutions for a wide range of clients, and instructing computer classes for local area colleges, she writes regularly on the Microsoft Office applications for Web sites, including Microsoft Office Online, TechTrax Online Magazine, The Word MVP Site, and the Microsoft Knowledge Base. She is a co-author of Microsoft Office Word 2007 Inside Out. Beth has been a Microsoft Office MVP since 2000, and is also a Microsoft Office Specialist Master Instructor.
Table of Contents
Acknowledgments; About the CD; Whats on the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Chapter 1: Introduction; 1.1 Who This Book Is For; 1.2 How This Book Is Organized; Part 1: Getting Started; Chapter 1: Overview of the 2007 Microsoft Office System; 2.1 The New World of Work; 2.2 The New Microsoft Office User Interface; 2.3 The New Microsoft Office XML File Formats; 2.4 What Else Is New?; Chapter 2: The 2007 Office System User Interface: Whats Changed, Whats the Same; 3.1 A Quick Tour and Comparison; 3.2 The Ribbon and Command Tabs; 3.3 Customizing the Quick Access Toolbar; 3.4 The Microsoft Office Button and Menu; 3.5 Working in Context: More Tabs, Plus Some Menus and Toolbars; 3.6 Galleries and Live Preview; 3.7 Getting Help; Chapter 3: Managing Security and Privacy in the 2007 Office System; 4.1 Working in the Trust Center; 4.2 Setting Your Privacy Options; 4.3 Removing Hidden Data and Personal Information from Microsoft Office Documents; 4.4 Applying Information Rights Management; 4.5 Assigning a Password to a Document; 4.6 Avoiding Phishing Schemes; Part 2: Collaboration Essentials; Chapter 4: Collaborating and Sharing with Others; 5.1 Understanding and Using the 2007 Office System Collaboration Environments; 5.2 Creating and Using Shared Workspaces with Windows SharePoint Services; 5.3 Creating and Using Groove Workspaces; 5.4 Using Office OneNote 2007 as a Collaboration Tool; Chapter 5: Organizing and Finding Information in Microsoft Office OneNote; 6.1 Organizing a OneNote Notebook; 6.2 Adding Notes and Information to a Notebook; 6.3 Finding Your Information; 6.4 Using a Notebook on More Than One Computer; 6.5 Working as a Team with Office OneNote 2007; Chapter 6: Working as a Team in a Microsoft Office Groove Workspace; 7.1 Getting Started with Groove; 7.2 Setting Up a Groove Account; 7.3 The View from the Launchbar; 7.4 Groove Workspace Basics; 7.5 Outfitting a Groove Workspace with Tools; Chapter 7: Sharing and Communicating Using Microsoft Office Groove; 8.1 Setting Up and Using a File-Sharing Workspace; 8.2 Managing Groove Communications; 8.3 Working with Groove Contacts; 8.4 Introducing the Groove Forms Tool; 8.5 Managing Workspace Archives and Templates; Part 3: Word; Chapter 8: Mastering Page Setup and Pagination; 9.1 Basic Page Setup Options; 9.2 Changing Margins and Orientation; 9.3 Selecting a Paper Size and Source; 9.4 Controlling Page and Section Breaks; 9.5 Working with Varying Page Settings; 9.6 Including Headers and Footers; 9.7 Working with the Document Grid; 9.8 Adding and Controlling Line Numbers; Chapter 9: Outlining Documents for Clarity and Structure; 10.1 Outlining Enhancements in Word 2007; 10.2 Creative Outlining with Word 2007; 10.3 Eleven Reasons to Outline Your Next Complex Document; 10.4 Viewing a Document in Outline View; 10.5 Creating a New Outline; 10.6 Choosing Outline Display; 10.7 Working with Headings in Outline View; 10.8 Displaying Outline and Print Layout View at the Same Time; 10.9 Changing Your Outline; 10.10 Printing Your Outline; 10.11 Using the Document Map vs. Using Outline View; Chapter 10: Advanced Layout and Formatting; 11.1 Layout and Design Fundamentals; 11.2 Using Backgrounds and Watermarks; 11.3 Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames; 11.4 Configuring Word 2007 Layout Options; 11.5 Commanding Attention with Borders and Shading; 11.6 Adding a Simple Border; 11.7 Creating Enhanced Borders; 11.8 Creating Partial Borders; 11.9 Using a Page Border; 11.10 Adding Borders to Document Sections and Paragraphs; 11.11 Adjusting Border Spacing; 11.12 Inserting Graphical Horizontal Lines; 11.13 Adding Borders to Pictures; 11.14 Adding Table Borders; 11.15 Applying Shading Behind Content; Chapter 11: Revising Documents Using Markup Tools; 12.1 Benefits of an Organized Revision Process; 12.2 Familiarizing Yourself with Markup Tools; 12.3 Using the Highlight Tool; 12.4 Adding and Managing Comments Effectively; 12.5 Tracking Changes; 12.6 Comparing and Combining Documents; Part 4: Excel; Chapter 12: How to Work a Worksheet and a Workbook; 13.1 Moving Around Regions; 13.2 Understanding Selection; 13.3 Techniques for Entering Data; 13.4 Managing Worksheets; 13.5 Viewing Worksheets; 13.6 Protecting Worksheets; 13.7 Managing Multiple Workbooks; 13.8 Opening Multiple Windows for the Same Workbook; 13.9 Hiding and Protecting Workbooks; Chapter 13: Building Formulas; 14.1 Formula Fundamentals; 14.2 Using Functions: A Preview; 14.3 Working with Foooooormulas; 14.4 Worksheet Calculation; 14.5 Using Arrays; 14.6 Linking Workbooks; 14.7 Creating Conditional Tests; Chapter 14: Using Functions; 15.1 Using the Built-In Function Reference in Excel; 15.2 Exploring the Syntax of Functions; 15.3 Inserting Functions; 15.4 Understanding Mathematical Functions; 15.5 Understanding Text Functions; 15.6 Understanding Logical Functions; 15.7 Understanding Information Functions; 15.8 Understanding Lookup and Reference Functions; Chapter 15: Analyzing Data with PivotTable Reports; 16.1 Introducing PivotTables; 16.2 Creating a PivotTable; 16.3 Rearranging PivotTable Fields; 16.4 Refreshing a PivotTable; 16.5 Changing the Numeric Format of PivotTable Data; 16.6 Choosing Report Layout Options; 16.7 Formatting a PivotTable; 16.8 Displaying Totals and Subtotals; 16.9 Sorting PivotTable Fields; 16.10 Filtering PivotTable Fields; 16.11 Changing PivotTable Calculations; 16.12 Grouping and Ungrouping Data; 16.13 Displaying the Details Behind a Data Value; 16.14 Creating PivotCharts; Part 5: PowerPoint; Chapter 16: Introduction to PowerPoint 2007; 17.1 Command Locations; 17.2 Customizing Office PowerPoint 2007; 17.3 File Formats; 17.4 Formatting; 17.5 PowerPoint 2007 Views; 17.6 Themes; 17.7 Tables; 17.8 Custom Slide Layouts; 17.9 PowerPoint 2007 Slide Libraries; 17.10 Program Recovery; Chapter 17: Working with Text; 18.1 Adding a Text Box to a Slide; 18.2 Finding and Replacing Words or Phrases; 18.3 Creating and Saving Customized Theme Fonts; 18.4 Formatting with WordArt; 18.5 Adding Punch to Your Bulleted Lists; 18.6 Writing on Slides During a Presentation; 18.7 Using Headers and Footers; 18.8 Working with Proofing Tools; Chapter 18: Working with Objects, Diagrams, and Charts in PowerPoint 2007; 19.1 Working with Pictures; 19.2 Adding Clip Art; 19.3 Using SmartArt; 19.4 Adding Sounds; 19.5 Including Movies; 19.6 Playing with Animations; 19.7 Animating SmartArt Graphics; 19.8 Creating Charts and Diagrams; Chapter 19: Collaborating and Sharing; 20.1 Using Templates; 20.2 Working with Windows SharePoint Services; 20.3 Reviewing, Approving, and Tracking Changes; 20.4 Protecting Your Document; 20.5 Securing Your Presentation; 20.6 Using the Document Inspector; Chapter 20: Working with External Data in PowerPoint 2007; 21.1 Working with Earlier Versions of PowerPoint; 21.2 Working with Excel 2007; 21.3 Working with Access 2007; 21.4 Blocking and Unblocking External Content; 21.5 Using Trusted Locations; 21.6 Setting Up Security Alerts and Trusted Publishers; Chapter 21: Setting Up and Presenting a Slide Show; 22.1 Learning the Basics; 22.2 Creating Custom Slide Shows; 22.3 Adding Transitions; 22.4 Using Presenter View; 22.5 Working with Photo Albums; 22.6 Exploring Printing Options; Part 6: Outlook; Chapter 22: Introducing Outlook 2007; 23.1 A New Interface; 23.2 Instant Search; 23.3 Calendar Changes; 23.4 E-Mail Changes; 23.5 Color Categories; 23.6 Collaboration and Sharing Improvements; 23.7 Overview of Outlook 2007 Capabilities; 23.8 How Outlook Stores Data; 23.9 Understanding Messaging Protocols; 23.10 Security Provisions in Outlook; 23.11 Options for Starting Outlook; Chapter 23: Finding and Organizing Messages; 24.1 Finding and Organizing Messages with Search Folders; 24.2 Flagging and Monitoring Messages and Contacts; 24.3 Grouping Messages by Customizing the Folder View; 24.4 Filtering a View Using Categories; 24.5 Managing E-Mail Effectively; Chapter 24: Securing Your System, Messages, and Identity; 25.1 Configuring HTML Message Handling; 25.2 Protecting Messages with Digital Signatures; 25.3 Signing Messages; 25.4 Encrypting Messages; 25.5 Protecting Data with Information Rights Management; Chapter 25: Collaboration with Outlook and Windows SharePoint Services; 26.1 Understanding Windows SharePoint Services Collaboration; 26.2 Setting Up Alerts; 26.3 Working with Shared Documents; 26.4 Working with Shared Contacts; 26.5 Linking a Team Calendar to Outlook; 26.6 Configuring Alerts in Outlook; 26.7 Using Outlook to Work with SharePoint Libraries and Files; Part 7: Access; Chapter 26: Exploring the New Look of Access 2007; 27.1 Opening Access for the First Time; 27.2 Getting StartedA New Look for Access; 27.3 Understanding Content Security; 27.4 Understanding the New Ribbon Feature; 27.5 Understanding the New Navigation Pane; 27.6 Using the Single-Document vs. Multiple-Document Interface; 27.7 Modifying Global Settings via the Access Options Dialog Box; Chapter 27: Creating Your Database and Tables; 28.1 Creating a New Database; 28.2 Creating Your First Simple Table by Entering Data; 28.3 Creating a Table Using a Table Template; 28.4 Creating a Table in Design View; 28.5 Defining Fields; 28.6 Defining a Primary Key; 28.7 Defining a Table Validation Rule; 28.8 Understanding Other Table Properties; 28.9 Defining Relationships; 28.10 Adding Indexes; 28.11 Setting Table Design Options; 28.12 Creating a Default Template for New Databases; 28.13 Printing a Table Definition; 28.14 Database Limitations; Chapter 28: Creating and Working with Simple Queries; 29.1 Selecting Data from a Single Table; 29.2 Testing Validation Rule Changes; 29.3 Working in Query Datasheet View; Chapter 29: Building a Form; 30.1 Forms and Object-Oriented Programming; 30.2 Starting from ScratchA Simple Input Form; 30.3 Working with Quick Create Commands and the Form Wizard; 30.4 Simplifying Data Input with a Form; Chapter 30: Constructing a Report; 31.1 Starting from ScratchA Simple Report; 31.2 Using the Report Command; 31.3 Using the Report Wizard; 31.4 Building a Report in Layout View; Part 8: Microsoft Office Programming Primer; Chapter 31: VBA Primer; 32.1 When and Why to Use VBA; 32.2 Introduction to the VBA Language and Code Structure; 32.3 Understanding and Using the Visual Basic Editor; 32.4 Writing, Editing, and Sharing Simple Macros; 32.5 Using VBA to Save Time on Document Production and Troubleshooting; 32.6 Introduction to Using Events; 32.7 Creating UserForms (Dialog Boxes); 32.8 Next Steps for Working with Automation in Microsoft Office; Chapter 32: Office Open XML Essentials; 33.1 Chapter Assumptions; 33.2 XML Basics for Reading Your Documents; 33.3 Getting to Know the Office Open XML Formats; 33.4 Editing and Managing Documents Through XML; 33.5 Customizing the Ribbon; 33.6 Binding Data to Content Controls; 33.7 Next Steps for Working with the Office Open XML Formats; Appendix: Installing and Configuring the 2007 Office System; Installing the Microsoft Office System from the CD; Changing Your 2007 Office System Setup; Index to Troubleshooting Topics; About the Authors; Choose the Right Book for You;