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.

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.

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. MODULE 2 PROVIDES ENHANCED COVERAGE OF NEW EXCEL FUNCTIONS. Your students learn to take advantage of the Flash Fill feature and additional Excel functions, including the PRODUCT function. MODULE 3 COVERS ACCESSIBILITY AND OTHER KEY FEATURES IN EXCEL. Your students learn to use the new Smart Lookup feature with the Insights panel and become equipped to maximize other tools. UPDATED PROJECT IN MODULE 4 SHOWS STUDENTS HOW TO CREATE A MORTGAGE PAYMENT CALCULATOR. Students learn from rewritten step-by-step project instructions that clearly divide complex tasks into smaller, easy-to-understand steps. MODULE 5 NOW INTRODUCES THE EXTENDED BAR AND PIE CHART FORMATTING. This module begins the discussion on extended bar and pie chart formatting, guiding students in the best methods for displaying data. MODULE 6 HIGHLIGHTS ADVANCED USE OF THE QUICK ANALYSIS GALLERY. Analyzing data is now easier than ever in Excel 2016 as students learn how to best use this contextual tool and its single-click access. MODULE 7 INTRODUCES TREEMAP CHARTS AND TEXT EFFECTS. Students learn to use this hierarchical view of data that makes it easy to spot patterns. STUDENTS LEARN MORE ADVANCED SKILLS RELATED TO FORMATTING THE EXTENDED BAR AND PIE CHART. Module 8 takes your students’ skills to the next level as they learn to most effectively display data. EXPANDED MODULES 9-11 EMPHASIZE ADDITIONAL EXCEL 2016 FEATURES. These modules are thoroughly updated in this edition to emphasize advanced Excel features and new advantages that Excel 2016 offers to users. STEP-BY-STEP, SCREEN-BY-SCREEN APPROACH EFFECTIVELY INTRODUCES KEY EXCEL SKILLS. This proven visual approach presents students with explanatory and navigational information specifically when they need to know it in order to master Excel 2016. The book addresses the needs of all learning styles to help students retain and apply skills in their personal and professional lives.