Software

How to Use •        Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface •        Word: Create great-looking documents faster using themes, styles, and templates •        Excel: Use organizing, processing, and presenting tools to create data in Excel •        PowerPoint: Create powerful presentations faster using ready-made design templates and themes •        Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks •        Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer •        SharePoint: Collaborate and share documents and information •        Prepare for the Microsoft Certified Application Specialist exam •        Practice your new skills with the useful workshops inside   On the Web This book uses real-world examples to give you a context in which to use a task. This book also includes  workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Chapter 1    Getting Started with Office         1 Chapter 2    Using Shared Office Tools 33 Chapter 3    Adding Art to Office Documents 57 Chapter 4    Adding Shapes to Office Documents    93 Chapter 5    Formatting Office Documents    115 Chapter 6    Creating a Document with Word          131 Chapter 7    Formatting a Document with Word      153 Chapter 8    Enhancing a Document with Word       173 Chapter 9    Creating a Worksheet with Excel         211 Chapter 10  Building a Worksheet with Excel 239 Chapter 11  Designing a Worksheet with Excel        281 Chapter 12  Creating a Presentation with PowerPoint       305 Chapter 13  Delivering a Presentation with PowerPoint      343 Chapter 14  Creating a Database with Access         375 Chapter 15  Locating and Managing Data with Access       405 Chapter 16  Presenting Data with Access      423 Chapter 17  Communication with Outlook     447 Chapter 18  Managing Information with Outlook     489 Chapter 19  Creating a Publication with Publisher     519 Chapter 20  Designing a Publication with Publisher   537 Chapter 21  Publishing Office Documents on the Web       557 Chapter 22  Protecting and Securing Office Documents     575 Chapter 23  Reviewing and Sharing Office Documents       605 Chapter 24  Expanding Office Functionality    647 New Features        673 Microsoft Certified Applications Specialist       683

Microsoft Office Access 2007   For those who would rather be shown how than told how     See How To Create databases more efficiently using a new results-oriented interface Use tools for building a database that makes information easier to find and use Import data from other programs, HTML, XML files, and other databases Use forms, filters, queries, and reports to capture and analyze data Discover ways to prevent data corruption and unauthorized access Share your data with others through interactive web pages Put your newly acquired skills to work using the online workshops Organize information and add impact with clip art, SmartArt diagrams, tables, and charts Use Groove and SharePoint Team Services to collaborate and share documents and information Prepare for the Microsoft Certified Application Specialist (MCAS) exam     On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com   Author Bio Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Category Database Covers    Microsoft Office Access 2007 User Level    Beginning–Intermediate     1 Getting Started with Access 2 Touring Access Databases 3 Planning and Creating a Custom Database 4 Working with Fields 5 Working with Tables 6 Locating Specific Information Using a Query 7 Simplifying Data Entry with Forms 8 Creating Reports to Convey Information 9 Improving the Appearance of Forms and Reports 10 Working on the Web 11 Importing and Exporting Information 12 Managing a Database 13 Protecting and Securing a Database 14 Customizing Access 15 Enhancing a Database with Programming 16 Working Together on Office Documents New Features Microsoft Certified Applications Specialist Index

How to Use •        Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface •        Word: Create great-looking documents faster using themes, styles, and templates •        Excel: Use organizing, processing, and presenting tools to create data in Excel •        PowerPoint: Create powerful presentations faster using ready-made design templates and themes •        Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks •        Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer •        SharePoint: Collaborate and share documents and information •        Prepare for the Microsoft Certified Application Specialist exam •        Practice your new skills with the useful workshops inside   On the Web This book uses real-world examples to give you a context in which to use a task. This book also includes  workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Chapter 1    Getting Started with Office         1 Chapter 2    Using Shared Office Tools 33 Chapter 3    Adding Art to Office Documents 57 Chapter 4    Adding Shapes to Office Documents    93 Chapter 5    Formatting Office Documents    115 Chapter 6    Creating a Document with Word          131 Chapter 7    Formatting a Document with Word      153 Chapter 8    Enhancing a Document with Word       173 Chapter 9    Creating a Worksheet with Excel         211 Chapter 10  Building a Worksheet with Excel 239 Chapter 11  Designing a Worksheet with Excel        281 Chapter 12  Creating a Presentation with PowerPoint       305 Chapter 13  Delivering a Presentation with PowerPoint      343 Chapter 14  Creating a Database with Access         375 Chapter 15  Locating and Managing Data with Access       405 Chapter 16  Presenting Data with Access      423 Chapter 17  Communication with Outlook     447 Chapter 18  Managing Information with Outlook     489 Chapter 19  Creating a Publication with Publisher     519 Chapter 20  Designing a Publication with Publisher   537 Chapter 21  Publishing Office Documents on the Web       557 Chapter 22  Protecting and Securing Office Documents     575 Chapter 23  Reviewing and Sharing Office Documents       605 Chapter 24  Expanding Office Functionality    647 New Features        673 Microsoft Certified Applications Specialist       683

