New Perspectives on Microsoft®Office 2013, 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. 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. 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. A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling. Ms. Ann Shaffer is the co-author of NEW PERSPECTIVES ON MICROSOFT® WORD and has contributed to many other Cengage publications. She has more than 25 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 2013 CONTENT.
Tutorial 5: Working with Templates, Themes, and Styles.
Tutorial 6: Using Mail Merge.
Tutorial 7: Collaborating with Others and Integrating Data.
EXCEL 2013 CONTENT.
Tutorial 5: Creating Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Developing an Excel Application.
Tutorial 8: Working with Advanced Functions.
Appendix A: Using Text Functions and Creating Custom Formats,
Appendix B: Using Advanced Filters, Database, and Summary IFS Functions,
ACCESS 2013 CONTENT.
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 2013 CONTENT.
Tutorial 3: Inserting Tables and Other Objects.
Tutorial 4: Adding Charts and Sharing a Presentation.