Shelly Cashman Series MicrosoftOffice 365 & Excel 2016: Comprehensive / Edition 1

by Steven M. Freund

Overview

Introduce your students to the latest 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 computer skills to millions. MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE continues the Series’ strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today’s students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft Excel 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Excel 2016.

Product Details

ISBN-13:	2901305870726
Publisher:	Cengage Learning
Publication date:	07/12/2016
Series:	MindTap Course List
Pages:	816
Product dimensions:	8.40(w) x 10.80(h) x 1.20(d)

About the Author

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.

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.