See How To   •    Create documents more efficiently using a new results-oriented interface •    Use formatting, editing, reviewing, and publishing tools to create documents in print and online •    Create great-looking documents faster using themes, styles, and templates •    Organize information and add impact with clip art, SmartArt diagrams, tables, and charts •    Create customized letters, labels, and envelopes •    Use the Full Reading view to comfortably read documents on screen •    Use the Outline and Draft views to develop your documents •    Use Groove and SharePoint Team Services to collaborate and share documents and information •    Prepare for the Microsoft Certified Applications Specialists exam   This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Word example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Introduction     xvii Chapter 1        Getting Started with Word      Chapter 2        Working with Simple Documents       Chapter 3        Formatting Documents           Chapter 4        Using Templates, Styles, and Themes          Chapter 5        Adding Graphics and Multimedia to Documents        Chapter 6        Adding Tables and Charts to Documents      Chapter 7        Creating Desktop Publishing Documents      Chapter 8        Working with Long Documents          Chapter 9        Working with Technical Documents  Chapter 10      Creating Mail Merge Documents        Chapter 11      Proofing and Printing Documents      Chapter 12      Publishing Documents on the Web    Chapter 13      Protecting and Securing Documents Chapter 14      Reviewing and Sharing Documents   Chapter 15      Sharing Information Between Programs        Chapter 16     Customizing Word    Chapter 17     Expanding Word Functionality         Chapter 18     Working Together on Office Documents    W        Workshops: Putting It All Together     New Features Microsoft Certified Applications Specialist      Index   

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.  All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.   FM Introduction I Getting Acquainted with Access 2007 1 Access 2007 for Access 200x Users: What’s New 2 Building Simple Tracking Applications 3 Navigating the New Access User Interface II Learning the Fundamentals of Access Databases 4 Exploring Relational Database Theory and Practice 5 Working with Access Databases and Tables 6 Entering, Editing, and Validating Access Table Data 7 Sorting, Finding, and Filtering Data 8 Linking, Importing, and Exporting Data III Transforming Data with Queries and PivotTables 9 Designing Queries for Access Databases 10 Understanding Access Operators and Expressions 11 Creating Multitable and Crosstab Queries 12 Working with PivotTable and PivotChart Views 13 Creating and Updating Access Tables with Action Queries IV Designing Forms and Reports 14 Creating and Using Basic Access Forms 15 Designing Custom Multitable Forms 16 Working with Simple Reports and Mailing Labels 17 Preparing Advanced Reports 18 Adding Graphs, PivotCharts, and PivotTables V Moving to Networked Multiuser Applications 19 Linking Access Front Ends to Access and Client/Server Tables 20 Exploring Access Data Projects and SQL Server 2005 21 Moving from Access Queries to Transact-SQL 22 Upsizing Access Applications to Access Data Projects VI Collaborating with Access Data 23 Importing and Exporting Web Pages 24 Integrating with XML and InfoPath 2007 25 Collaborating with Windows SharePoint Services VII Programming and Converting Access Applications 26 Automating Access Applications with Macros 2007 27 Learning Visual Basic for Applications 28 Handling Events with VBA and Macros 29 Programming Combo and List Boxes 30 Understanding Data Access Objects, OLE DB, and ADO 31 Upgrading 200X Applications to Access 2007 VIII Appendix A Glossary Index

Special Edition Using Microsoft Office Home and Student 2007 THE ONLY OFFICE BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Office 2007 proficiency and use of more advanced features. If you buy only one book on Office Home and Student 2007, Special Edition Using Microsoft Office Home and Student 2007 is the book you need. Office Home and Student 2007 is available to ANYONE, regardless of whether you are a student, a teacher, or neither. The only condition Microsoft attaches is the requirement that the software not be used for commercial purposes. For use in the home or classroom, Office Home and Student 2007 is an exceptional deal at a fraction of the cost of the business versions!    •     No other authoring team in the business is as well recognized and respected as the Office Dream Team; when they speak, even the Office development team at Microsoft listens!    •     This book is a category killer–one that sets the pace for others to follow!    •     Tired of Office books that read as though Microsoft employees wrote them? Tired of learning the Microsoft way? Tired of books containing little more than you can pull from the Help system? If you answered yes to any of these questions, then you owe it to yourself to get a copy of this book!    •     If you own a copy of Office Home and Student 2007, you deserve a copy of this book! Here, you’ll find a bevy of previously undocumented tips and tricks that will show you how to harness the power of Office 2007!    •     Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book “Another Special Edition Winner! Clear, concise and right on-target. Everything a student or a home user will need to know in order to master Office 2007.” –Alan & Sandra Ashendorf, Hosts of Let’s Talk Computers Radio Talk Show   Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press, ” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” You can read more of Ed’s writing at http://www.edbott.com/weblog. Curmudgeon, critic, and perennial “Office Victim, ” Woody Leonhard runs a fiercely independent website with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the neverending stream of Microsoft patches. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization. Category: Integrated Suites Covers: Microsoft Office Home and Student 2007 User Level: Beginner–Intermediate  

Microsoft Office Access 2007   For those who would rather be shown how than told how     See How To Create databases more efficiently using a new results-oriented interface Use tools for building a database that makes information easier to find and use Import data from other programs, HTML, XML files, and other databases Use forms, filters, queries, and reports to capture and analyze data Discover ways to prevent data corruption and unauthorized access Share your data with others through interactive web pages Put your newly acquired skills to work using the online workshops Organize information and add impact with clip art, SmartArt diagrams, tables, and charts Use Groove and SharePoint Team Services to collaborate and share documents and information Prepare for the Microsoft Certified Application Specialist (MCAS) exam     On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com   Author Bio Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Category Database Covers    Microsoft Office Access 2007 User Level    Beginning–Intermediate     1 Getting Started with Access 2 Touring Access Databases 3 Planning and Creating a Custom Database 4 Working with Fields 5 Working with Tables 6 Locating Specific Information Using a Query 7 Simplifying Data Entry with Forms 8 Creating Reports to Convey Information 9 Improving the Appearance of Forms and Reports 10 Working on the Web 11 Importing and Exporting Information 12 Managing a Database 13 Protecting and Securing a Database 14 Customizing Access 15 Enhancing a Database with Programming 16 Working Together on Office Documents New Features Microsoft Certified Applications Specialist Index

