Skip to content

GO! with Microsoft Excel 2013 Introductory

Spend $50 to get a free DVD!

ISBN-10: 0133417328

ISBN-13: 9780133417326

Edition: 2014

Authors: Shelley Gaskin, Alicia Vargas

List price: $108.00
Blue ribbon 30 day, 100% satisfaction guarantee!
Rent eBooks
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


For use in the Office Applications course. This book is also suitable for students and individuals seeking an introduction to Microsoft Excel 2013. The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly defined projects. Teaching and Learning Experience This program will provide a better teaching and learning experience–for you and your students. Here’s how: Personalize 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…    
Customers also bought

Book details

List price: $108.00
Copyright year: 2014
Publisher: Pearson Education
Publication date: 5/15/2013
Binding: Comb Bound 
Pages: 448
Size: 9.25" wide x 11.00" long x 1.00" tall
Weight: 2.266
Language: English

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Introduction to Microsoft Office 2013 Features
Note Form
Use File Explorer to Download, Extract, and Locate Files and Folders
Using File Explorer to Download, Extract, and Locate Files and Folders
Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Enter, Edit, and Check the Spelling of Text in an Office 2013 Program
Entering and Editing Text in an Office 2013 Program
Checking Spelling
Perform Commands from a Dialog Box
Performing Commands from a Dialog Box
Using Undo
Create a Folder and Name and Save a File
Creating a Folder and Naming and Saving a File
Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App
Inserting a Footer, Inserting Document Info, and Adding Document Properties
Printing a File and Closing a Desktop App
Open an Existing File and Save It with a New Name
More Knowledge Read-Only
Sign In to Office and Explore Options for a Microsoft Office Desktop App
Perform Commands from the Ribbon and Quick Access Toolbar
More Knowledge Customizing the Ribbon
Apply Formatting in Office Programs
More Knowledge Zooming to Page Width
Compress Files and Use the Microsoft Office 2013 Help System
Install Apps for Office and Create a Microsoft Account
Summary, GO! Learn It Online
Excel Introduction to Microsoft Excel 2013
Creating a Worksheet and Charting Data
Sales Report with Embedded Column Chart and Sparklines
Create, Save, and Navigate an Excel Workbook
Starting Excel, Navigating Excel, and Naming and Saving a Workbook
More Knowledge Creating a New Workbook by Using a Template
Enter Data in a Worksheet
Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell
Using Auto Fill and Keyboard Shortcuts
Aligning Text and Adjusting the Size of Columns
Entering Numbers
Construct and Copy Formulas and Use the SUM Function
Constructing a Formula and Using the SUM Function
Copying a Formula by Using the Fill Handle
Format Cells with Merge & Center, Cell Styles, and Themes
Using Merge & Center and Applying Cell Styles
Formatting Financial Numbers
Changing the Workbook Theme
More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands
Chart Data to Create a Column Chart and Insert Sparklines
Charting Data and Using Recommended Charts to Select and Insert a Column Chart
Using the Chart Tools to Apply Chart Styles
Creating and Formatting Sparklines
Print a Worksheet, Display Formulas, and Close Excel
Creating a Footer and Centering a Worksheet
Adding Document Properties and Printing a Workbook
More Knowledge Inserting a Watermark
Printing a Section of the Worksheet
Changing Page Orientation and Displaying, Printing, and Hiding Formulas
Creating a Sales Report with Embedded Column Chart Using the Excel Web App
Inventory Valuation
More Knowledge Calculate a Percentage if You Know the Total and the Amount
More Knowledge Hiding Rows and Columns
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think
Using Functions, Creating Tables, and Managing Large Workbooks
Inventory Status Report
Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
Using Flash Fill
Moving a Column
Using the SUM and AVERAGE Functions
Using the MEDIAN Function
Using the MIN and MAX Functions
Move Data, Resolve Error Messages, and Rotate Text
Moving Data and Resolving a # # # # # Error Message
Rotating Text
Use COUNTIF and IF Functions and Apply Conditional Formatting
Using the COUNT and COUNTIF Functions
Using the IF Function
Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars
Using Find and Replace
More Knowledge NOW Function Recalculates Each Time a Workbook Opens
Use Date & Time Functions and Freeze Panes
Using the NOW Function to Display a System Date
Freezing and Unfreezing Panes
More Knowledge Freeze Columns or Freeze Both Rows and Columns
Create, Sort, and Filter an Excel Table
Creating an Excel Table and Applying a Table Style
Sorting an Excel Table
More Knowledge Band Rows and Columns in a Table
Filtering an Excel Table and Displaying a Total Row
Clearing Filters and Converting a Table to a Range of Data
View, Format, and Print a Large Worksheet
Modifying and Shrinking the Worksheet View
Splitting a Worksheet Window into Panes
Printing Titles and Scaling to Fit
More Knowledge Scaling for Data That Is Slightly Larger Than the Printed Page
Sort, Filter, and Use Functions in a Table
Weekly Sales Summary
More Knowledge Copying a Worksheet
More Knowledge Clearing an Entire Worksheet
More Knowledge Hide Worksheets
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think
Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
Enterprise Fund Pie Chart
Chart Data with a Pie Chart
Calculating Values for a Pie Chart
Creating a Pie Chart in a Chart Sheet
Format a Pie Chart
Formatting a Chart Title by Applying a WordArt Style and Changing Font Size
Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels
Formatting a Data Series with 3-D Effects
Formatting a Data Series with a Shadow Effect
Rotating a Pie Chart by Changing the Angle of the First Slice
Exploding and Coloring a Pie Slice
Formatting the Chart Area
Edit a Workbook and Update a Chart
Editing a Workbook and Updating a Chart
Use Goal Seek to Perform What-If Analysis
Using Goal Seek to Perform What-If Analysis
Preparing and Printing a Workbook with a Chart Sheet
Creating a JPEG Photo of a Chart and Uploading It to a OneNote Web App Notebook
Tourism Spending Projection with Line Chart
More Knowledge Use of Parentheses in a Formula
More Knowledge Percentage Calculations
More Knowledge Percent Increase or Decrease
More Knowledge Resizing a Chart
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think
Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
Amortization Schedule and -Merchandise Costs
Use Financial Functions
Inserting the PMT Financial Function
Use Goal Seek
Using Goal Seek to Produce a Desired Result
Using Goal Seek to Find an Increased Period
Create a Data Table
Designing a Two-Variable Data Table
Using a Data Table to Calculate Options
Use Defined Names in a Formula
Defining a Name
Inserting New Data into a Named Range
Creating a Defined Name by Using Row and Column Titles
Using Defined Names in a Formula
Lookup Form and Revenue Report
More Knowledge Creating Validation Messages
More Knowledge
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think
Managing Large Workbooks and Using Advanced Sorting and Filtering
Large Worksheet for a Class Schedule
Navigate and Manage Large Worksheets
Using the Go To Special Command
Hiding Columns
Using the Go To Command
Arranging Multiple Workbooks and Splitting Worksheets
Enhance Worksheets with Themes and Styles
Changing and Customizing a Workbook Theme
Creating and Applying a Custom Table Style
Format a Worksheet to Share with Others
Previewing and Modifying Page Breaks
Repeating Column or Row Titles
Inserting a Hyperlink in a Worksheet
Modifying a Hyperlink
Save Excel Data in Other File Formats
Viewing and Saving a Workbook as a Web Page
Saving Excel Data in CSV File Format
Saving Excel Data as a PDF or XPS File
More Knowledge Converting a Tab Delimited Text File to a Word Table
Sorted, Filtered, and Outlined Database
More Knowledge A Custom List Remains Available for All Workbooks in Excel
More Knowledge Using Wildcards
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think
Creating Charts, Diagrams, and Templates
Attendance Charts and Diagrams
Create and Format Sparklines and a Column Chart
Creating and Formatting Sparklines
Creating a Column Chart
More Knowledge Sizing Handles and Selection Handles
Changing the Display of Chart Data
More Knowledge Changing the Data in a Chart
Editing and Formatting the Chart Title
Adding, Formatting, and Aligning Axis Titles
Editing Source Data
Formatting the Chart Floor and Chart Walls
Create and Format a Line Chart
Creating a Line Chart
Changing a Chart Title
Changing the Values on the Value Axis
Formatting the Plot Area and the Data Series
Inserting a Trendline
Create and Modify a SmartArt Graphic
Creating a Process SmartArt Graphic
Modifying the Diagram Style
Create and Modify an Organization Chart
Creating and Modifying a SmartArt Organization Chart
Adding Effects to a SmartArt Graphic
Preparing Worksheets Containing Charts and Diagrams for Printing
Order Form Template
More Knowledge Setting the Default Font for New Worksheets
More Knowledge Modifying a Template
Summary, GO! Learn It Online, GO! For Job Success
Skills Review
Mastering Excel
GO! Think