Microsoft® Office 2007: Post-Advanced Concepts and Techniques

Misty E. Vermaat has more than 25 years of experience in the field of computer and information technology. In addition to consulting in the field, she was an Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design, and programming courses. Since 1990, Ms. Vermaat has led the development of the Shelly Cashman Series and has written or co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS and Microsoft® Word books. Gary B. Shelly wrote and published his first computer education textbook in 1969. More than twenty million copies of Shelly Cashman Series' textbooks have been sold. Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Gary has hosted the annual Shelly Cashman Institute, a week-long training event focusing on the latest topics in technology, for the past 34 years. Thomas J. Cashman received his education at California State University, Los Angeles. He established one of the first business data processing programs in the U.S. at Long Beach City College in California, where he taught and served as department head. In 1969, he began collaborating with now best-selling author, Gary Shelly.

Microsoft Word 2007
7. Working with Document Sharing Tools, a Master Document, a Table of Contents, and an Index
8. Creating an Online Form
9. Enhancing an Online Form and Working with Macros, Document Security, and XML
Blogging Feature: Creating a Blog Post

Microsoft Excel 2007
7. Using Macros and Visual Basic for Applications (VBA) with Excel
8. Formula Auditing, Data Validation, and Complex Problem Solving
9. Importing Date, Working with PivotCharts, PivotTables, and Trendlines
Collaboration Feature: Using SharePoint and Excel Services
Microsoft Access 2007
7. Advanced Report Techniques
8. Advanced Form Techniques
9. Administering a Database System
Web Feature: Sharing Access Data
Microsoft PowerPoint 2007
5. Reusing a Presentation with Multimedia
6. Creating a Self-Running Presentation Containing Animated Shapes
Online Feature: Importing Files from the Microsoft Office Online Web Site
Appendices
A: Project Planning Guidelines
B: Introduction to Microsoft Office 2007
C: Microsoft Office 2007 Help
D: Publishing Office 2007 Web Pages to a Web Server
E: Customizing Microsoft Office 2007
F: Steps for the Windows XP User
G: Microsoft Business Certification Program