“Everything you need to master Access 2007 forms, reports, and queries.” –Charles Carr, Reviews Editor, ComputorEdge Magazine   Create Forms for Business Ensure Data Entry Accuracy Build Elegant Form Interfaces Collect Data Via Email Design Effective Business Reports Make an Invoice Report Create Mailing Labels Extract Data Work with Multiple Tables Calculate Discounts Analyze Data   Develop your Microsoft Access expertise instantly with proven techniques   Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database.  Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.   This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power. ·        Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries. ·        Avoids database theory in favor of practical know-how that you can put to use right away. ·        Packed full of real-world examples and techniques to help you learn and understand the importance of each section. ·        Covers what’s new and changed in Microsoft Access 2007.   Introduction Part I: Creating Forms Chapter 1         Creating and Using a Form Chapter 2         Working with Form Controls Chapter 3         Designing Forms for Efficient and Accurate Data Entry Chapter 4         Designing Forms for Business Use Chapter 5         Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6         Creating and Publishing a Report Chapter 7         Designing Effective Business Reports Chapter 8         Designing Advanced Reports Chapter 9         Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10       Creating a Basic Query Chapter 11       Building Criteria Expressions Chapter 12       Working with Multiple-Table Queries Chapter 13       Creating Advanced Queries Chapter 14       Creating PivotTable Queries Chapter 15       Querying with SQL Statements Index

“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise   Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity.   Practical, real-world examples for anyone who uses Office applications—not just power users. Automate or streamline all your repetitive Word, Excel, and PowerPoint chores. Create custom dialog boxes and custom Ribbon tabs, groups, and buttons to make Office look and work the way you want it to—no program experience required! Easy-to-understand instructions that make learning VBA fast and fun. All code examples and documents are available online so you can get started with VBA with a minimum of fuss.   Automate Routine Tasks Control Word, Excel, and PowerPoint Program Access Databases Automate Document Backups Create Advanced Email Rules Build Custom Dialog Boxes Customize the Office 2007 Ribbon Access the Registry Troubleshoot Macro Problems Control Macro Security   Introduction  I Getting Started with VBA 1 Creating and Running Recorded Macros  2 Writing Your Own Macros  3 Understanding Program Variables  4 Building VBA Expressions  5 Working with Objects  6 Controlling Your VBA Code  II Putting VBA to Work 7 Programming Word  8 Programming Excel  9 Programming PowerPoint  10 Programming Access Databases  11 Programming Outlook Email  III Getting the Most Out of VBA 12 Creating Custom VBA Dialog Boxes  13 Customizing the Office 2007 Ribbon  14 VBA Tips and Techniques  15 Trapping Program Errors  16 Debugging VBA Procedures  IV Appendixes A VBA Statements  B VBA Functions  Index  

Special Edition Using Microsoft® Office Project2007   We crafted this book to grow with you, providing the reference material you need as you move toward Project proficiency and use of more advanced features. If you buy only one book on Project 2007, Special Edition Using Microsoft® Office Project2007 is the only book you need.   THEONLYDESKTOPPROJECTBOOK YOUNEED   • Leverage Microsoft Project 2007 to support your management processes, communication and collaboration within your organization • Manage your project through initiation, tracking, controlling, performance measuring , and closing • Model real life project scenarios with the scheduling engine • Define tasks, milestones, summary tasks, and recurring tasks to create your project schedule • Create task relationships, constraints, and perform advanced actions on tasks • Customize the project to fit your needs • Use views, tables, filters, and groups to review your project and application interface schedule • Manipulate Microsoft Project 2007 data using other Microsoft Office applications • Implement Visual Reports to allow 3D models of project data for sharing and analysis • Master advanced features with built-in and advanced manual techniques   “Special Edition Using Microsoft Office Project 2007 continues the great QUE tradition of bringing together all of the features and capabilities of our software in a logical, easy-to-follow manner. With the knowledge and experience that QuantumPM, LLC brings to the domain of project management and to the use of Microsoft® Office Project 2007, this book should be on every desktop!” –Mike Angiulo, General Manager, Microsoft’s Office Project Business Unit   QuantumPM, LLC is a project, program, and portfolio management product and services firm that helps its clients create pragmatic and valuable solutions to address real world problems. The company combines state-of-the-art tools from Microsoft and other technology leaders, its own expertise, and industry best practices to create solutions that support the way their customers work. QuantumPM services include Management Consulting, Technical Consulting, Training, Hosting Services, Earned Value Management, and Business Intelligence solutions. This book is a culmination of many experiences, people, and industries that together make up QuantumPM, LLC. It includes many insights into Microsoft Office Project 2007 from the experts who have used this tool in the field for many years.   Introduction I Getting Started with Microsoft Project 2007 1 Power of Microsoft Project 2007 2 Microsoft Project 2007 Quick Start 3 Microsoft Project and the Project Management Domain II Organizing for Success–Project Initiation and Planning 4 Getting Started After Business Initiative Is Approved 5 Setting Up Project for Your Use 6 Creating Your Project Schedule 7 Defining Task Logic 8 Defining Project Resources 9 Understanding Work Formula Basics 10 Scheduling Single and Multiple Resource Assignments 11 Using Standard Views, Tables, Filters, and Groups to Review Your Schedule 12 Performing a Schedule Reality Check III Project Execution Through Completion 13 Tracking Your Project Progress 14 Analyzing Performance 15 Using Reports for Tracking and Control 16 Revising the Schedule 17 Closing the Project IV Tailoring Microsoft Office Project 2007 to Your Needs 18 Managing Project Files 19 Formatting Views 20 Creating and Customizing the Basic Reports 21 Creating and Customizing Visual Reports 22 Customizing Views, Tables, Filters, Groups, and Fields 23 Customizing Toolbars, Menus, and Forms V Microsoft Office Project 2007 Knowledge In Depth 24 Working with Multiple Projects 25 Resolving Resource Allocation Problems 26 Exporting and Importing Project Data 27 Manipulating Data Using Other Applications Index  

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...” —Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http://www.twduff.com   Develop your Microsoft Excel expertise instantly with proven techniques Master Excel Ranges Create Powerful Arrays Troubleshoot Formula Problems Validate Worksheet Data Perform What-If Analysis Model Your Business Track Trends and Make Forecasts Analyze Data Find Optimal Solutions Build Dynamic Loan Schedules  Most Microsoft® Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon. Sound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book.  Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way.  This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.        •    Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.      •    Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.      •    Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.   Introduction 1    Getting the Most Out of Ranges2    Using Range Names 3    Building Basic Formulas 4    Creating Advanced Formulas 5    Troubleshooting Formulas II    Harnessing the Power of Functions    6    Understanding Functions 7    Working with Text Functions 8    Working with Logical and Information Functions 9    Working with Lookup Functions 10  Working with Date and Time Functions 11  Working with Math Functions 12  Working with Statistical Functions III    Building Business Models    13  Analyzing Data with Tables14  Analyzing Data with PivotTables15  Using Excel’s Business-Modeling Tools 16  Using Regression to Track Trends and Make Forecasts 17  Solving Complex Problems with SolverIV    Building Financial Formulas    18   Building Loan Formulas19   Building Investment Formulas 20   Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).   Category  Office Productivity Suite Covers    Microsoft Office Excel 2007 User Level         Intermediate - Advanced  

