New Perspectives on Microsoft Office 2007: Second Course

Ms. Ann Shaffer is the author of NEW PERSPECTIVES ON MICROSOFT® WORD 365 and has contributed to many other Cengage publications. She has more than 30 years of experience as a developmental editor and co-author of books, journal articles and multimedia in a variety of fields, including computer science, mathematics, history, engineering and social sciences. She holds a master’s degree in English from the University of Wisconsin-Madison. Patrick Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Since that time, he has authored or co-authored more than 30 leading academic and trade texts for today's software industry. Roy Ageloff has taught courses in computer programming, database design and development, accounting information systems, and office productivity software at the University of Rhode Island and has written textbooks in programming languages, database software, and spreadsheet applications. He is a business consultant and teacher at Paradise Valley Community College, Arizona. June Jamrich Parsons is an educator, digital book pioneer, co-author of Texty and McGuffey award-winning textbooks and a TAA fellow. She co-developed the first commercially successful multimedia, interactive digital textbook that established the standard for platforms now being developed by numerous educational publishers. In addition to authoring textbooks for Course Technology and Cengage, Dr. Parsons' career includes extensive classroom teaching and product design for eCourseware. She also served as a creative strategist for MediaTechnics Corp. and director of content for Veative Virtual Reality Labs. A member of the Association for Computing Machinery, she holds a Ph.D. in instructional technology and Certified Computing Professional certification. June Jamrich Parsons is an educator, digital book pioneer, co-author of Texty and McGuffey award-winning textbooks and a TAA fellow. She co-developed the first commercially successful multimedia, interactive digital textbook that established the standard for platforms now being developed by numerous educational publishers. In addition to authoring textbooks for Course Technology and Cengage, Dr. Parsons' career includes extensive classroom teaching and product design for eCourseware. She also served as a creative strategist for MediaTechnics Corp. and director of content for Veative Virtual Reality Labs. A member of the Association for Computing Machinery, she holds a Ph.D. in instructional technology and Certified Computing Professional certification. An esteemed professional and respected author, Dan Oja, along with June Parsons, purchased an Apple II+ in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, he and Dr. Parsons opened a successful small computer retail store that offered software instruction to children and adults. With Dr. Parsons, Mr. Oja began writing and creating educational software for Course Technology in 1992. Together, they contributed to the leading success of the Windows for Business and Illustrated Series. They also developed the New Perspectives, e-Course, and Practical series. Today, Mr. Oja's and Dr. Parson's team of highly skilled media specialists and desktop publishers located in various states and provinces work together via the Internet to deliver exceptional texts. S. Scott Zimmerman obtained a Ph.D. from Florida State University and was a postdoctoral fellow at Cornell University. He is currently a professor at Brigham Young University in Provo, Utah and has published many scientific papers, computer articles, and computer programming and applications software books. Beverly B. Zimmerman, an award-winning Associate Professor at Brigham Young University, holds a Ph.D. in instructional design. She has published several articles on the use of computer technology for teaching writing, co-authored over 30 books on computer applications software, and authored an oral presentations book. Joseph J. Adamski spent 12 years as a computer professional at aerospace and financial services companies and is an Associate Professor Emeritus at Grand Valley State University. He has worked as a computer professional and educator for over 40 years with a special interest in database management and personal uses of databases.

Word-Level II Tutorials Tutorial 5: Working with Templates and Outlines Tutorial 6: Using Mail Merge Tutorial 7: Collaborating with Others and Creating Web Pages Excel-Level II Tutorials Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts Tutorial 6: Managing Multiple Worksheets and Workbooks Tutorial 7: Using Advanced Functions, Conditional Formatting, and Filtering Tutorial 8: Developing an Excel Application Appendix A: Working with Text Functions and Creating Custom Format Appendix B: Integrating Excel with Other Windows Programs Access-Level II Tutorials Tutorial 5: Creating Advanced Queries and Enhancing Table Design Tutorial 6: Using Form Tools and Creating Custom Forms Tutorial 7: Creating Custom Reports Tutorial 8: Sharing, Integrating, and Analyzing Data Appendix A: Relational Databases and Database Design PowerPoint-Level II Tutorials Tutorial 3: Presenting a Slide Show with Special Effects Tutorial 4: Integrating PowerPoint with Other Programs and Collaborating with Workgroups

• Word—Level II TutorialsTutorial 5: Working with Templates and OutlinesTutorial 6: Using Mail MergeTutorial 7: Collaborating with Others and Creating Web PagesExcel—Level II TutorialsTutorial 5: Working with Excel Tables, PivotTables, and PivotChartsTutorial 6: Managing Multiple Worksheets and WorkbooksTutorial 7: Using Advanced Functions, Conditional Formatting, and FilteringTutorial 8: Developing an Excel Application Appendix A: Working with Text Functions and Creating Custom FormatAppendix B: Integrating Excel with Other Windows ProgramsAccess—Level II TutorialsTutorial 5: Creating Advanced Queries and Enhancing Table DesignTutorial 6: Using Form Tools and Creating Custom FormsTutorial 7: Creating Custom ReportsTutorial 8: Sharing, Integrating, and Analyzing DataAppendix A: Relational Databases and Database DesignPowerPoint—Level II TutorialsTutorial 3: Presenting a Slide Show with Special EffectsTutorial 4: Integrating PowerPoint with Other Programs and Collaborating with Workgroups