Microsoft� Office Excel 2010 A Case Approach

ISBN-10: 0077331362

ISBN-13: 9780077331368

Edition: 2011

Authors: Linda I. O'Leary, Timothy O'Leary

List price: $41.99
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


what's this?
Rush Rewards U
Members Receive:
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
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

Book details

List price: $41.99
Copyright year: 2011
Publisher: McGraw-Hill Higher Education
Publication date: 7/1/2010
Binding: Paperback
Pages: 672
Size: 8.25" wide x 10.75" long x 1.00" tall
Weight: 4.048
Language: English

Creating and Editing a Worksheet
Creating New Worksheets
Developing a Worksheet
Exploring the Excel Window
Exploring the Workbook Window
Moving around the Worksheet
Entering and Editing Data
Adding Text Entries
Clearing an Entry
Editing an Entry
Using AutoCorrect
Adding Number Entries
Modifying Column Widths
Dragging the Column Boundary
Using a Specified Value
Using AutoFit
Saving, Closing, and Opening Workbooks
Saving a New Workbook
Closing a Workbook
Opening an Existing Workbook
Using Proofing Tools
Checking Spelling
Using the Thesaurus
Copying and Pasting Cell Contents
Copying and Pasting Data
Selecting a Range
Using the Fill Handle
Inserting Copied Cell Content
Cutting and Pasting Data
Creating Formulas
Entering Formulas
Copying Formulas with Relative References
Summarizing Data
Using Pointing to Enter a Formula
Recalculating the Worksheet
Inserting and Deleting Rows and Columns
Inserting Rows
Deleting Columns
Formatting Cells and Cell Content
Changing Cell Alignment
Indenting Cell Content
Merging Cells
Changing Fonts and Font Sizes
Applying Character Effects
Clearing Formats
Using Format Painter
Formatting Numbers
Adding Font Color
Adding Fill Color
Adding and Removing Cell Borders
Hiding and Unhiding Rows and Columns
Creating a Basic Chart
Specifying Data to Chart
Selecting Chart Type
Formatting Values as a Date
Documenting a Workbook
Setting File Properties
Previewing and Printing a Worksheet
Previewing the Worksheet
Printing the Worksheet
Displaying and Printing Formulas
Changing Worksheet Orientation and Scaling Content
Enhancing the Worksheet with Graphics and Charts
Inserting and Formatting Illustrations
Inserting a Picture from Files
Inserting an Illustration from Clip Art
Deleting a Graphic
Sizing a Graphic
Enhancing the Graphic with a Picture Style
Using Themes
Selecting a Theme
Customizing a Theme
Saving a Custom Theme
Using Cell Styles
Applying Themed Cell Styles
Applying Heading and Total Cell Styles
Modifying Cell Styles
Applying a Number Cell Style
Creating Charts
Selecting the Data to Chart
Selecting the Chart Type
Moving and Sizing a Chart
Applying Chart Layouts
Applying Chart Styles
Adding Chart Labels
Changing the Chart Location
Creating a Multiple Data Series Chart
Changing the Data Source
Changing the Chart Type: Line, Bar, Area, Stacked
Moving the Legend
Formatting Chart Elements
Adding and Formatting Data Labels
Changing Worksheet Data
Creating and Formatting a Pie Chart
Selecting the Pie Chart Data
Adding Titles and Data Labels
Exploding and Rotating the Pie
Applying Color and Texture
Preparing the Worksheet and Charts for Printing
Scaling the Worksheet
Adding Predefined Headers and Footers
Printing the Entire Workbook
Aligning a Sheet on a Page
Managing and Analyzing a Workbook
Correcting Formula Errors
Identifying Formula Errors
Using Absolute References
Creating a Second Worksheet
Copying Worksheets
Renaming Sheets and Coloring Sheet Tabs
Filling a Series
Creating a 3-D Reference
Hiding Gridlines and Headings
Deleting and Moving Worksheets
Finding and Replacing Information
Finding Information
Replacing Information
Saving to a New Folder
Managing Large Worksheets
Going to a Specific Cell
Splitting Windows
Freezing Panes
Watching Cells
Forecasting Values
Performing What-If Analysis Manually
Using Goal Seek
Using Conditional Formatting
Creating Cell Rules
Using Rules Manager
Applying Top-Bottom Rules, Data Bars, Color Scales and Icon Set Conditional Formatting
Using Sparklines
Creating a Sparkline
Enhancing a Sparkline
Customizing Print Settings
Controlling Page Breaks
Adding a Custom Header and Footer
Printing Selected Sheets
Printing Selected Areas
Working Together 1: Linking and Embedding between Word 2010 and Excel 2010
Sharing Information between Applications
Copying between Excel and Word
Linking between Applications
Updating a Linked Object
Editing Links
Embedding an Object
Updating an Embedded Object
Deciding When to Link or Embed Objects
Using Solver, Creating Templates, and Evaluating Scenarios
Analyzing the Worksheet
Using Solver
Creating an Answer Report
Creating a Custom Template
Protecting the Worksheet
Protecting the Workbook
Saving the Template
Using the Template
Working with Multiple Workbooks
Opening a Second Workbook File
Arranging Workbook Windows
Hiding Workbooks and Worksheets
Arranging Worksheet Windows
Linking Workbooks
Updating Linked Data
Using Scenarios
Creating Scenarios
Showing and Editing Scenarios
Creating a Scenario Report
Creating SmartArt
Adding Shapes to SmartArt
Adding text to a Smart Art Graphic
Formatting the SmartArt Graphic
Unhiding Sheets and Workbooks
Using Data Tables, Using Lookup and If Functions, and Designing Forms
Calculating a Loan Payment
Using the PMT Function
Creating a Data Table
Setting Up the Data Table
Defining the Data Table
Adding Shapes
Creating a Text Box
Adding a Shape Style
Creating an Arrow Shape
Deleting Shapes
Rotating Objects and Sizing Elements
Splitting Cell content
Looking Up Values in a List
Creating a Form
Using Named Ranges
Naming Cell References
Using Name Manager
Using the IF Function
Using a Drop-Down List
Creating a Drop-Down List
Testing a Drop-Down List
Finalizing the Form
Adding Comments
Editing Comments
Viewing All Comments
Preparing the Workbook for Use
Protecting Worksheet Elements
Marking a Workbook as Final
Adding a Digital Signature
Protecting a Workbook File
Creating and Working with Tables
Creating a Table
Adding Field Names
Defining the Table Range
Adding and Editing Data in a Table
Entering Records
Inserting Rows
Using and Editing a Hyperlink Entry
Modifying a Table
Inserting Table Columns
Inserting Table Rows
Formatting the Table
Applying Table Styles
Using Special Cell Formats
Ensuring Data Integrity
Restricting Data Using Data Validation
Testing Data Validation
Sorting Data
Sorting on a Single Field
Sorting on Multiple Fields
Sorting on Cell Attributes
Filtering Data
Filtering on a Single Criterion
Filtering on Multiple Criteria
Creating a Custom Filter
Filtering for Unique Values and Removing Duplicates
Summarizing Data
Displaying a Total Row
Creating a Calculated Column
Grouping and Outlining Data
Grouping Data
Grouping Data and Calculating Subtotals
Printing a Summary Report
Creating a PivotTable Report
Creating a PivotChart Report
Hyperlinking Workbook Files
Creating a Hyperlink to another Workbook
Changing the Hyperlink ScreenTip
Using the Hyperlink to Open the Workbook
Restoring the Table
Working Together 2: Importing Access Data, Sharing Workbooks, and Creating a Web Page
Importing Data
Importing Access Table Data to Excel
Analyzing the Table
Collaborating on Worksheet Data
Comparing and Merging Documents
Accepting and Rejecting Changes
Creating a Web page
Previewing the Web Page
Adding a Worksheet Background
Saving the Worksheet as a Web Page
Making the Web Page Public
Adding a Watermark
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.