<>It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.   “More than a how-to and reference, this book also provides the why-tos and when-tos, with serious consideration given to layout best practices and design possibilities–a very well-rounded resource.” –Kathy Villella, CEO, PowerFrameworks.com Implementing 1-Click Charting Incorporating Drag & Drop and Dynamic Charts Creating Amazing Effects Using Charting Templates and Macros Mastering Glow, Shadow, Sparklines, Dashboards, and More Eliminating Chart Junk Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts Develop your Charting expertise instantly with proven techniques After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to make it look great.   This book shows you how to coax Excel to create many charts you might not have believed were possible. You’ll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You’ll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart–without any limitations. You’ll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data bars–or even the decades-old REPT function!   In no time, this book will have you creating charts that wow your audience and effectively communicate your message. Master effective visual display of data Choose the right chart type to convey your message Learn time-saving workarounds Create charts that most people think you can’t create with Excel Understand what a Radar chart is and when you might use it Summarize a million rows of data in a single pivot table chart Present data graphically without charts Employ SmartArt graphics to show process or relationship charts Utilize VBA to create charts Put your data on a map Export your charts to the web or PowerPoint Detect chart liesABOUT THE AUTHOR Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.   Introduction 1 Introducing Charts in Excel 2007 2 Customizing Charts 3 Creating Charts That Show Trends 4 Creating Charts That Show Differences 5 Creating Charts That Show Relationships 6 Creating Stock Analysis Charts 7 Advanced Chart Techniqu

Microsoft Office Accounting Express 2007 Starter Kit Set up Microsoft® Office Accounting Express 2007 quickly and painlessly!   Microsoft Office Accounting Express 2007 will help you improve the way you manage your finances by reducing the time spent accounting for eBay sales and PayPal receipts, taking the worry out of payroll filing with ADP Payroll, and improving your bottom line by using Equifax credit profiles. Microsoft® Office Accounting Express 2007 Starter Kit provides clear and easy instructions on using Microsoft Office Accounting Express 2007 for all your daily business transactions–from invoicing to check writing. Introduction Chapter 1 A Microsoft Accounting Products Comparison Chapter 2 Downloading and Installing Chapter 3 Registration and Setup Wizard Chapter 4 Importing Data Chapter 5 Company Setup Chapter 6 Basic Accounting Transactions Chapter 7 Accounting Reports Chapter 8 End of Period Chapter 9 Advanced Features Appendix A Troubleshooting Glossary   Author Bio Pamela Pierce is certified through Microsoft Professional Accountants’ Network (MPAN) in Microsoft Small Business Accounting. She has been interviewed for articles on Microsoft Accounting 2007 in magazines such as Accounting Technology and Accounting Today. She is the owner of Empowering You!, a company that has been transforming businesses through technology since 1993. She is a college instructor in PC repair  and maintenance and was one of the first Microsoft Partners and Microsoft Certified Solution Developers. www.quepublishing.com CD Info The full version of Microsoft Office Accounting Express 2007 is included on the accompanying CD! You’re ready to start setting up and managing your accounting processes the minute you open the Starter Kit. ·         Shows how to use Microsoft Office Accounting Express 2007 with other Microsoft Office products, including Word, Excel, Access, and Outlook Business Contact Manager. ·         Provides clear and easy instructions on invoicing, deposits, check writing, and much more. ·         Shows how to customize forms and reports to fit your unique business. ·         Provides valuable setup tips. Set it up right, and you’ll love it! Set it up incorrectly, and you’ll have problems from the start. ·         Explains the import process from Intuit QuickBooks, Microsoft Money, and Microsoft Excel. ·         Includes a chapter on troubleshooting, plus many insider tips, notes, and cautions throughout all chapters. ·         Shows you how to use the Internet to move transactions into and out of Microsoft Office Accounting Express 2007. Category  Business Finance Covers  Microsoft Office Accounting Express User Level  Beginning–Intermediate  

Business Solutions   Microsoft® Office Access 2007 VBA   Develop your Access 2007 VBA expertise instantly with proven techniques   Microsoft Office Access 2007 VBA builds on the skills you’ve already developed in creating database applications and helps you take them to the next level—using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming language. Even if you’ve never programmed, this book will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before. Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access frequently in their daily work. You have serious work to get done and you can’t spend all day reading a computer book. This book teaches you the essential skills you need to automate your databases as quickly as possible. Although written for Access 2007, the techniques and concepts covered will work in most versions of Microsoft Access.   Highlights of This Book Include           •        Navigating within the Visual Basic Editor           •        Using variables, constants, and data types           •        Employing built-in functions           •        Creating procedures           •        Understanding object-and event-driven coding           •        Working with arrays           •        Understanding scope           •        Working with forms           •        Using selection controls           •        Creating reports           •        Exploring menus, navigation, and ribbons           •        Using object models           •        Working with data           •        Defining database schema           •        Using the Windows API           •        Working with XML files           •        Exploring Access SQL   On the Website Download database files used in the book at www.quepublishing.com.   Category     Office Applications Covers         Visual Basic for Applications  User Level    Intermediate - Advanced   Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20+ years, he has designed databases on a wide range of platforms, including dBASE, FoxPro, SQL/DS, Lotus Approach, Lotus Notes, and, for the past 10 years, Microsoft Access. Scott has worked as a consultant, both in-house and freelance, and as a support professional at firms that are among the leaders in their industries. Scott spends some of his free time answering questions at the premier site for Access support: http://www.utteraccess.com.   Brent Spaulding started writing applications about 20 years ago and has utilized Microsoft Access since version 2.0. He looks forward to using Access well into the future. In July 2007, he received the Microsoft MVP award for Access, which recognizes his talent and contributions to the Access community.   Front cover bullets: Edit and debug your code Use looping and conditional statements Understand the Access object- and event-driven architecture Automate data entry Learn how to use variables for dynamic automation Create user-friendly applications for others Create custom functions and objects Customize the user interface Manipulate data and objects with code

