Skills for Success with Microsoft Excel 2016 Comprehensive

Cover
Title Page
Copyright Page
Contents in Brief
Table of Contents
Series Reviewers
About the Authors
Chapter 1: Common Features of Office 2016
	Skill 1: Start Office Applications
	Skill 2: Open and Save Student Data Files
	Skill 3: Type and Edit Text
	Skill 4: Format Text and Save Files
	Skill 5: Apply Themes and Use the Mini Toolbar
	Skill 6: Use Backstage View
	Skill 7: Insert and Format Images
	Skill 8: Format Worksheets
	Skill 9: Copy and Paste Objects and Format Slides
	Skill 10: Format Access Reports
	Skill 11: Store Files Online
	Skill 12: Share Office Files
	Skill 13: Install Office Add-ins
	Skill 14: Customize the Ribbon and Options
Introduction to Excel
Chapter 1: Create Workbooks with Excel 2016
	Skill 1: Create and Save Workbooks
	Skill 2: Enter Data and Merge and Center Titles
	Skill 3: Construct Addition and Subtraction Formulas
	Skill 4: Construct Multiplication and Division Formulas
	Skill 5: Adjust Column Widths and Apply Cell Styles
	Skill 6: Insert the SUM Function
	Skill 7: AutoFill Formulas and Data
	Skill 8: Format, Edit, and Check Spelling
	Skill 9: Insert Footers and Adjust Page Settings
	Skill 10: Display Formulas and Print Worksheets
	Skill 11: Set Print Areas
	Skill 12: Fill Data with Flash Fill
	Skill 13: Create Templates and Workbooks from Templates
	Skill 14: Manage Document Properties
Chapter 2: Insert Summary Functions and Create Charts
	Skill 1: Align and Wrap Text
	Skill 2: Apply Absolute Cell References
	Skill 3: Format Numbers
	Skill 4: Insert the AVERAGE Function
	Skill 5: Insert the MIN and MAX Functions
	Skill 6: Create Column Charts
	Skill 7: Format Column Charts
	Skill 8: Create and Format Pie Charts
	Skill 9: Update Charts and Insert WordArt
	Skill 10: Preview and Print Multiple Worksheets
	Skill 11: Validate Workbooks for Accessibility
	Skill 12: Change Chart Types
	Skill 13: Copy Excel Data to Word Documents
	Skill 14: Create Line Charts
Chapter 3: Manage Multiple Worksheets
	Skill 1: Organize Worksheet Tabs
	Skill 2: Enter and Format Dates
	Skill 3: Clear Cell Contents and Formats
	Skill 4: Move Cell Contents and Use Paste Options
	Skill 5: Enter Data in Grouped Worksheets
	Skill 6: Insert Multiple Math Operators in Formulas
	Skill 7: Format Grouped Worksheets
	Skill 8: Insert, Hide, Delete, and Move Worksheets
	Skill 9: Create Summary Worksheets
	Skill 10: Create Clustered Bar Charts
	Skill 11: Create SmartArt Organization Charts
	Skill 12: Create and Insert Screen Shots
	Skill 13: Modify the Quick Access Toolbar
	Skill 14: Create and Edit Hyperlinks
Chapter 4: More Functions and Excel Tables
	Skill 1: Insert the TODAY, NOW, and COUNT Functions
	Skill 2: Insert the IF Function
	Skill 3: Move Functions, Add Borders, and Rotate Text
	Skill 4: Apply Conditional Formatting
	Skill 5: Insert Sparklines
	Skill 6: Use Find and Replace
	Skill 7: Freeze and Unfreeze Panes
	Skill 8: Create and Sort Excel Tables
	Skill 9: Filter Excel Tables
	Skill 10: Convert Tables to Ranges and Adjust Worksheet Print Settings
	Skill 11: Add and Remove Table Columns and Rows
	Skill 12: Insert the Payment (PMT) Function
	Skill 13: Customize Workbook Views
	Skill 14: Use Text and Lookup Functions
		Excel Capstone Project
		Excel Online (formerly Web App) Project Create Workbooks Using Excel Online
Chapter 5: Format Cells and Worksheets
	Skill 1: Insert Symbols and Create Custom Number Formats
	Skill 2: Format Cells Using Format Painter
	Skill 3: Apply Icon Sets as Conditional Formatting
	Skill 4: Insert Formulas into Conditional Formatting Rules
	Skill 5: Insert and Delete Rows, Columns, and Cells
	Skill 6: Modify Cell Backgrounds and Borders
	Skill 7: Create and Apply Custom Cell Styles
	Skill 8: Customize, Save, and Apply Themes
	Skill 9: Add Watermarks and Modify Background Colors
	Skill 10: Hide Gridlines and Column and Row Headings
	Skill 11: Convert Comma-Separated Text into Columns
	Skill 12: Inspect Document Properties to Remove Personal Information
	Skill 13: Remove Duplicate Records
	Skill 14: Insert Shapes and Text Boxes
