did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780470577646

Teach Yourself VISUALLY Excel 2010

by
  • ISBN13:

    9780470577646

  • ISBN10:

    0470577649

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2010-04-26
  • Publisher: Visual
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $29.99 Save up to $0.90
  • Buy New
    $29.09

    THIS IS A HARD-TO-FIND TITLE. WE ARE MAKING EVERY EFFORT TO OBTAIN THIS ITEM, BUT DO NOT GUARANTEE STOCK.

Supplemental Materials

What is included with this book?

Summary

See your way to super spreadsheets with Excel 2010 and this visual guide!

If you're always hearing about the cool things that Excel can do, here's your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010's new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster!

-Provides a clear look at Excel 2010, the newest version of the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite

-Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop

-Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks

-Includes practical examples, tips, and advice on how to use all the tools more effectively

Get the very most out of Excel 2010 with this easy-to-follow guide!

Are you a visual learner? Do you prefer instructions that show you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 2010 in no time.

You'll learn to:

-Customize the Ribbon

-Enter and edit cell data

-Build formulas and functions

-Format a range or chart

-Analyze Excel data

-Insert worksheet graphics

-Two-page lessons break big topics into bite-sized modules

-Succinct explanations walk you through step by step

-Full-color screen shots demonstrate each task

-Helpful sidebars offer practical tips and tricks

Author Biography

Paul McFedries is is a technical writer who has been authoring computer books since 1991. He has more than 60 books to his credit, which together have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Microsoft Office 2008 for Mac, Excel 2010 Visual Quick Tips, and Excel 2010 PivotTable and PivotCharts Visual Blueprint.
Paul also runs Word Spy, a Web site dedicated to tracking new words and phrases (see www.wordspy.com). Please visit Paul’s personal Web site at www.mcfedries.com.

Table of Contents

Working with Excel
Getting to Know Excel
Start Excel
Tour the Excel Window
Work with Excel's Ribbon
Work with Excel's Galleries
Customize the Quick Access Toolbar
Customize the Ribbon
Work with Smart Tags
Change the View
Configure Excel Options
Add Excel to the Windows 7 Taskbar
Quit Excel
Entering and Editing Excel Data
Learning the Layout of a Worksheet
Understanding the Types of Data You Can Use
Enter Text into a Cell
Enter a Number into a Cell
Enter a Date or Time into a Cell
Insert a Symbol
Edit Cell Data
Delete Data from a Cell
Working with Excel Ranges
Select a Range
Fill a Range with the Same Data
Fill a Range with a Series of Values
Move or Copy a Range
Insert a Row or Column
Insert a Cell or Range
Delete Data from a Range
Delete a Range
Hide a Row or Column
Freeze Rows or Columns
Merge Two or More Cells
Transpose Rows and Columns
Working with Range Names
Understanding the Benefits of Using Range Names
Define a Range Name
Use Worksheet Text to Define a Range Name
Navigate a Workbook Using Range Names
Change a Range Name
Delete a Range Name
Paste a List of Range Names
Formatting Excel Ranges
Change the Font and Font Size
Apply Font Effects
Change the Font Color
Align Text Within a Cell
Center Text Across Multiple Columns
Rotate Text Within a Cell
Add a Background Color to a Range
Apply a Number Format
Change the Number of Decimal Places Displayed
Apply an AutoFormat to a Range
Apply a Conditional Format to a Range
Apply a Style to a Range
Change the Column Width
Change the Row Height
Wrap Text Within a Cell
Add Borders to a Range
Copy Formatting from One Cell to Another
Building Formulas and Functions
Understanding Excel Formulas
Build a Formula
Understanding Excel Functions
Add a Function to a Formula
Add a Row or Column of Numbers
Build an AutoSum Formula
Add a Range Name to a Formula
Reference Another Worksheet Range in a Formula
Move or Copy a Formula
Switch to Absolute Cell References
Toggle the Formula Bar On and Off
Troubleshoot Formula Errors
Manipulating Excel Worksheets
Navigate a Worksheet
Rename a Worksheet
Create a New Worksheet
Move a Worksheet
Copy a Worksheet
Delete a Worksheet
Change the Gridline Color
Toggle Worksheet Gridlines On and Off
Toggle Worksheet Headings On and Off
Set the Worksheet Tab Color
Set the Worksheet Background
Zoom In On or Out of a Worksheet
Split a Worksheet into Two Panes
Hide and Unhide a Worksheet
Dealing with Excel Workbooks
Create a New Blank Workbook
Create a New Workbook from a Template
Save a Workbook
Open a Workbook
Arrange Workbook Windows
Find Text in a Workbook
Replace Text in a Workbook
Check Spelling and Grammar
Close a Workbook
Formatting Excel Workbooks
Modify the Workbook Colors
Set the Workbook Fonts
Choose Workbook Effects
Apply a Workbook Theme
Add a Workbook Header
Add a Workbook Footer
Printing Excel Workbooks
Adjust the Workbook Margins
Change the Page Orientation
Insert a Page Break
Choose a Paper Size
Set the Print Area
Configure Titles to Print on Each Page
Preview the Printout
Print a Workbook
Analyzing Excel Data
Sort a Range
Filter a Range
Set Data Validation Rules
Convert a Range to a Table
Create a Data Table
Summarize Data with Subtotals
Group Related Data
Analyze Data with Goal Seek
Analyze Data with Scenarios
Create a PivotTable
Load Excel's Analysis ToolPak
Visualizing Data with Excel Charts
Examining Chart Elements
Understanding Chart Types
Create a Chart
Add Chart Titles
Add Data Labels
Position the Chart Legend
Display Chart Gridlines
Display a Data Table
Change the Chart Layout and Style
Select a Different Chart Type
Change the Chart Source Data
Move or Resize a Chart
Add a Sparkline to a Cell
Formatting Excel Charts
Format Chart Elements
Customize a Chart Element Background
Set a Chart Element's Outline
Add Effects to a Chart Element
Apply a Style to a Chart Element
Apply a WordArt Style to Chart Text
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program