Skills for Success with Excel 2013 Comprehensive

by Townsend, Kris; Adkins, Margo Chaney; Hain, Catherine

• ISBN13: 9780133148008
• ISBN10: 0133148009
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2013-08-19
• Publisher: Pearson

Summary

For use in the Office Applications course or readers that need to get started with Microsoft Excel 2013.

 

Skills for Success is the Microsoft Office 2013 textbook that recognizes how readers learn today!

 

The Office Skills text that was designed with today's students–and the way today's readers use an Office textbook–in mind. 

 

Note: This is the standalone book, if you want the Book and Access Card order the ISBN below:

 

0133897486 / 9780133897487 Skills for Success with Excel 2013 Comprehensive, MyITLab with eText and Access Card

 

Package consists of:   

0133148009 / 9780133148008 Skills for Success with Excel 2013 Comprehensive

0133775046 / 9780133775044 MyITLab with Pearson eText -- Access Card -- for Skills for Success with Office 2013

 

Table of Contents

Common Features of Office 2013

Skill 1 Start Office Applications

Skill 2 Create Documents from Templates

Skill 3 Type and Edit Text

Skill 4 Save Files in New Folders

Skill 5 Apply Themes and Format Text

Skill 6 Preview and Print Documents

Skill 7 Open and Save Student Data Files

Skill 8 Edit and Format Spreadsheets

Skill 9 Copy and Paste and Format Slides

Skill 10 Format Access Reports

Skill 11 Store Documents on SkyDrive

Skill 12 Use Office Help

Skill 13 Send Files as E-mail Attachments

Skill 14 Optimize Office for Tablets

Web App Project: Share SkyDrive Files and Folders

Chapter 1 Create Workbooks with Excel 2013

1.1 Create and Save Workbooks

1.2 Enter Data and Merge and Center Titles

1.3 Construct Addition and Subtraction Formulas

1.4 Construct Multiplication and Division Formulas

1.5 Adjust Column Widths and Apply Cell Styles

1.6 Insert the SUM Function

1.7 AutoFill Formulas and Data

1.8 Format, Edit, and Check Spelling

1.9 Insert Footers and Adjust Page Settings

1.10 Display Formulas and Print Worksheets

More Skills 11 Create Workbooks from Templates

More Skills 12 Insert Names into Formulas

More Skills 13 Create Templates

More Skills 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

More Skills 11 Insert, Edit, and Delete Comments

More Skills 12 Change Chart Types

More Skills 13 Copy Excel Data to Word Documents

More Skills 14 Fill Data with Flash Fill

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

More Skills 11 Create Organization Charts

More Skills 12 Create Line Charts

More Skills 13 Set and Clear Print Areas

More Skills 14 Create, Edit, and Delete Hyperlinks

Chapter 4 More Functions and Excel Tables

Skill 1 Use the TODAY, NOW, and COUNT Functions

Skill 2 Use the IF Function

Skill 3 Move Ranges with Functions, Add Borders, and Rotate Text

Skill 4 Apply Conditional Formats with Custom Formats and Data Bars

Skill 5 Insert Sparkines

Skill 6 Use Find and Replace

Skill 7 Freeze and Unfreeze Panes

Skill 8 Create and Sort Excel Tables

Skill 9 Use the Search Filter in Excel Tables

Skill 10 Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets

More Skills 11 Apply Conditional Color Scales with Top and Bottom Rules, and Clear Rules

More Skills 12 Use the Payment (PMT) Function

More Skills 13 Create PivotTable Reports

More Skills 14 Use Goal Seek

Web App Project: Create Excel Web App Workbooks

Chapter 5 Format Cells and Worksheets

5.1 Insert Symbols and Create Custom Number Formats

5.2 Format Cells with the Format Painter

5.3 Apply Icon Sets as Conditional Formatting

5.4 Insert Formulas into Conditional Formatting Rules

5.5 Insert and Delete Rows, Columns, and Cells

5.6 Modify Cell Backgrounds and Borders

5.7 Create and Apply Custom Cell Styles

