GO! with Microsoft Excel 2010, Comprehensive

ISBN-10: 0135098211

ISBN-13: 9780135098219

Edition: 2011

List price: $94.10
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $94.10
Copyright year: 2011
Publisher: Pearson Education, Limited
Publication date: 8/9/2010
Binding: Mixed Media
Pages: 816
Size: 9.00" wide x 10.00" long x 1.25" tall
Weight: 3.432
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.

GO! with Excel 2010 Contents
Common Features
Using the Common Features of Microsoft Office 2010
PowerPoint File
Use Windows Explorer to Locate Files and Folders
Using Windows Explorer to Locate Files and Folders
Locate and Start a Microsoft Office 2010 Program
Locating and Starting a Microsoft Office 2010 Program
Enter and Edit Text in an Office 2010 Program
Entering and Editing Text in an Office 2010 Program
Perform Commands from a Dialog Box
Performing Commands from a Dialog Box
Create a Folder, Save a File, and Close a Program
Creating a Folder, Saving a File, and Closing a Program
Add Document Properties and Print a File
Adding Document Properties and Printing a File
Word File
Open an Existing File and Save it with a New Name
Opening an Existing File and Saving it with a New Name
Explore Options for an Application
Viewing Application Options
Perform Commands from the Ribbon
Performing Commands from the Ribbon
Minimizing and Using the Keyboard to Control the Ribbon
Apply Formatting in Office Programs
Formatting and Viewing Pages
Formatting Text
Using the Office Clipboard to Cut, Copy, and Paste
Viewing Print Preview and Printing a Word Document
Use the Microsoft Office 2010 Help System
Using the Microsoft Office 2010 Help System in Excel
Compress Files
Compressing Files
Excel
Creating a Worksheet and Charting Data
Sales Report with Embedded Column Chart and Sparklines
Create, Save, and Navigate an Excel Workbook
Starting Excel and Naming and Saving a Workbook
Navigating a Worksheet and a Workbook
Enter Data in a Worksheet
Entering Text and Using AutoComplete
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 and Cell Styles
Using Merge & Center and Applying Cell Styles
Formatting Financial Numbers
Chart Data to Create a Column Chart and Insert Sparklines
Charting Data in a Column Chart
Creating and Formatting Sparklines
Print, Display Formulas, and Close Excel
Changing Views, Creating a Footer, and Using Print Preview
Deleting Unused Sheets in a Workbook
Printing a Worksheet
Displaying, Printing, and Hiding Formulas
Inventory Valuation
Check Spelling in a Worksheet
Checking Spelling in a Worksheet
Enter Data by Range
Entering Data by Range
Construct Formulas for Mathematical Operations
Using Arithmetic Operators
Copying Formulas Containing Absolute Cell References
Edit Values in a Worksheet
Editing Values in a Worksheet
Formatting Cells with the Percent Style
Format a Worksheet
Inserting and Deleting Rows and Columns
Adjusting Column Widths and Wrapping Text
Using Functions, Creating Tables, and Managing Large Workbooks
Inventory Status Report
Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
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 COUNTIF Function
Using the IF Function
Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars
Using Find and Replace
Use Date & Time Functions and Freeze Panes
Using the NOW Function to Display a System Date
Freezing and Unfreezing Panes
Create, Sort, and Filter an Excel Table
Creating an Excel Table
Sorting and Filtering an Excel Table
Converting a Table to a Range of Data
Format and Print a Large Worksheet
Printing Titles and Scaling to Fit
Weekly Sales Summary
Navigate a Workbook and Rename Worksheets
Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets
Enter Dates, Clear Contents, and Clear Formats
Entering and Formatting Dates
Clearing Cell Contents and Formats
Copy and Paste by Using the Paste Options Gallery
Copying and Pasting by Using the Paste Options Gallery
Edit and Format Multiple Worksheets at the Same Time
Grouping Worksheets for Editing
Formatting and Constructing Formulas on Grouped Worksheets
Create a Summary Sheet with Column Sparklines
Constructing Formulas that Refer to Cells in Another Worksheet
Changing Values in a Detail Worksheet to Update a Summary Worksheet
Inserting Sparklines
Format and Print Multiple Worksheets in a Workbook
Moving and Formatting Worksheets in a Workbook
Printing All the Worksheets in a Workbook
Analyzing Data with Pie Charts, Line Charts, and What-If
Analysis Tools
Budget Pie Chart Objective 1 Chart Data with a Pie Chart
Creating a Pie Chart and a Chart Sheet
Format a Pie Chart
Applying Percentages to Labels in a Pie Chart
Formatting a Pie Chart with 3-D
Rotating a Pie Chart
Exploding and Coloring a Pie Slice
Formatting the Chart Area
Inserting a Text Box in a Chart
Edit a Workbook and Update a Chart
Editing a Workbook and Updating a Chart
Inserting WordArt in a Worksheet
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
Growth Projection with Line Chart
Design a Worksheet for What-If Analysis
Using Parentheses in a Formula to Calculate a Percentage Rate of Increase
Using Format Painter and Formatting as You Type
Calculating a Value After an Increase
Answer What-If Questions by Changing Values in a Worksheet
Answering What-If Questions and Using Paste Special
Chart Data with a Line Chart
Inserting Multiple Rows and Creating a Line Chart
Formatting Axes in a Line Chart
Formatting the Chart and Plot Areas
Preparing and Printing Your Worksheet
Business Running Case 1: Excel Chapters 1 3
Use Financial and Lookup Functions, Define Names, and Validate Data
Amortization Schedule
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
Quarterly Cost Report and Lookup Form
Define Names
Defining a Name
Inserting New Data into a Named Range
Changing A Defined Name
Creating a Defined Name by Using Row and Column Titles
Use Defined Names in a Formula
Using Defined Names in a Formula
Use Lookup Functions
Defining a Range of Cells for a Lookup Function
Inserting the VLOOKUP Function
Validate Data
Creating a Validation List
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
Sorted, Filtered, and Outlined Database
Use Advanced Sort Techniques
Sorting on Multiple Columns
Sorting by Using a Custom List
Use Custom and Advanced Filters
Filtering by Format and Value Using AutoFilter
Filtering by Custom Criteria Using AutoFilter
Inserting the Sheet Name and Page Numbers in a Footer
Filtering by Using Advanced Criteria
Extracting Filtered Rows
Subtotal, Outline, and Group a List of Data
Subtotaling, Outlining, and Grouping a List of Data
Creating Charts, Diagrams, and Templates
Attendance Charts and Diagrams
Create and Format Sparklines and a 3-D Column Chart
Creating and Formatting Sparklines
Creating a 3-D Column Chart
Changing the Display of Chart Data
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
Deleting a Legend and 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 3
Adding Effects to a SmartArt Graphic
Preparing Worksheets Containing Charts and Diagrams for Printing
Order Form Template
Create an Excel Template
Entering Template Text
Formatting a Template
Entering Template Formulas
Inserting and Modifying an Image
Inserting and Modifying a WordArt Image
Saving a File as a Template
Protect a Worksheet
Protecting a Worksheet
Create a Worksheet Based on a Template
Creating a Worksheet Based on a Template
Business Running Case 2: Excel Chapters 4 6
Creating PivotTable and PivotChart Reports and Auditing Worksheets
PivotTable and PivotChart
Create a PivotTable Report
Creating a PivotTable Report
Adding Fields to a PivotTable Report
Use Slicers and Search Filters
Using a Slicer to Filter a PivotTable
Clearing Filters and Filtering by Using the Search Box
Modify a PivotTable Report
Rearranging a PivotTable Report
Displaying PivotTable Report Details in a New Worksheet
Displaying PivotTable Data on Separate Pages
Changing Calculations in a PivotTable Report
Formatting a PivotTable Report
Updating PivotTable Report Data
Create a PivotChart Report
Creating a PivotChart Report from a PivotTable Report
Modifying a PivotChart Report
Revenue Report for Formula Auditing
Trace Precedents and Dependents to Audit Worksheet Formulas
Using the Trace Precedents Command
Using the Trace Dependents Command
Using the Trace Dependents Command
Using the Trace Error Command
Use Error Checking to Audit Worksheet Formulas
Using Error Checking
Circling Invalid Data
Use the Watch Window to Monitor Cell Values
Using the Watch Window to Monitor Changes
Using the Data Analysis, Solver, and Scenario Features
Sales Analysis
Calculate a Moving Average
Creating a Custom Number Format
Calculating a Moving Average
Modifying the Moving Average Chart
Calculating Growth Based on a Moving Average
Project Income and Expenses
Projecting Income and Expenses
Determine a Break-Even Point
Charting the Break-Even Point With a Line Chart
Staffing Analysis
Use Solver
Installing Solver
Understanding a Solver Worksheet
Using Solver
Evaluate Complex Formulas
Evaluating Complex Formulas
Create Scenarios
Creating a Scenario Using the Scenario Manager
Creating a Scenario Using Solver
Creating a Scenario Summary
Using Macros and Visual Basic for Applications
Travel Expenses
Record a Macro
Adding the Developer Tab to the Ribbon
Changing the Macro Security Settings in Excel
Unprotecting a Workbook
Recording a Macro
Assign a Macro to a Button on the Quick Access Toolbar
Adding a Button to the Quick Access Toolbar
Testing the Macro Button
Modify a Macro
Changing the Visual Basic Code
VBA Procedure
Write a VBA Procedure to Use an ActiveX Control
Inserting ActiveX Controls
Changing the Properties of an ActiveX Control
Writing a VBA Procedure for a Command Button
Modifying a VBA Procedure
Testing the VBA Procedure and the ActiveX Control
Restore Initial Settings
Removing the Quick Access Toolbar Button and the Macro
Business Running Case 3: Excel Chapters 7 9
External Data, Database Functions, and Side-by-Side
Tables
Medical Center Information
Get External Data into Excel
Importing Information into Excel from an Access Database
Importing Information into Excel from a Web Page
Importing Information into Excel from a Text File
Importing Information into Excel from an XML File
Create a Query and Use the Query Wizard to Sort and Filter
Creating a Query and Filtering and Sorting Data by Using the Query Wizard
Converting a Range and Formatting Imported Data
Use DAVERAGE and DSUM Database Functions
Using the DAVERAGE Database Function
Using the DSUM Database Function
Use DCOUNT and DGET Database Functions
Using DCOUNT
Using DGET
Office Equipment Inventory
Insert a Second Table into a Worksheet
Inserting a Second Table into a Worksheet
Sorting Side-by-Side Tables
Apply Conditional Formatting to Side-by-Side Tables
Applying Icon Sets to Side-by-Side Tables
Insert a Screenshot
Inserting a Screen Shot
Create Custom Headers and Footers
Creating Custom Headers and Footers
Collaborating with Others and Preparing a Workbook for
Distribution
Summer Schedule
Create a Shared Workbook
Locating and Modifying Workbook Properties
Activating Track Changes to Create a Shared Workbook
Track Changes Made to a Workbook
Making a Copy of a Shared Workbook
Making Changes to a Shared Workbook
Making Changes to a Copy of the Shared Workbook
Merge Workbooks and Accept Changes
Merging Revisions
Accepting or Rejecting Tracked Changes
Removing the Shared Designation, Resetting the User Name, and Removing a Command from the Quick Access Toolbar
Adding a Signature Line
Distributed Workbook
Prepare a Final Workbook for Distribution
Ensuring Backward-Compatibility in a Workbook
Inspecting a Document
Encrypting a Workbook
Marking a Workbook as Final
Upload a Workbook to SkyDrive
Uploading a Workbook to SkyDrive
Business Running Case 4: Excel Chapters 10 11
Glossary
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×