Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | December 1, 2014

    Edward O. Wilson: IMG Edward O. Wilson: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer
Qualifying orders ship free.
$116.70
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
4 Partner Warehouse General- General

More copies of this ISBN

Microsoft Office Excel 2010 Complete (11 Edition)

by

Microsoft Office Excel 2010 Complete (11 Edition) Cover

 

Synopses & Reviews

Publisher Comments:

Timothy and Linda O'Leary and the Computer Information Technology Team at McGraw-Hill Higher Education offer your students a fully integrated learning program with time-tested quality and reliability. Office 2010: A Case Approach offers running case study throughout the text to help students understand the material in a consistent, relevant environment. Through this theme of “Making Office Relevant,” this text helps students understand why they need this course and these skills. Student success is assured through clear step-by-step instruction, plentiful screen captures and conceptual explanations. Each Lab, designed to be covered in 1 hour of class time, combines conceptual coverage with detailed software-specific instructions. Each Lab opens with a running case study that highlights real-world applications of each software program and leads students from problem to solution. The O'Leary Series helps students learn specific applications skills along with those that cross all Office applications, which is especially important in mastering this version of Office. The O'Leary Series also correlates with SimNet Online, our online training and assessment program for Office 2010.

Synopsis:

Launching the Imagination is also available in a comprehensive volume treating 2D design, Creativity and Problem-solving, 3D design, and time-based (4D) design; or in a split volume containing 3D design plus the material on Creativity and Problem-solving.

About the Author

Linda OLeary is a professional trainer in Computing. She has developed training manuals for large corporations, presented seminars on a wide variety of application programs, and has co-authored severalbooks with her husband, Tim.

Table of Contents

O'Leary; Excel 2010: A Case Approach

Lab 1 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

Lab 2 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

Lab 3 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

Lab 4 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

Lab 5 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

Lab 6 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

Product Details

ISBN:
9780077331368
Author:
O'leary, Linda
Publisher:
Career Education
Author:
O'Leary, Linda
Author:
O'Leary Linda
Author:
O'Leary, Linda I.
Author:
O'Leary, Timothy J.
Subject:
Non-Classifiable
Subject:
Personal Computers-General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Publication Date:
December 2010
Binding:
TRADE PAPER
Grade Level:
College/higher education:
Language:
English
Pages:
576
Dimensions:
11.000 x 8.500 in

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Personal Computers » General

Microsoft Office Excel 2010 Complete (11 Edition) New Trade Paper
0 stars - 0 reviews
$116.70 In Stock
Product details 576 pages Career Education - English 9780077331368 Reviews:
"Synopsis" by , Launching the Imagination is also available in a comprehensive volume treating 2D design, Creativity and Problem-solving, 3D design, and time-based (4D) design; or in a split volume containing 3D design plus the material on Creativity and Problem-solving.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.