Exploring Microsoft Office Excel 2016 Comprehensive

This book offers full, comprehensive coverage of Microsoft Excel.
Beyond point-and-click

The goal of the Exploring series is to move students beyond the point-and-click, to understanding the why and how behind each skill. And because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, anytime. Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.

Also available with MyITLab

MyITLab ^® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, which engages students and improves results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success.

Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

Table of Contents

Microsoft Office 2016
Chapter One Office 2016 Common Features: Taking the First Step

Microsoft Office Excel 2016
Chapter One Introduction to Excel: Creating and Formatting a Worksheet
Chapter Two Formulas and Functions: Performing Quantitative Analysis
Chapter Three Charts: Depicting Data Visually
Chapter Four Datasets and Tables: Managing Large Volumes of Data
Chapter Five Subtotals, PivotTables, and PivotCharts: Summarizing and Analyzing Data
Chapter Six What-If Analysis: Using Decision-Making Tools
Chapter Seven Specialized Functions: Using Date, Logical, Lookup, Database, and Financial Functions
Chapter Eight Statistical Functions: Analyzing Statistics
Chapter Nine Multiple-Sheet Workbook Management: Ensuring Quality Control
Chapter Ten Imports, XML, and Power Add-Ins: Managing Data
Chapter Eleven Collaboration and Workbook Distribution: Sharing Data with Others
Chapter Twelve Templates, Styles, and Macros: Standardizing Workbooks

Application Capstone Exercises
Excel Introductory Capstone Exercise (Chs. 1–4)
Excel Comprehensive Capstone Exercise (Chs. 5–12)

Microsoft Office 2016 Specialist Excel Core