Help your students develop the complete set of Microsoft® Excel 2016 skills they need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE. Updated to provide all-new case scenarios, this dynamic introduction applies the skills students are learning to real-world situations to ensure that concepts remain highly relevant. New Productivity Apps provide a visual introduction to Microsoft® OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help students learn to use each app. With an unmatched emphasis on learning outcomes and transference of skills, NEW PERSPECTIVES MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE engages students by clearly demonstrating the importance of the complete Microsoft® Excel 2016 skills that they are learning.
- ProSkills boxes provide guidance on using Microsoft Excel effectively in professional situations.
- Visual overviews give a preview of each module's content, serving as helpful study guides.
- Key Steps draw attention to critical points to avoid rework.
- New productivity apps module guides students through Microsoft OneNote, Sway, Office Mix and Edge.
- Practical business case scenarios throughout allow students to apply Excel 2016 concepts and skills to real-world contexts.
- Updated content highlights new functionalities in Excel 2016 like ROUND and MROUND functions, and new chart types like histogram, waterfall, and sunburst charts. Also new content on power BI features including power query, power view, and power map.
Productivity Apps for School and Work.
1. Getting Started with Excel.
2. Formatting Workbook Text and Data.
3. Performing Calculations with Formulas and Functions.
4. Analyzing and Charting Financial Data.
5. Working with Excel Tables, PivotTables, and PivotCharts.
6. Managing Multiple Worksheets and Workbooks.
7. Developing an Excel Application.
8. Working with Advanced Functions.
9. Exploring Financial Tools and Functions.
10. Performing What-If Analyses.
11. Analyzing Data with Business Intelligence.
12. Collaborating on a Shared Workbook.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Working with Enhanced Formatting Tools.
June Jamrich Parsons
Dan Oja
Patrick Carey, Westminster Kingsway College
Mr. Patrick Carey received his M.S. in Biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies.
Carol DesJardins, St. Clair County Community College
Ms. Carol DesJardins spent 25 years in the private sector as a programmer, systems analyst and eventually Chief Information Officer. In addition, she continues to teach at St. Clair County Community College.
