Shelly Cashman Series Microsoft®Office 365 & Excel® 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. Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S. For over 15 years, Mr. Schmieder has served as a computer technology instructor in adjunct and full-time capacities in curriculum instruction, corporate training, continuing education, economic and workforce development, professional development, small business, and webmaster certificate programs throughout North Carolina. His classroom instruction has served students at NC State University and many schools in the NC Community College System. He is a member of the NC Computer Instructors Association (NCCIA), NC Community College Faculty Association (NCCCFA), Textbook and Academic Authors Association (TAA), and US Distance Learning Association (USDLA). He holds certifications as a Microsoft Certified Trainer and Microsoft Office Master Specialist and is a regular presenter at local and national conferences.

Front Matter.
Microsoft’s New Productivity Tools for School and Work.
Office 2016 and Windows 10: Essential Concepts and Skills.
1. Creating a Worksheet and a Chart.
2. Formulas, Functions, and Formatting.
3. Working with Large Worksheets, Charting, and What-If Analysis.
4. Financial Functions, Data Tables, and Amortization Schedules.
5. Working with Multiple Worksheets and Workbooks.
6. Creating, Sorting, and Querying a Table.
7. Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.
8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.
9. Formula Auditing, Data Validation, and Complex Problem Solving.
10. Using Macros and Visual Basic for Applications (VBA) with Excel.
11. Collaboration Features for Workbooks.
Index.