Teach Yourself VISUALLY Excel 2003

( 7 )

Overview


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 120 Excel 2003 tasks. Each task-based spread includes these great features to get you up and running on Excel 2003 in no time:
* Helpful sidebars that ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (34) from $1.99   
  • New (2) from $11.26   
  • Used (32) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$11.26
Seller since 2007

Feedback rating:

(5866)

Condition:

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.

New
New

Ships from: Miamisburg, OH

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(165)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

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

Overview


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 120 Excel 2003 tasks. Each task-based spread includes these great features to get you up and running on Excel 2003 in no time:
* Helpful sidebars that offer practical tips and tricks
* Succinct explanations that walk you through step by step
* Full-color screen shots that demonstrate each task
* Two-page lessons that break big topics into bite-sized modules

Learn How To:
* Work with task panes and toolbars
* Assign workbook passwords
* Enter data with AutoFill
* Reference absolute and relative cells
* Increase or decrease decimals
* Create charts with Chart Wizard
Read More Show Less

Product Details

  • ISBN-13: 9780764596889
  • Publisher: Wiley
  • Publication date: 9/12/2005
  • Series: Teach Yourself VISUALLY (Tech) Series
  • Edition description: REV
  • Edition number: 2
  • Pages: 320
  • Product dimensions: 8.05 (w) x 9.05 (h) x 0.76 (d)

Meet the Author


Sherry Willard Kinkoph has written and edited more than 70 books over the past 10 years covering a variety of computer topics ranging from hardware to software, from Microsoft Office programs to the Internet. Her recent titles include Master VISUALLY eBay Business Kit, Teach Yourself VISUALLY Photoshop Elements 3.0, and Top 100 Simplified Tips and Tricks Office 2003. Sherry’s ongoing quest is to help users of all levels master the ever-changing computer technologies. No matter how many times they — the software manufacturers and hardware conglomerates — throw out a new version or upgrade, Sherry vows to be there to make sense of it all and help computer users get the most out of their machines.
Read More Show Less

Table of Contents


Chapter 1: Excel Basics.

An Introduction to Excel.

Start and Close Excel.

Navigate the Excel Program Window.

Work with Task Panes.

Display and Hide Toolbars.

Finding Help.

Chapter 2: Workbook Fundamentals.

Start a New Workbook File.

Save a Workbook.

Open an Existing Workbook.

Close a Workbook.

Delete a Workbook.

Find a Workbook.

Arrange Workbook Windows.

Assign a Workbook Password.

Chapter 3: 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 4: 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.

Spell Check a Worksheet.

Chapter 5: Working 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.

TotalCells 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.

Format Data with AutoFormat.

Align Cell Data.

Rotate Cell Data.

Control Text Wrap.

Add Borders.

Add Background Color to Cells.4

Assign a Background to a Worksheet.

Copy Cell Formatting.

Create a Style.

Assign Conditional Formatting.

Chapter 8: Adding Graphics.

Insert Image Files.

Insert Clip Art.

View Clip Art with the Clip Organizer.

Download Clip Art from the Web.

Draw AutoShapes.

Draw Lines and Arrows.4

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: Working with Charts.

Understanding Excel Charts.

Create a Chart with Chart Wizard.

Move and Resize Charts.

Change the Chart Type.

Change the Axes Titles.

Format Chart Objects.

Add Chart Objects.

Change the Chart Data

Chapter 11: Analyzing Worksheet Data.

Understanding Database Lists.

Create a Database List.

Add Records Using a Data Form.

Edit Records.

Search for Records.

Add Subtotals to a List.

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.

Using Data Analysis Tools.

Using Goal Seek.

Create Scenarios.

Using 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.

Create an HTML File.

Preview a Worksheet as a Web Page.

Set Alternative Text for an Object.

Insert a Hyperlink.

Download a Stock Quote.

Using the Web Toolbar.

Copy Web Data to a Worksheet.

Run a Web Query.

Chapter 15: Improving Excel Efficiency.

Customize the Excel Program Window.

Customize Toolbars.

Create a Custom Toolbar Button.

Add a Calculator.

Customize Menus.

Change the Default Font.

Change the Default File Location.

Open a Workbook Automatically.

Define Workbook Properties.

Play Back Worksheet Data.

Record a Macro.

Create an Excel Template.

Apply an Excel Template.
Read More Show Less

Customer Reviews

Average Rating 4
( 7 )
Rating Distribution

5 Star

(4)

4 Star

(0)

3 Star

(1)

2 Star

(2)

1 Star

(0)

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

Reminder:

  • - 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
Sort by: Showing all of 7 Customer Reviews
  • Anonymous

    Posted January 11, 2008

    The Best Self Help Series

    This book enable me to read through it in one night and completing learn Excel. I have been working and creating on Excel ever since without assistance.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 29, 2007

    A Great Way to Start

    A very good book to learn the wonders and power of Excel. Not a lot of extra jargon - just step by step instructions. Well written.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 26, 2006

    WONDERFUL BOOK

    This book took you step by step through Excel without being bogged down by a bunch of technical whoha. So good, I bought the Excel 2003 VBA Programming

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 5, 2010

    No text was provided for this review.

  • Anonymous

    Posted March 28, 2010

    No text was provided for this review.

  • Anonymous

    Posted January 22, 2009

    No text was provided for this review.

  • Anonymous

    Posted February 11, 2009

    No text was provided for this review.

Sort by: Showing all of 7 Customer Reviews

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