Description
Book SynopsisIntroduce 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.
Table of ContentsFront 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.
