Product Cover Image

Skills for Success with Excel 2013 Comprehensive, CourseSmart eTextbook

By Kris Townsend

Published by Prentice Hall

Published Date: Sep 26, 2013


For use in the Office Applications course


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


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


Teaching and Learning Experience

This program will provide a better teaching and learning experience—for you and your students. Here’s how:

  • Personalized Learning: MyITLab delivers proven results in helping students succeed, provides engaging experiences that personalize learning, and comes from a trusted partner with educational expertise and a deep commitment to helping students and instructors achieve their goals
  • Designed for a New Generation of Learners: The Skills for Success series is specifically designed to enhance usability and fit the work style of today’s students
  • Support for Students and Instructors: Supplements enhance the learning process for students, while instructor resources are designed to make your life easier.

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

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Skills for Success with Excel 2013 Comprehensive, CourseSmart eTextbook
Format: Safari Book

$38.99 | ISBN-13: 978-0-13-314798-8