Microsoft Office 2007: 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.

Word 2007
4. Creating a Document with a Title Page, Table, Chart, and Watermark
5. Generating Form Letters, Mailing Labels, and Directories
6. Creating a Professional Newsletter
Integration Feature: Linking an Excel Worksheet and Chart to a Word Document
Excel 2007
4. Financial Functions, Data Tables, and Amortization Schedules
5. Creating, Sorting, and Querying a Table
6. Creating Templates and Working with Multiple Worksheets and Workbooks
Graphics Feature: SmartArt and Images
Access 2007
4. Creating Reports and Forms
5. Multi-Table Forms
6. Using Macros, Switchboards, PivotTables, and PivotCharts
SQL Feature: Using SQL
PowerPoint 2007
3. Creating a Presentation with Custom Backgrounds and SmartArt Diagrams
4. Working with Information Graphics
Collaboration Feature: Collaborating on and Delivering Presentations
Outlook 2007
2. Managing Calendars and Instant Messaging
Microsoft Office 2007 Integration
Microsoft Office 2007 Integration Case Studies
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