|
2007 Microsoft Office System Inside Out
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
CONTENTS:
Part 1: Getting Started
Chapter 1 Overview of the 2007 Microsoft Office System
Chapter 2 The 2007 Office System User Interface: What's Changed, What's the Same
Chapter 3 Managing Security and Privacy in the 2007 Office System
Part 2: Collaboration Essentials
Chapter 4 Collaborating and Sharing with Others
Chapter 5 Organizing and Finding Information in Microsoft Office OneNote
Chapter 6 Working as a Team in a Microsoft Office Groove Workspace
Chapter 7 Sharing and Communicating Using Microsoft Office Groove
Part 3: Word
Chapter 8 Mastering Page Setup and Pagination
Chapter 9 Outlining Documents for Clarity and Structure
Chapter 10 Advanced Layout and Formatting
Chapter 11 Revising Documents Using Markup Tools
Part 4: Excel
Chapter 12 How to Work a Worksheet and a Workbook
Chapter 13 Building Formulas
Chapter 14 Using Functions
Chapter 15 Analyzing Data with PivotTable Reports
Part 5: PowerPoint
Chapter 16 Introduction to PowerPoint 2007
Chapter 17 Working with Text
Chapter 18 Working with Objects, Diagrams, and Charts in PowerPoint 2007
Chapter 19 Collaborating and Sharing
Chapter 20 Working with External Data in PowerPoint 2007
Chapter 21 Setting Up and Presenting a Slide Show
Part 6: Outlook
Chapter 22 Introducing Outlook 2007
Chapter 23 Finding and Organizing Messages
Chapter 24 Securing Your System, Messages, and Identity
Chapter 25 Collaboration with Outlook and Windows SharePoint Services
Part 7: Access
Chapter 26 Exploring the New Look of Access 2007
Chapter 27 Creating Your Database and Tables
Chapter 28 Creating and Working with Simple Queries
Chapter 29 Building a Form
Chapter 30 Constructing a Report
Part 8: Microsoft Office Programming Primer
Chapter 31 VBA Primer
Chapter 32 Office Open XML Essentials
|