See How To   •    Create documents more efficiently using a new results-oriented interface •    Use formatting, editing, reviewing, and publishing tools to create documents in print and online •    Create great-looking documents faster using themes, styles, and templates •    Organize information and add impact with clip art, SmartArt diagrams, tables, and charts •    Create customized letters, labels, and envelopes •    Use the Full Reading view to comfortably read documents on screen •    Use the Outline and Draft views to develop your documents •    Use Groove and SharePoint Team Services to collaborate and share documents and information •    Prepare for the Microsoft Certified Applications Specialists exam   This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Word example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Introduction     xvii Chapter 1        Getting Started with Word      Chapter 2        Working with Simple Documents       Chapter 3        Formatting Documents           Chapter 4        Using Templates, Styles, and Themes          Chapter 5        Adding Graphics and Multimedia to Documents        Chapter 6        Adding Tables and Charts to Documents      Chapter 7        Creating Desktop Publishing Documents      Chapter 8        Working with Long Documents          Chapter 9        Working with Technical Documents  Chapter 10      Creating Mail Merge Documents        Chapter 11      Proofing and Printing Documents      Chapter 12      Publishing Documents on the Web    Chapter 13      Protecting and Securing Documents Chapter 14      Reviewing and Sharing Documents   Chapter 15      Sharing Information Between Programs        Chapter 16     Customizing Word    Chapter 17     Expanding Word Functionality         Chapter 18     Working Together on Office Documents    W        Workshops: Putting It All Together     New Features Microsoft Certified Applications Specialist      Index   

Microsoft Office PowerPoint 2007 Complete Makeover Kit This book is not as much about reading as it is about seeing and doing! That’s why we call it a kit. Full-color pages show you exactly how your slides will look as you follow the makeover steps, and all presentations in various stages of the makeover are on the accompanying CD. Each of the eight makeovers has been carefully chosen so it’s relevant to anyone who has ever used PowerPoint. And if you just upgraded to PowerPoint 2007, this book gives you a great introduction to the new version of the program, along with ample experience in using all the new features. There’s no better way of getting up to speed with PowerPoint 2007.             •        Learn the tricks used by the creators of award-winning presentations           •        Every makeover includes step-by-step instructions that are illustrated in full color           •        Separate chapters dedicated to the PowerPoint 2007 interface and galleries           •        Explore everything from choosing appropriate colors to visually representing data           •        Perfect presentations by incorporating high-impact animation and multimedia elements                ON THE CD           •        All sample presentations, plus all the files you need to do the makeovers           •        Royalty free pictures           •        Music tracks           •        Templates and Themes    

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.  All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.   FM Introduction I Getting Acquainted with Access 2007 1 Access 2007 for Access 200x Users: What’s New 2 Building Simple Tracking Applications 3 Navigating the New Access User Interface II Learning the Fundamentals of Access Databases 4 Exploring Relational Database Theory and Practice 5 Working with Access Databases and Tables 6 Entering, Editing, and Validating Access Table Data 7 Sorting, Finding, and Filtering Data 8 Linking, Importing, and Exporting Data III Transforming Data with Queries and PivotTables 9 Designing Queries for Access Databases 10 Understanding Access Operators and Expressions 11 Creating Multitable and Crosstab Queries 12 Working with PivotTable and PivotChart Views 13 Creating and Updating Access Tables with Action Queries IV Designing Forms and Reports 14 Creating and Using Basic Access Forms 15 Designing Custom Multitable Forms 16 Working with Simple Reports and Mailing Labels 17 Preparing Advanced Reports 18 Adding Graphs, PivotCharts, and PivotTables V Moving to Networked Multiuser Applications 19 Linking Access Front Ends to Access and Client/Server Tables 20 Exploring Access Data Projects and SQL Server 2005 21 Moving from Access Queries to Transact-SQL 22 Upsizing Access Applications to Access Data Projects VI Collaborating with Access Data 23 Importing and Exporting Web Pages 24 Integrating with XML and InfoPath 2007 25 Collaborating with Windows SharePoint Services VII Programming and Converting Access Applications 26 Automating Access Applications with Macros 2007 27 Learning Visual Basic for Applications 28 Handling Events with VBA and Macros 29 Programming Combo and List Boxes 30 Understanding Data Access Objects, OLE DB, and ADO 31 Upgrading 200X Applications to Access 2007 VIII Appendix A Glossary Index

