Description
Skills for Success with Excel 2016 Comprehensive Edition 1
by Margo Chaney Adkins EBOOK PDF Instant Download
Table of Contents
Skills for Success
Contents in Brief
Table of Contentss
Series Reviewers
A Microsoft Office textbook that recognizes how students learn today
Skills for Success Office 2016
Skills for Success with Microsoft Office 2016
A Microsoft ® Office textbook that recognizes how students learn today Skills for Success with Microsoft® Excel 2016 Comprehensive
Skills for Success
MyITLab
Student Resources and Videos!
Instructor Materials
About the Authors
Getting Started with Microsoft Office Applications
Chapter 1 Common Features of Office 2016
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Start Office Applications Skill 1.1
Skill 2: Open and Save Student Data Files Skill 1.2
Skill 3: Type and Edit Text Skill 1.3
Skill 4: Format Text and Save Files Skill 1.4
Skill 5: Apply Themes and Use the Mini Toolbar Skill 1.5
Skill 6: Use Backstage View Skill 1.6
Skill 7: Insert and Format Images Skill 1.7
Skill 8: Format Worksheets Skill 1.8
Skill 9: Copy and Paste Objects and Format Slides Skill 1.9
Skill 10: Format Access Reports Skill 1.10
More Skills ?11 Store Files Online
More Skills 12 Share Office Files
More Skills 13 Install Office Add-ins
More Skills 14 Customize the Ribbon and Options
Review
Key Terms
Matching
Multiple Choice
Topics for Discussion
Skills Review
More Skills Assessment
Collaborating with Google
Microsoft Office Microsoft Excel
Introduction to Excel
Chapter 1 Create Workbooks with Excel 2016
Introduction
Objectives:
Skills
More Skills
Skill 1: Create and Save Workbooks Skill 1.1
Skill 2: Enter Data and Merge and Center Titles Skill 1.2
Skill 3: Construct Addition and Subtraction Formulas Skill 1.3
Skill 4: Construct Multiplication and Division Formulas Skill 1.4
Skill 5: Adjust Column Widths and Apply Cell Styles Skill 1.5
Skill 6: Insert the SUM Function Skill 1.6
Skill 7: AutoFill Formulas and Data Skill 1.7
Skill 8: Format, Edit, and Check Spelling Skill 1.8
Skill 9: Insert Footers and Adjust Page Settings Skill 1.9
Skill 10: Display Formulas and Print Worksheets Skill 1.10
More Skills 11 Set Print Areas
More Skills 12 Fill Data with Flash Fill
More Skills 13 Create Templates and Workbooks from Templates
More Skills 14 Manage Document Properties
Review
Key Terms
BizSkills Video
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 2 Insert Summary Functions and Create Charts
Outcome
Objectives
Skills
More Skills
Skill 1: Align and Wrap Text Skill 2.1
Skill 2: Apply Absolute Cell References Skill 2.2
Skill 3: Format Numbers Skill 2.3
Skill 4: Insert the AVERAGE Function Skill 2.4
Skill 5: Insert the MIN and MAX Functions Skill 2.5
Skill 6: Create Column Charts Skill 2.6
Skill 7: Format Column Charts Skill 2.7
Skill 8: Create and Format Pie Charts Skill 2.8
Skill 9: Update Charts and Insert WordArt Skill 2.9
Skill 10: Preview and Print Multiple Worksheets
More Skills 11 Validate Workbooks for Accessibility
More Skills 12 Change Chart Types
More Skills 13 Copy Excel Data to Word Documents
More Skills 14 Create Line Charts
Review
Key Terms
BizSkills Video
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 3 Manage Multiple Worksheets
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1 : Organize Worksheet Tabs Skill 3.1
Skill 2: Enter and Format Dates Skill 3.2
Skill 3: Clear Cell Contents and Formats Skill 3.3
Skill 4: Move Cell Contents and Use Paste Options Skill 3.4
Skill 5: Enter Data in Grouped Worksheets Skill 3.5
Skill 6: Insert Multiple Math Operators in Formulas Skill 3.6
Skill 7: Format Grouped Worksheets Skill 3.7
Skill 8: Insert, Hide, Delete, and Move Worksheets Skill 3.8
Skill 9: Create Summary Worksheets Skill 3.9
Skill 10: Create Clustered Bar Charts Skill 3.10
More Skills 11 Create SmartArt Organization Charts
More Skills 12 Create and Insert Screen Shots
More Skills ?13 Modify the Quick Access Toolbar
More Skills 14 Create and Edit Hyperlinks
Review
Key Terms
BizSkills Video
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 4 More Functions and Excel Tables
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1 : Insert the Today, Now, and Count Functions Skill 4.1
Skill 2 : Insert the IF Function Skill 4.2
Skill 3 : Move Functions, Add Borders, and Rotate Text Skill 4.3
Skill 4: Apply Conditional Formatting Skill 4.4
Skill 5: Insert Sparklines Skill 4.5
Skill 6: Use Find and Replace Skill 4.6
Skill 7: Freeze and Unfreeze Panes Skill 4.7
Skill 8: Create and Sort Excel Tables Skill 4.8
Skill 9: Filter Excel Tables Skill 4.9
Skill 10: Convert Tables to Ranges and Adjust Worksheet Print Settings Skill 4.10
More Skills 11 Add and Remove Table Columns and Rows
More Skills 12 Insert the Payment (PMT) Function
More Skills 13 Customize Workbook Views
More Skills 14 Use Text and Lookup Functions
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
Problem Solving
My Skills
Visual Skills Check
Critical Thinking
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Critical Thinking
Collaborating with Google
Capstone Project
Excel Online Project Create Workbooks Using Excel Online
Introduction
Excel Online Project
Chapter 5 Format Cells and Worksheets
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Insert Symbols and Create Custom Number Formats Skill 5.1
Skill 2: Format Cells Using Format Painter Skill 5.2
Skill 3: Apply Icon Sets as Conditional Formatting Skill 5.3
Skill 4: Insert Formulas into Conditional Formatting Rules Skill 5.4
Skill 5: Insert and Delete Rows, Columns, and Cells Skill 5.5
Skill 6: Modify Cell Backgrounds and Borders Skill 5.6
Skill 7: Create and Apply Custom Cell Styles Skill 5.7
Skill 8: Customize, Save, and Apply Themes Skill 5.8
Skill 9: Add Watermarks and Modify Background Colors Skill 5.9
Skill 10: Hide Gridlines and Column and Row Headings Skill 5.10
Skill ?11: Convert Comma-Separated Text into Columns
More Skills ?12 Inspect Document Properties to Remove Personal Information
More Skills ?13 Remove Duplicate Records
More Skills ?14 Insert Shapes and Text Boxes
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skill Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 6 Insert Advanced Functions and Create Scenarios
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Modify Text Using Text Functions Skill 6.1
Skill 2: Use Paste Options to Change Underlying Values Skill 6.2
Skill 3: Look Up Data Using Lookup Functions Skill 6.3
Skill 4: Edit Conditions in Logical Functions Skill 6.4
Skill 5: Use COUNTA and COUNTIF Functions Skill 6.5
Skill 6: Perform What-If Analyses Using Scenario Manager Skill 6.6
Skill 7: Estimate Future Value Skill 6.7
Skill 8: Insert Array Formulas Skill 6.8
Skill 9: Calculate Conditional Sums Skill 6.9
Skill 10: Calculate Conditional Averages Skill 6.10
More Skills 11 Use Lookup and Nested Functions
More Skills 12 Use Solver
More Skills 13 Update Calculations Manually
More Skills 14 Create Amortization Tables
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
Problem Solving
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 7 Work with Data and Audit Formulas
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Import Data from Text Files Skill 7.1
Skill 2: Apply Advanced AutoFilters Skill 7.2
Skill 3: Sort Data Using Conditional Formatting Skill 7.3
Skill 4: Sort Data and Use the Subtotal Tool to Summarize Data Skill 7.4
Skill 5: Trace and Evaluate Formulas Skill 7.5
Skill 6: Audit Formulas Using Cell Watch Skill 7.6
Skill 7: Create One-Variable Data Tables Skill 7.7
Skill 8: Create Two-Variable Data Tables Skill 7.8
Skill 9: Generate Custom Table Styles Skill 7.9
Skill 10: Name Tables and Convert Tables to a Range Skill 7.10
More Skills 11 Insert Names into Formulas
More Skills 12 Use Goal Seek
More Skills ?13 Use MATCH and INDEX Functions: Part 1
More Skills 14 Use MATCH and INDEX Functions: Part 2
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 8 Manage and Present Data Visually
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Import and TRIM Data from Non-native Files Skill 8.1
Skill 2: Use LEFT, RIGHT, and MID Functions Skill 8.2
Skill 3: Add Legends and Data Series to Charts Skill 8.3
Skill 4: Enhance Charts with Trendlines and Text Boxes Skill 8.4
Skill 5: Modify Excel Worksheet Templates Skill 8.5
Skill 6: Consolidate Worksheet Data Skill 8.6
Skill 7: Construct Dual Axis Charts Skill 8.7
Skill 8: Create and Edit Custom Chart Templates Skill 8.8
Skill 9: Edit and Save Excel File Type Versions Skill 8.9
Skill 10: Send Workbook Files via Email and OneDrive Skill 8.10
More Skills ?11 Modify Charts and Graph Parameters
More Skills ?12 Manage Workbook Versions
More Skills 13 Serialize Numbers Using Functions
More Skills ?14 Modify the Excel Ribbon
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 9 Link and Analyze Data in PivotTables and PivotCharts
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Get and Transform Data Skill 9.1
Skill 2: Create PivotTable Reports Skill 9.2
Skill 3: Change PivotTable Report Views Skill 9.3
Skill 4: Change Calculation Types and Format PivotTable Reports Skill 9.4
Skill 5: Create PivotTable Report Calculated Fields Skill 9.5
Skill 6: Group and Filter PivotTable Reports Skill 9.6
Skill 7: Use Slicers to Filter PivotTable Reports Skill 9.7
Skill 8: Create PivotChart Reports Skill 9.8
Skill 9: Format PivotChart Reports Skill 9.9
Skill 10: Summarize Tables Using GETPIVOTDATA
More Skills ?11 Use Power Pivot to Link Data to Access Databases
More Skills ?12 Create PivotChart Reports Using Power View
More Skills ?13 Add CUBE Functions Using Power Pivot
More Skills ?14 Use the Inquire Add-In
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
My Skills
Visual Skills Check
Skills Challenge 1
Skills Challenge 2
More Skills Assessment
Collaborating with Google
Chapter 10 Secure and Share Workbooks
Introduction
Outcome
Objectives
Skills
More Skills
Skill 1: Modify Excel Options and Work with Comments Skill 10.1
Skill 2: Validate Data with Data Entry Rules Skill 10.2
Skill 3: Track Changes Skill 10.3
Skill 4: Accept and Reject Tracked Changes Skill 10.4
Skill 5: Merge Changes Skill 10.5
Skill 6: Save Workbooks as Web Pages and Embed Data in Web Pages Skill 10.6
Skill 7: Unlock Cells and Protect Worksheets Skill 10.7
Skill 8: Enable and Copy Macros Between Workbooks Skill 10.8
Skill 9: Record Macros Skill 10.9
Skill 10: Write Macros Using VBA Skill 10.10
More Skills ?11 Insert Form Controls
More Skills ?12 Add Macro Buttons to the Quick Access Toolbar
More Skills 13 Prepare Workbooks for Internationalization
More Skills ?14 Assign Macros to Command Buttons
Review
Key Terms
Online Help Skills
Matching
Multiple Choice
Topics for Discussion
Skills Review
Skills Assessment 1
Skills Assessment 2
Problem Solving
My Skills
Visual Skills Check
Critical Thinking
Skills Challenge 1
Skills Challenge 2
Review
More Skills Assessment
Critical Thinking
Collaborating with Google
Capstone Project
Excel Online Project Using Excel Online to Create a Flyer
Glossary
Appendix
Index