5.8 Customize, Save, and Apply Themes

5.9 Add Watermarks and Modify Background Colors

5.10 Hide Gridlines and Column and Row Headings

More Skills 11 Copy Styles Between Workbooks

More Skills 12 Draw Borders

More Skills 13 Convert Comma-Separated Text into Columns

More Skills 14 Create Screenshots

Chapter 6 More Functions and Formulas

6.1 Modify Text Using Text Functions

6.2 Use Paste Options to Change Underlying Values

6.3 Look Up Data Using Lookup Functions

6.4 Edot Conditions in Logical Functions

6.5 Apply COUNTA and COUNTIF Functions

6.6 Perform What-If Analyses Using the Scenario Manager

6.7 Estimate Future Value

6.8 Insert Array Formulas

6.9 Calculate Conditional Sums

6.10 Calculate Conditional Averages

More Skills 11 Use Web Functions

More Skills 12 Use Solver

More Skills 13 Delete Duplicate Records

More Skills 14 Update Data with External Data Links

Chapter 7 Work With Data and Audit Formulas

7.1 Import Data from Text Files

7.2 Apply Advanced AutoFilters

7.3 Sort Data Based on Using Conditional Formatting

7.4 Sort Data and Use the Subtotal Tool to Summarize Data

7.5 Trace and Evaluate Formulas

7.6 Audit Formulas Using Cell Watch

7.7 Create One-Variable Data Tables

7.8 Create Two-Variable Data Tables

7.9 Generate Custom Table Quick Styles

7.10 Convert Tables to Ranges

More Skills 11 Create Amortization Tables

More Skills 12 Use the ROUND Function

More Skills 13 Use Information Functions

More Skills 14 Sort Tables Based on Multiple Criteria

Chapter 8 Manage and Present Data Visually

8.1 Import and TRIM data from Non-Native Files

8.2 Use LEFT, RIGHT, and MID Functions

8.3 Add Legends and Data Series to Charts

8.4 Enhance Charts with Trendlines and Text Boxes

8.5 Modify Excel Worksheet Templates

8.6 Consolidate Worksheet Data

8.7 Construct Dual Axis Charts

8.8 Create and Edit Custom Chart Templates

8.9 Edit and Save Excel File Type Versions

8.10 Send Workbook Files via E-mail and SkyDrive

More Skills 11 Modify Charts and Graph Parameters

More Skills 12 Insert and Edit SmartArt Charts

More Skills 13 Embed Worksheet Data in a Web Page

More Skills 14 Present a Workbook Online

Chapter 9 Link and Analyze Data in PivotTables and PivotCharts

9.1 Use PowerPivot to Link Data with Access Databases

9.2 Create PivotTable Reports and Change PivotTable Report Views

9.3 Change Calculation Types and Format PivotTable Reports

9.4 Create PivotTable Report Calculated Fields

9.5 Use Cube Functions to Create Calculated Fields

9.6 Group and Filter PivotTable Reports

9.7 Use Slicers to Filter PivotTable Report

9.8 Create PivotChart Reports from External Data Sources

9.9 Use Power View to Create PivotChart Reports from PivotTable Reports

9.10 Change PivotChart Report Types and Print PivotChart Reports

More Skills 11 Import and Export XML data

More Skills 12 Create Web Queries and Clear Hyperlinks

More Skills 13 Use Strict Converter

More Skills 14 Use Inquire Add-in

Chapter 10 Secure and Share Workbooks

10.1 Modify Excel Options and Word with Comments

10.2 Validate Data with Data Entry Rules

10.3 Track Changes

10.4 Accept and Reject Tracked Changes

10.5 Merge Changes

10.6 Use the Document Inspector to Remove Personal Information

10.7 Save Workbooks as Web Pages

10.8 Unlock Cells and Protect Worksheets

10.9 Record Macros

10.10 Write Macros Using VBA

More Skills 11 Insert Form Controls

More Skills 12 Set Form Properties

More Skills 13 Assign a Macro to a Command Button

More Skills 14 Add a Macro Button to the Quick Access Toolbar