MCAS Exam Prep Microsoft Certified Application Specialist Exams for Microsoft® Office 2007   Word 77-601 Excel 77-602 PowerPoint 77-603 Outlook 77-604 Access 77-605   Ron Gilster   CD Features Five Practice Exams   Score Higher on the MCAS Exams!   We provide you with the proven study tools and expert insight that will help you score higher on your exams.   Clear and simple explanations, lists, and screen shots walk you through the Microsoft Office processes you need to know to score well on the MCAS exams. Study strategies, challenges, and key terms focus your study so you can maximize your preparation time. Comprehensive discussion of all subject areas covered on the MCAS exams. Practice Questions that include detailed explanations of correct and incorrect answers—so you can learn the material from your success and mistakes.   This book covers all the skills measured by the MCAS Exams for Microsoft Office 2007, including Creating, customizing, formatting, and organizing Word documents Working with visual content, references, and document review processes Creating, manipulating, and formatting data and other content in Microsoft Excel Presenting Excel data visually with charts and illustrations Sharing and securing Microsoft Office content Creating, formatting, and delivering PowerPoint presentations Managing messaging, scheduling, and tasks with Microsoft Outlook Working with Outlook contacts and personal contact information Structuring, presenting, managing, and maintaining Access databases Building and modifying Access queries   CD Features Five Practice Exams The CD includes five practice exams so you can drill and practice—another effective Exam Prep study tool that helps you assess your readiness for the MCAS Exams for Microsoft Office 2007 (Word, Excel, PowerPoint, Outlook, and Access).   informit.com/examcram ISBN-13: 978-0-7897-3774-8 ISBN-10: 0-7897-3774-4

Special Edition Using Microsoft Office Home and Student 2007 THE ONLY OFFICE BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Office 2007 proficiency and use of more advanced features. If you buy only one book on Office Home and Student 2007, Special Edition Using Microsoft Office Home and Student 2007 is the book you need. Office Home and Student 2007 is available to ANYONE, regardless of whether you are a student, a teacher, or neither. The only condition Microsoft attaches is the requirement that the software not be used for commercial purposes. For use in the home or classroom, Office Home and Student 2007 is an exceptional deal at a fraction of the cost of the business versions!    •     No other authoring team in the business is as well recognized and respected as the Office Dream Team; when they speak, even the Office development team at Microsoft listens!    •     This book is a category killer–one that sets the pace for others to follow!    •     Tired of Office books that read as though Microsoft employees wrote them? Tired of learning the Microsoft way? Tired of books containing little more than you can pull from the Help system? If you answered yes to any of these questions, then you owe it to yourself to get a copy of this book!    •     If you own a copy of Office Home and Student 2007, you deserve a copy of this book! Here, you’ll find a bevy of previously undocumented tips and tricks that will show you how to harness the power of Office 2007!    •     Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book “Another Special Edition Winner! Clear, concise and right on-target. Everything a student or a home user will need to know in order to master Office 2007.” –Alan & Sandra Ashendorf, Hosts of Let’s Talk Computers Radio Talk Show   Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press, ” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” You can read more of Ed’s writing at http://www.edbott.com/weblog. Curmudgeon, critic, and perennial “Office Victim, ” Woody Leonhard runs a fiercely independent website with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the neverending stream of Microsoft patches. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization. Category: Integrated Suites Covers: Microsoft Office Home and Student 2007 User Level: Beginner–Intermediate  

Microsoft® Office Access 2007 Live Lessons   Mastering the Smartest, Fastest Ways to Use Access 2007   Alison Balter   DVD includes: . 6+ HOURS OF VIDEO INSTRUCTION . OVER 80 TIPS & TECHNIQUES . SKILLS YOU CAN LEARN IN FIVE MINUTES OR LESS   You’ve got Microsoft Office Access 2007...now get the most out of it, faster and more easily than ever before! In more than 80 quick video lessons, Alison Balter shows you all you need to maximize your productivity with Access 2007’s best new tools and shortcuts and its brand-new ribbon interface!   Microsoft Office Access 2007 teaches Access 2007’s most sophisticated features and techniques visually: just watch! You’ll master high-powered Office Access 2007 skills at your own pace—and get specific answers and solutions immediately, whenever you need them!   These practical videos show you how to make the most of Access 2007 tables, forms, reports, security, macros, even replication! You’ll discover power techniques for improving performance… supercharging your queries… creating smarter reports… publishing Access data to the Web… administering, repairing, and documenting databases… and plenty more!   For anyone who wants to master Access 2007 fast—especially upgraders from previous versions and professionals who want to analyze their own data!   Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts. LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes! Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your instructor shows exactly how to get great results in your real-world environment.   World-renowned Access expert Alison Balter presents easy, practical video introductions to Access 2007’s most powerful enhancements: everything from the Quick Access Toolbar to new Split Forms, Views, and Attachment Data Types! Click play to follow along as Alison walks you through using Access 2007’s most important new features…all you need to do is watch!   Alison Balter, founder and President of InfoTechnology Partners, Inc., has been programming, teaching, and writing about Access for more than 12 years. She has authored or coauthored 13 books on Access and speaks regularly on Access at conferences worldwide. Her clients have included Shell Oil, the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer’s Guild.   Databases  

This is the only book that will help an intermediate PowerPoint user improve their skills to an advanced level. In doing so, they can benefit both professionally and personally. This is not a comprehensive book that will bore you with every detail of PowerPoint, but a guide to specific actions you can take to create the ultimate presentation. The book covers the powerful formatting engine new to PowerPoint 2007, and how it can be used for applying soft shadows, reflection, and glows to make a presentation look attractive. It also covers PowerPoint's new 3D engine. The book goes into deep technical detail about the Office 2007 theme engine and how color schemes, effect schemes, and font schemes work; as well as the new PowerPoint XML file format, showing you how to edit PowerPoint files without using PowerPoint at all. The authors walk through programming a macro and explain how to format shapes, diagrams, charts, text, tables with gradient and picture fills and different kinds of lines (e.g. a beveled compound line with a diamond arrowhead). Also covered are those all important slide show shortcuts that few people know about like -- seeing your private notes while presenting on a projector, starting the slide show from the current slide without fumbling through the user interface, and how to black out the slide show screen with one key press.

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems.   Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours.   Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability; quickly create analysis comparing sales this period to last period by product or region or both; easily summarize daily transactional data by month or quarter or year in a few mouse clicks–all without knowing any formulas!   By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks.   • Take advantage of the numerous pivot table recipes • Create powerful summary reports in seconds • Build ad-hoc query tools with ease • Enhance your Executive Reporting • Filter reports to top 10 customers or products • Add dynamic charts to reports • Quickly summarize daily data by month, quarter, or year         Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1              Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 2              Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21 3              Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45 4              Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83 5              Performing Calculations Within Your Pivot Tables . . . . . . . . 117 6              Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141 7              Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167 8              Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189 9              Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201 10           Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215 11           Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231 12           Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291 A             Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315

