New Perspectives on Microsoft Office 2007: Second Course

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

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