Shopping Search

If you need to learn Accounting Professional 2007 yet hesitate to take classes because of the expense, travel, or time commitment involved, choose DVD training. Our video session feature certified instructors who will teach you Accounting Professional 2007 by showing you the software in action. You’ll learn simply by watching videos!

“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  

Extract and analyze mission-critical enterprise data using Microsoft Office 2007This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.Create Excel PivotTables and PivotCharts and apply Conditional FormattingConvert Excel spreadsheets into Excel Tables with Conditional Formatting and ChartingConnect external data to Excel using Office Data Connections and SharePointCreate SharePoint dashboards that display data from multiple sourcesAdd Key Performance Indicators and Excel Services reports to your dashboardsHarness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster DiagramsGenerate integrated PerformancePoint ScorecardsCreate Visio PivotDiagrams and Windows Mobile spreadsheets All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book's title to download the examples.

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

Full Version, Platform(s): PC; Package Type: Retail, For 3 Computer/s, CD-ROM, MPN: 79A-00004

The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following:  exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes;  instructing how to use the software as a tool to accomplish business goals; coverage of the core Office skills that you will need in your business courses. In Business includes tools that will benefit any style of learning. Whether you need to reference specific skills for another course or understand how to utilize Microsoft Office to complete your business objectives, In Business will allow you to apply these skills directly to your own education and career aspirations. Microsoft Office Access 2007 In Business, Core, 1/e covers the following topics: introduction to Access; database tables; selecting and summarizing data from tables; applying calculations to data; reports; and applying core competencies.  Ideal for business students and professionals.

Build your students' Microsoft Office 2007 skills through the realistic, engaging projects in this revised text. Microsoft Office 2007- Illustrated Projects offers meaningful projects in each of the four main Office applications-Word, Excel, Access, and PowerPoint-as well as projects for integrating these applications. Students will learn to produce a variety of viable, real-life documents, such as resumes, business cards, budgets, presentations, and more through easy-to-follow steps, large screen shots, and images of completed projects.

<>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

Upgrade Version, Platform(s): PC; Package Type: Retail, For 1 Computer/s, CD-ROM, MPN: H30-01825

The Ultimate Microsoft Office Access 2007 ResourceBuild a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications. Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the book's sample databases on the CD-ROM.Customize the user interface to suit your preferences Use the built-in database templates or design your ownCreate, modify, and relate tablesEnter and edit dataWrite advanced queries to extract and manipulate informationCreate customized forms and reportsImprove performance and back up your databaseDevelop macros to carry out automated responses to user actionsImport, link, and export dataEnable a multiple-user environmentSecure your database

<>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

DVD-ROM

Full Version, Platform(s): PC; Package Type: OEM (License Only), For 1 Computer/s, CD-ROM, MPN: 26914071

Platform(s): PC; Package Type: License Only, MPN: 79G-00955

A comprehensive reference on Microsoft Office Access 2007 furnishes an overview of the features and functions of the program, discussing such topics as building queries, importing and exporting data, creating reports, securing a database, and distributing an Access application, as well as hundreds of timesaving solutions, troubleshooting tips, and workarounds, and custom resources and searchable eBook on the companion CD-ROM. Original. (All Users)

A complete overview of the new integrated software package provides helpful guidelines--complete with a host of colorful screenshots--on how to use the Basic, Home and Student, Standard, and Small Business suites of Microsoft Office 2007, with coverage of the new features of Excel, OneNote, Outlook, Outlook with Business Contact Manager, PowerPoint, Publisher, and Word. Original. (All Users)

Prepare your students to transition their Microsoft? Office 2007 skills to the Microsoft? Office 2010 software with UPGRADING TO MICROSOFT OFFICE 2010. This print product is closely integrated with SAM 2007 v6.0. Using both products together will allow you to expose your students to Office 2010, enable them to stay current and gauge their competency in Microsoft Office 2007 and 2010 with one assessment product.

Microsoft Office SharePoint Designer 2007 Publisher: Microsoft Corp. Platform: Windows Packaging: New in Box Condition: New UPC: 882224165358

Here’s WHAT You’ll Learn Easily navigate the new user interface Create documents, Web pages, and other publications Organize your e-mail, calendar, and tasks Build spreadsheets to manage and analyze data Build a simple database Design and deliver a slide show presentation Here’s HOW You’ll Learn It Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help you apply what you learn right away

You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007.* Minimal text and maximum illustrations*Task-oriented, step-by-step approach*Navigational aids connect instructions to illustrations*Self-contained, two-page lessons*Uniform layout makes it easy to read less, learn moreHow easy is it?Look for these symbols marking the difficulty of each task.* Demonstrates a new spin on a common task*Introduces a new skill or a new task*Combines multiple skills requiring in-depth knowledge*Requires extensive skill and may involve other technologies