&>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 Gurus will 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 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).    

“Everything you need to master Access 2007 forms, reports, and queries.” –Charles Carr, Reviews Editor, ComputorEdge Magazine   Create Forms for Business Ensure Data Entry Accuracy Build Elegant Form Interfaces Collect Data Via Email Design Effective Business Reports Make an Invoice Report Create Mailing Labels Extract Data Work with Multiple Tables Calculate Discounts Analyze Data   Develop your Microsoft Access expertise instantly with proven techniques   Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database.  Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.   This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power. ·        Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries. ·        Avoids database theory in favor of practical know-how that you can put to use right away. ·        Packed full of real-world examples and techniques to help you learn and understand the importance of each section. ·        Covers what’s new and changed in Microsoft Access 2007.   Introduction Part I: Creating Forms Chapter 1         Creating and Using a Form Chapter 2         Working with Form Controls Chapter 3         Designing Forms for Efficient and Accurate Data Entry Chapter 4         Designing Forms for Business Use Chapter 5         Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6         Creating and Publishing a Report Chapter 7         Designing Effective Business Reports Chapter 8         Designing Advanced Reports Chapter 9         Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10       Creating a Basic Query Chapter 11       Building Criteria Expressions Chapter 12       Working with Multiple-Table Queries Chapter 13       Creating Advanced Queries Chapter 14       Creating PivotTable Queries Chapter 15       Querying with SQL Statements Index

“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise   Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity.   Practical, real-world examples for anyone who uses Office applications—not just power users. Automate or streamline all your repetitive Word, Excel, and PowerPoint chores. Create custom dialog boxes and custom Ribbon tabs, groups, and buttons to make Office look and work the way you want it to—no program experience required! Easy-to-understand instructions that make learning VBA fast and fun. All code examples and documents are available online so you can get started with VBA with a minimum of fuss.   Automate Routine Tasks Control Word, Excel, and PowerPoint Program Access Databases Automate Document Backups Create Advanced Email Rules Build Custom Dialog Boxes Customize the Office 2007 Ribbon Access the Registry Troubleshoot Macro Problems Control Macro Security   Introduction  I Getting Started with VBA 1 Creating and Running Recorded Macros  2 Writing Your Own Macros  3 Understanding Program Variables  4 Building VBA Expressions  5 Working with Objects  6 Controlling Your VBA Code  II Putting VBA to Work 7 Programming Word  8 Programming Excel  9 Programming PowerPoint  10 Programming Access Databases  11 Programming Outlook Email  III Getting the Most Out of VBA 12 Creating Custom VBA Dialog Boxes  13 Customizing the Office 2007 Ribbon  14 VBA Tips and Techniques  15 Trapping Program Errors  16 Debugging VBA Procedures  IV Appendixes A VBA Statements  B VBA Functions  Index  

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...” —Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http://www.twduff.com   Develop your Microsoft Excel expertise instantly with proven techniques Master Excel Ranges Create Powerful Arrays Troubleshoot Formula Problems Validate Worksheet Data Perform What-If Analysis Model Your Business Track Trends and Make Forecasts Analyze Data Find Optimal Solutions Build Dynamic Loan Schedules  Most Microsoft® Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon. Sound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book.  Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way.  This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.        •    Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.      •    Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.      •    Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.   Introduction 1    Getting the Most Out of Ranges2    Using Range Names 3    Building Basic Formulas 4    Creating Advanced Formulas 5    Troubleshooting Formulas II    Harnessing the Power of Functions    6    Understanding Functions 7    Working with Text Functions 8    Working with Logical and Information Functions 9    Working with Lookup Functions 10  Working with Date and Time Functions 11  Working with Math Functions 12  Working with Statistical Functions III    Building Business Models    13  Analyzing Data with Tables14  Analyzing Data with PivotTables15  Using Excel’s Business-Modeling Tools 16  Using Regression to Track Trends and Make Forecasts 17  Solving Complex Problems with SolverIV    Building Financial Formulas    18   Building Loan Formulas19   Building Investment Formulas 20   Building Discount Formulas Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).   Category  Office Productivity Suite Covers    Microsoft Office Excel 2007 User Level         Intermediate - Advanced  

<>It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.   “More than a how-to and reference, this book also provides the why-tos and when-tos, with serious consideration given to layout best practices and design possibilities–a very well-rounded resource.” –Kathy Villella, CEO, PowerFrameworks.com Implementing 1-Click Charting Incorporating Drag & Drop and Dynamic Charts Creating Amazing Effects Using Charting Templates and Macros Mastering Glow, Shadow, Sparklines, Dashboards, and More Eliminating Chart Junk Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts Develop your Charting expertise instantly with proven techniques After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to make it look great.   This book shows you how to coax Excel to create many charts you might not have believed were possible. You’ll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You’ll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart–without any limitations. You’ll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data bars–or even the decades-old REPT function!   In no time, this book will have you creating charts that wow your audience and effectively communicate your message. Master effective visual display of data Choose the right chart type to convey your message Learn time-saving workarounds Create charts that most people think you can’t create with Excel Understand what a Radar chart is and when you might use it Summarize a million rows of data in a single pivot table chart Present data graphically without charts Employ SmartArt graphics to show process or relationship charts Utilize VBA to create charts Put your data on a map Export your charts to the web or PowerPoint Detect chart liesABOUT THE AUTHOR Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.   Introduction 1 Introducing Charts in Excel 2007 2 Customizing Charts 3 Creating Charts That Show Trends 4 Creating Charts That Show Differences 5 Creating Charts That Show Relationships 6 Creating Stock Analysis Charts 7 Advanced Chart Techniqu

