Shelly Cashman Series Microsoft Office 365 & Excel 2016: Comprehensive, Loose-leaf Version / Edition 1

by Steven M. Freund, Joy L. Starks, Eric Schmieder

Overview

Discover all of the advancements that Microsoft Office and Excel 2016 have to offer with MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE — the new edition in the acclaimed Shelly Cashman Series. For more than three decades, the Shelly Cashman Series has effectively introduced advanced computer skills to millions of students like you. MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE provides an enhanced learning approach to help you master all aspects of Excel 2016, no matter what your learning style. A trademark, step-by-step, screen-by-screen approach encourages you to expand your understanding of Microsoft Excel 2016 through experimentation, critical thought, and personalization. This new edition delivers effective educational materials specifically designed to introduce more advanced features, improve retention, and prepare you for success in using MS Office and Excel 2016.

Product Details

ISBN-13:	9781337251051
Publisher:	Cengage Learning
Publication date:	07/18/2016
Pages:	816
Product dimensions:	8.50(w) x 10.80(h) x 0.80(d)

About the Author

Steven M. Freund attended the University of Central Florida and serves as a leader 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, as well as other customer events. Mr. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows Internet Explorer, Windows, Office, and Dreamweaver books. He has also written numerous successful instructor supplements..


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.

Table of Contents

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.