Teach Yourself VISUALLY Excel 2007 / Edition 1

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 92%)
Other sellers (Paperback)
  • All (16) from $1.99   
  • New (2) from $24.93   
  • Used (14) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2008

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.


Ships from: BAY SHORE, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2008

Feedback rating:


Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


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 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including:
* Using the Ribbon and galleries
* Entering data and resizing columns
* Applying formulas and functions
* Formatting worksheets
* Adding clip art and 3D effects
* Interpreting data with charts
* Helpful sidebars offer practical tips and tricks
* Succinct explanations walk you through step by step
* Full-color screen shots demonstrate each task
* Two-page lessons break big topics into bite-sized modules
Read More Show Less

Product Details

  • ISBN-13: 9780470045954
  • Publisher: Wiley
  • Publication date: 12/6/2006
  • Series: Teach Yourself VISUALLY (Tech) Series, #41
  • Edition number: 1
  • Pages: 304
  • Product dimensions: 9.14 (w) x 7.42 (h) x 0.64 (d)

Meet the Author

Nancy C. Muir is an award-winning author who has written over 50 books on topics ranging from desktop applications to online safety and distance learning. She has also contributed articles to magazines on topics such as distance learning and home design. Prior to her freelance career, Nancy worked in both the software and publishing industries and has taught technical writing at the university level. She holds a certificate in distance learning design from the University of Washington.

Read More Show Less

Table of Contents

Chapter 1. Excel Basics.

An Introduction to Excel.

Start and Close Excel.

Navigate the Excel Program Window.

Understanding the Ribbon, Galleries, and Contextual Tools.

Change Views.

Customize the Quick Access Toolbar.

Display Task Panes.

Find Help.

Chapter 2. Workbook Fundamentals.

Start a New Workbook File.

Save a Workbook.

Publish a Workbook as an Excel Binary Workbook.

Open an Existing Workbook.

Close a Workbook.

Delete a Workbook.

Arrange Workbook Windows.

Protect a Workbook.

Hide or Show a Worksheet.

Chapter 3. Entering Data.

Enter Data.

Turn On Text Wrapping.

Resize Columns and Rows.

Select Cells.

Enter Data with AutoFill.

Work with AutoCorrect.

Edit Data.

Work with Smart Tags.

Check Spelling in a Worksheet.

Chapter 4. Working with Worksheets

Understanding Worksheet Structure.

Navigate Worksheets.

Name a Worksheet.

Add a Worksheet.

Delete a Worksheet.

Move a Worksheet.

Copy a Worksheet.

Format Worksheet Tab Color.

Protect Worksheet Data.

Chapter 5. Selecting Data with Formulas and Functions.

Understanding Formulas.

Create Formulas.

Reference Absolute and Relative Cells.

Copy Formulas.

Name Cells and Ranges.

Reference Ranges in Formulas.

Reference Cells from Other Worksheets.

Understanding Functions.

Apply a Function.

Total Cells with AutoSum.

Check for Formula Errors.

Audit a Worksheet for Errors.

Chapter 6. Rearranging Worksheet Data.

Move and Copy Data.

Delete Data or Cells.

Add Columns and Rows.

Delete Columns and Rows.

Center Data across Columns.

Transpose Columns and Rows.

Set Column Width and Row Height.

Hide Columns and Rows.

Freeze a Column or Row.

Split a Worksheet into Panes.

Find and Replace Data.

Chapter 7. Formatting Worksheets.

Apply Bold, Italics, and Underlining.

Change the Font and Size.

Change Number Formats.

Increase or Decrease Decimals.

Change Data Color.

Apply Workbook Themes.

Align Cell Data.

Rotate Cell Data.

Control Text Wrap.

Add Borders.

Add Background Color to Cells.

Assign a Background to a Worksheet.

Copy Cell Formatting.

Apply a Style.

Chapter 8. Enhancing Worksheets with Graphics.

Insert Image Files.

Insert Clip Art.

View Clip Art with the Clip Organizer.

Download Clip Art from the Web.

Draw Shapes.

Add a WordArt Object.

Move and Resize Objects.

Rotate and Flip Objects.

Crop a Picture.

Add Shadow and 3-D Effects.

Format an Object.

Group and Ungroup Objects.

Chapter 9. Previewing and Printing. 

Add Headers and Footers.

Insert Page Breaks.

Preview a Worksheet.

Set Up Printing Options.

Print a Worksheet.

Define a Print Area.

Chapter 10. Communicating Information with Charts.

Understanding Excel Charts.

Create a Chart with Galleries.

Move and Resize Charts.

Change the Chart Type.

Change the Axes Titles.

Manipulate 3-D Charts.

Format Chart Objects.

Add Chart Objects.

Change the Chart Data.

Format Charts with Layouts and Styles.

Insert SmartArt Charts.

Chapter 11. Analyzing Worksheet Data.

Understanding Database Lists.

Create a Database Table.

Add Records Using a Data Form.

Edit Records.

Search for Records.

Identify Duplicate Values in a Table.

Set Data Validation Rules.

Sort Records.

Filter Data with AutoFilter.

Analyze Data with a PivotTable.

Chapter 12. Using Excel Tools.

Add a Watch Window.

Load Add-Ins.

Analyze Data with Add-In Tools.

Examine Alternatives with Goal Seek.

Create Scenarios.

Optimize Formulas with Solver.

Chapter 13. Sharing Excel Data.

Link Data.

Edit Linked Data.

Link Between Worksheets.

Embed Objects.

Enable Workbook Sharing.

Add a Comment.

Track and Review Workbook Changes.

Merge Workbooks.

E-mail a Workbook.

Import Data.

Export Data.

Chapter 14. Using Excel on the Web.

Add Web Tools to the Quick Access Toolbar.

Publish a Workbook as a Web Page.

Insert a Hyperlink.

Download a Stock Quote.

Copy Web Data to a Worksheet.

Run a Web Query.

Chapter 15. Improving Excel Efficiency

Personalize the Excel Program Window.

Change the Default Font.

Change the Default File Location.

Open Files in a Specified Folder Automatically.

Set Macro Security.

Record a Macro.

Create an Excel Template.

Apply an Excel Template.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)