How to Use •        Create powerful presentations faster using ready-made templates and Smart Tags •        Organize information and add impact with clip art, SmartArt diagrams, tables, and charts •        Make your presentation come alive with custom animations •        Add narration, animation, 3-D effects, and movie •        Add comments and e-mail your presentation to others for review and collaboration •        Deliver your presentation in a meeting room on multiple screens •        Use Groove and SharePoint Team Services to collaborate and share documents and information •        Prepare for the Microsoft Certified Application Specialist exam. •        Practice your new skills with the useful workshops inside   On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes  workshops to help you put together individual tasks into projects. The PowerPoint example files that you need for project tasks are available at www.perspection.com.   Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.     Chapter 1    Getting Started with PowerPoint          1 Chapter 2    Developing Presentation Content         31 Chapter 3    Designing a Look    73 Chapter 4    Drawing and Modifying Shapes   105 Chapter 5    Inserting Pictures and Multimedia         151 Chapter 6    Inserting Charts and Related Material   189 Chapter 7    Creating a Web Presentation      243 Chapter 8    Finalizing a Presentation and Its Supplements          267 Chapter 9    Preparing a Slide Show     299 Chapter 10  Starting a Slide Show       321 Chapter 11  Reviewing and Securing a Presentation          335 Chapter 12  Working Together on Office Documents        363 Chapter 13  Customizing the Way You Work 391 Chapter 14  Expanding PowerPoint Functionality     401 W       Workshops: Putting It All Together      425 New Features        439 Microsoft Certified Applications Specialist       444

You’ve got Microsoft Office 2007...now get the most out of it, faster and more easily than ever before! In 50 quick video lessons, J. Peter Bruzzese shows you all you need to maximize your productivity with Office 2007’s best tools and shortcuts, and its brand-new ribbon interface! Microsoft Office 2007 teaches Office 2007’s most sophisticated features and techniques visually: just watch! You’ll master high-powered Office 2007 skills at your own pace--and get specific answers and solutions immediately, whenever you need them! These practical videos simplify powerful Office 2007 features like Word mail merges, blog editing, and document encryption...Excel PivotTables, conditional formatting, and automatic data entry...SmartArt and PowerPoint slide masters...Outlook’s new To-Do Bar and RSS feeds...and plenty more!   Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts. LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions--you’ll learn key skills in as little as five minutes! Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your instructor shows exactly how to get great results in your real-world environment.   Section 1:  Getting Started with Office 2007                                                                      Lesson 1:  An Initial Tour of Office 2007  [4:41] Lesson 2:  File Formats and Compatibility Solutions   [6:23] Lesson 3:  Working with Themes between Office Applications [6:16] Lesson 4:  Utilizing Help in Office 2007   [4:15] Lesson 5:  Setting Options for Office and Individual Applications  [4:28] Project 1:  Create the Ultimate Office Working Environment  [6:18]   Section 2:  Word 2007 Lesson 6:  Finding All Your Favorite Tools  [6:30] Lesson 7:  Document Encryption (and more)  [9:03] Lesson 8:  Using Word as a Blog Editor [3:56] Lesson 9:  Inspect Your Document and Remove Metadata [5:00] Lesson 10:  Working with Tables  [6:53] Lesson 11:  Convert a Document to PDF or XPS  [6:32] Lesson 12:  Using Academic Tools (Footnotes, Endnotes, Citations)  [7:25] Lesson 13:  Using Track Changes and Comments [8:38] Lesson 14:  Quick Parts and the Building Block Organizer [5:59] Lesson 15:   How to Perform a Mail Merge  [9:10] Project 2:  Create a Three-Fold Brochure  [6:55]   Section 3:  Excel 2007 Lesson 16:  Maneuvering Through Workbooks and Worksheets  [9:48] Lesson 17:  Automatic Data Entry Methods   [8:59] Lesson 18:  Formatting Cells Manually, with Styles, and with Themes  [8:42] Lesson 19:  Conditional Formatting (Data Bars, Color Scales, Icon Sets) [4:56] Lesson 20:  Basic Excel Formulas  [3:30] Lesson 21:  Basic Excel Functions   [9:44] Lesson 22:  Excel Function Groups (Advanced Function Possibilities) [4:58] Lesson 23:  Troubleshoot Function Errors  [8:31] Lesson 24:  Use Tables to Sort and Filter Data    [8:17] Lesson 25:  Creating Pivot Tables  [7:45] Lesson 26:  Protecting Your Workbook and Worksheets [11:55] Lesson 27:  Illustrations and Smart Art in Excel  [10:16] Lesson 28:  Basic Chart Building  [10:42] Lesson 29:  Advanced Chart Creation   [12:17] Lesson 30:  Printing Your Worksheets [6:13] Project 3:  Working with a Loan Amortization Table [7:14]   Section 4:  PowerPoint 2007 Lesson 31:  Create a Simple Slide Show  [6:45] Lesson 32:  Insert Graphics, SmartArt, and Charts  [6:12] Lesson 33:  Add Movies and Sound to Your Presentation  [8:21] Lesson 34:  Slide Animations and Tran

THE ONLY VISIO 2007 BOOK YOU NEED   “This book makes Visio as much fun as a video game.” Bob and Joy Schwabach, “On Computers, ” Universal Press Syndicate   We crafted this book to grow with you, providing the reference material you need as you move toward Visio® 2007 proficiency and the use of more advanced features. If you buy only one book on Visio® 2007, Special Edition Using Microsoft Office Visio® 2007 is the only book you need.   • Working with shapes, stencils, and themes • Using the Data Graphics feature for extra customization • Importing content from Microsoft Excel and Microsoft Project • Displaying data as text, data bars, icons, and color-coding using Data Graphics • Creating custom stencils, icons, and templates • Storing and displaying employee information in organization charts • Customizing the layout of organization charts • Creating database models, flowcharts, and Gantt charts • Connecting shapes in network drawings • Using digital ink and animation • Creating macros • Handling guides and rulers • Working with layers • Getting the most from ShapeSheets