Completely redesigned to help users finish tasks more quickly and manage information more effectively, Microsoft Office 2007 will offer users a new look and smarter ways of getting things done. From the expanded depth and power of Excel 2007 to the new graphics capabilities and formatting tools of PowerPoint, Microsoft has rethought and reworked the entire suite. And in this new edition of our Office Visual QuickStart Guide, author Steve Schwartz has rewritten from the ground up the entire book to better aid readers as they get up to speed with the new Office tools. The book is essential reference tool for the home and small business user, covering everything in the Office Basic, Home & Student, Standard, and Small Business suites. Software covered includes: Word, Excel, OneNote, Outlook, PowerPoint, and Publisher. Easy visual approach uses pictures to guide you through Microsoft Office and show you what to do. Concise steps and explanations let you get up and running in no time. Page for page, the best content and value around. Table of Contents: Part I:    Introducing Microsoft Office 2007 Chapter 1:    What's New in Office 2007? Chapter 2:    Office Basics Part II:    Microsoft Word Chapter 3:    Getting Started with Word 2007 Chapter 4:    Formatting Documents Chapter 5:    Creating Outlines Chapter 6:    Tables, Charts, and Art Chapter 7:    Sharing Word Documents Part III:    Microsoft Excel Chapter 8:    Getting Started with Excel 2007 Chapter 9:    Formatting Worksheets and Data Chapter 10:   Formulas and Functions Chapter 11:   Working with Tables Chapter 12:   Creating Charts Part IV:    Microsoft PowerPoint Chapter 13:    Getting Started with PowerPoint 2007 Chapter 14:    Creating a Presentation Chapter 15:    Completing a Presentation Part V:    Microsoft Outlook Chapter 16:    Getting Started with Outlook 2007 Chapter 17:    Using the Address Book Chapter 18:    Composing and Sending Mail Chapter 19:    Receiving Mail Chapter 20:    Managing the Mail Chapter 21:    Tasks and Appointments Part VI:    Microsoft OneNote Chapter 22:    Getting Started with OneNote 2007 Chapter 23:    Creating Notes Chapter 24:    Embellishing and Editing Notes Chapter 25:    Managing Notes Part VII:    Microsoft Publisher Chapter 26:    Getting Started with Publisher 2007 Chapter 27:    Distributing and Printing Index

Following the critical thinking, problem-solving approach of the New Perspectives Series students will gain a comprehensive understanding of Microsoft Office 2007, including the new features of the software. The case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With the New Perspectives Series approach, students understand why they're learning what they're learning, and are better situated to retain skills.

Full Version, Platform(s): PC; Standard License, Package Type: Retail, For 1 User/s, CD-ROM, MPN: 79G-00756

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  

Quickly teach yourself how to use Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Take control of your day—organize your e-mail, calendar, and meetings Learn the essentials for creating effective documents Build spreadsheets and perform calculations on your data Design database applications to help manage information Produce and deliver compelling slide show presentations Organize and format text to craft professional-quality documents Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eBook—plus other resources on CD A Note Regarding the CD or DVDThe 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 O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's 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 booktech@oreilly.com.

Full Version, Platform(s): PC; Enterprise License, Package Type: Retail, For 1 Computer/s, CD-ROM, MPN: 79Q-00007

With a focus on Microsoft Word, Excel, and PowerPoint, this manual is written for older adults who wish to become proficient in using the latest versions of these applications. The instructions on each program are user-friendly, written in a step-by-step format, and are shown in individual screenshots that accompany each step. Projects include creating a club magazine, designing a travelogue, organizing a spreadsheet to track finances, and putting together a slide show of pictures. The next step after learning to use an operating system, this guide familiarizes seniors with an extremely useful office suite and allows them to develop their computer skills further.

“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  

This Microsoft Office 2007 Illustrated Series book will appeal to all the learners in your classroom, from the computer rookies to the computer hotshots. It covers the essential information that students need to know about how to use Microsoft Access Office 2007. Our signature two-page spread design has been updated and refreshed to take full advantage of the new features of the Office 2007 software. This practical, easy to navigate book provides students with the essential knowledge they need to succeed in both the classroom and beyond.

This Microsoft Office 2007 Illustrated Series book will appeal to all the learners in your classroom, from the computer rookies to the computer hotshots. It covers the essential information that students need to know about how to use Microsoft Access Office 2007. Our signature two-page spread design has been updated and refreshed to take full advantage of the new features of the Office 2007 software. This practical, easy to navigate book provides students with the essential knowledge they need to succeed in both the classroom and beyond.