Chapter 6: Insert Advanced Functions and Create Scenarios
	Skill 1: Modify Text Using Text Functions
	Skill 2: Use Paste Options to Change Underlying Values
	Skill 3: Look Up Data Using Lookup Functions
	Skill 4: Edit Conditions in Logical Functions
	Skill 5: Use COUNTA and COUNTIF Functions
	Skill 6: Perform What-If Analyses Using Scenario Manager
	Skill 7: Estimate Future Value
	Skill 8: Insert Array Formulas
	Skill 9: Calculate Conditional Sums
	Skill 10: Calculate Conditional Averages
	Skill 11: Use Lookup and Nested Functions
	Skill 12: Use Solver
	Skill 13: Update Calculations Manually
	Skill 14: Create Amortization Tables
Chapter 7: Work with Data and Audit Formulas
	Skill 1: Import Data from Text Files
	Skill 2: Apply Advanced AutoFilters
	Skill 3: Sort Data Using Conditional Formatting
	Skill 4: Sort Data and Use the Subtotal Tool to Summarize Data
	Skill 5: Trace and Evaluate Formulas
	Skill 6: Audit Formulas Using Cell Watch
	Skill 7: Create One-Variable Data Tables
	Skill 8: Create Two-Variable Data Tables
	Skill 9: Generate Custom Table Styles
	Skill 10: Name Tables and Convert Tables to a Range
	Skill 11: Insert Names into Formulas
	Skill 12: Use Goal Seek
	Skill 13: Use MATCH and INDEX Functions: Part 1
	Skill 14: Use MATCH and INDEX Functions: Part 2
Chapter 8: Manage and Present Data Visually
	Skill 1: Import and TRIM Data from Non-native Files
	Skill 2: Use LEFT, RIGHT, and MID Functions
	Skill 3: Add Legends and Data Series to Charts
	Skill 4: Enhance Charts with Trendlines and Text Boxes
	Skill 5: Modify Excel Worksheet Templates
	Skill 6: Consolidate Worksheet Data
	Skill 7: Construct Dual Axis Charts
	Skill 8: Create and Edit Custom Chart Templates
	Skill 9: Edit and Save Excel File Type Versions
	Skill 10: Send Workbook Files via Email and OneDrive
	Skill 11: Modify Charts and Graph Parameters
	Skill 12: Manage Workbook Versions
	Skill 13: Serialize Numbers Using Functions
	Skill 14: Modify the Excel Ribbon
Chapter 9: Link and Analyze Data in PivotTables and PivotCharts
	Skill 1: Get and Transform Data
	Skill 2: Create PivotTable Reports
	Skill 3: Change PivotTable Report Views
	Skill 4: Change Calculation Types and Format PivotTable Reports
	Skill 5: Create PivotTable Report Calculated Fields
	Skill 6: Group and Filter PivotTable Reports
	Skill 7: Use Slicers to Filter PivotTable Reports
	Skill 8: Create PivotChart Reports
	Skill 9: Format PivotChart Reports
	Skill 10: Summarize Tables Using GETPIVOTDATA
	Skill 11: Use Power Pivot to Link Data to Access Databases
	Skill 12: Create PivotChart Reports Using Power View
	Skill 13: Add CUBE Functions Using Power Pivot
	Skill 14: Use the Inquire Add-In
Chapter 10: Secure and Share Workbooks
	Skill 1: Modify Excel Options and Work with Comments
	Skill 2: Add Data Validation Rules
	Skill 3: Track Changes
	Skill 4: Accept and Reject Tracked Changes
	Skill 5: Merge Changes
	Skill 6: Save Workbooks as Web Pages and Embed Data in Web Pages
	Skill 7: Unlock Cells and Protect Worksheets
	Skill 8: Enable and Copy Macros Between Workbooks
	Skill 9: Record Macros
	Skill 10: Write Macros Using VBA
	Skill 11: Insert Form Controls
	Skill 12: Add Macro Buttons to the Quick Access Toolbar
	Skill 13: Prepare Workbooks for Internationalization
	Skill 14 Assign Macros to Command Buttons
		Excel Capstone Project
		Excel Online (formerly Web App) Project: Use Advanced Skills to Create Online Workbooks
Glossary
Appendix
Index
Back Cover