Shelly Cashman Series Microsoft®Office 365 & Office 2016

Steven M. Freund serves as a lead instructor of various Microsoft® Office, computer concepts, programming and internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series® since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, MOZILLA FIREFOX, WINDOWS® INTERNET EXPLORER, WINDOWS® OFFICE and DREAMWEAVER books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida. Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts. Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL. Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She also is a licensed attorney. Working with the leading SHELLY CASHMAN SERIES® since 1993, she has co-authored several successful textbooks, including multiple versions of DISCOVERING COMPUTERS and MICROSOFT® POWERPOINT® books. She holds both Master of Arts and Juris Doctor degrees. Misty E. Vermaat has more than 30 years of experience in the field of computer and information technology. In addition to consulting in the field, she was 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 authored and co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS, MICROSOFT® PUBLISHER and MICROSOFT® WORD books.

• Microsoft’s New Productivity Tools for School and Work.Word 8. Using Document Collaboration, Integration, and Charting Tools.Word 9. Creating a Reference Document with a Table of Contents and an Index.Word 10. Creating a Template for an Online Form.Word 11. Enhancing an Online Form and Using Macros.PPT 8. Customizing a Template and Handouts Using Masters.PPT 9. Modifying a Presentation Using Graphical Elements.PPT 10. Developing a Presentation with Content from Outside Sources.PPT 11. Organizing Slides and Creating a Photo Album.Excel 8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.Excel 9. Formula Auditing, Data Validation, and Complex Problem Solving.Excel 10. Using Macros and Visual Basic for Applications (VBA) with Excel.Excel 11. Collaboration Features for Workbooks.Access 8. Macros, Navigation Forms, and Data Macros.Access 9. Administering a Database System.Access 10. Using SQL.Access 11. Database Design.Outlook 4. Creating and Managing Tasks.Outlook 5. Customizing Outlook.Index.