Excel 2003 Visual Quick Tips

Overview

* Straight-forward task descriptions
* Succinct explanations
* Full-color screen shots
* Numbered steps

Learn How To:
* Create PivotTables and PivotCharts
* Create a Button to Run a Macro
* Publish an Interactive Workbook

Read More Show Less
... See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (4) from $4.09   
  • Used (16) 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
$4.09
Seller since 2009

Feedback rating:

(2807)

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
2006-01-11 Paperback New 0470009268 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. Try ... Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

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

Feedback rating:

(177)

Condition: New
0470009268 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$45.00
Seller since 2015

Feedback rating:

(241)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$58.77
Seller since 2008

Feedback rating:

(218)

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
Close
Sort by
Sending request ...

Overview

* Straight-forward task descriptions
* Succinct explanations
* Full-color screen shots
* Numbered steps

Learn How To:
* Create PivotTables and PivotCharts
* Create a Button to Run a Macro
* Publish an Interactive Workbook

Read More Show Less

Product Details

  • ISBN-13: 9780470009260
  • Publisher: Wiley
  • Publication date: 1/11/2006
  • Series: Visual Quick Tips Series
  • Edition number: 1
  • Pages: 224
  • Product dimensions: 4.90 (w) x 7.18 (h) x 0.43 (d)

Meet the Author

David Peal teaches educational technology at the George Washington University. He is author of seven computer books, including Access the Internet, The Official AOL Guide to the Internet, and the Official AOL Guide to You've Got Pictures. He is also the author of the first Edition of Excel 2003: Top 100 Simplified Tips & Tricks published by Wiley. David has worked as product manager at a large computer book publisher and as Internet editorial manager at American Online.
Read More Show Less

Table of Contents

Chapter 1: Working with Data.

Enter Numbers and Fractions.

Enter Dates and Times.

Name Cells and Ranges.

Validate Data Entry Using a Pick List.

Extend a Series of Dates with Autofill.

Add a Symbol or Special Character.

Compare Multiple Spreadsheets Using Freeze Panes.

Hide Rows to Compare Data with Outlining.

Access Excel by Keyboard.

Find and Replace Data.

Generate a Worksheet with InfoPath.

Chapter 2: Working with Formulas and Functions.

Add Values in Different Ways.

Make Magic with the Function Wizard.

Document Formulas with Comments.

Document Worksheets with OneNote.

Define a Constant.

Apply Names in Functions.

Figure Out the Best Loan Terms.

Determine the Internal Rate of Return.

Determine the Nth Largest Value.

Create a Conditional Function.

Discover Your Inner Calculator.

Find Products and Square Roots.

Calculate the Duration Between Two Times.

Calculate Days Between Two Dates.

Change Text to Numbers.

Chapter 3: Copying Data, Formats, and More.

Copy a Range with the Office Clipboard.

Transpose a Row into a Column.

Copy Styles to Another Workbook.

Copy Chart Formatting into Another Chart.

Copy Formulas with Paste Special.

Track Changes while Editing.

Chapter 4: Using Excel Lists.

Generate a List Automatically.

Enter List Data Using a Form.

Import a Word List into Excel.

Sort and Filter a List.

Sort by Multiple Criteria.

Find Averages in a Sorted Group.

Filter by Multiple Criteria.

Remove Duplicate Records from a List.

Filter by Multiple Criteria in the Same Column.

Chart a Filtered List.

Chapter 5: Exploring Patterns in Data.

Create a PivotTable.

Modify PivotTable Data and Layout.

Find the Average of a Field.

Create a Calculated Field.

Hide Rows or Columns in a PivotTable.

AutoFormat a PivotTable.

Create a PivotChart.

Describe Data with Statistics.

Discover Associations within Your Data.

Explore Outcomes with What-If Analysis.

Chapter 6: Creating Charts.

Create a Chart.

Modify Chart Details.

Change the Chart Type.

Add a Trendline to a Chart.

Add and Remove Chart Data.

Visually Represent Missing Chart Data.

Use Error Bars in a Chart.

Pull a Slice from a Pie Chart.

Label the Slices of a Pie Chart.

Create a Histogram.

Paste a Chart into Word.

Paste-Link a Chart into Word.

Chapter 7: Presenting Worksheets.

Format Numbers as Percentages.

Format a Column of Currencies.

Format Column Headings.

Format Quickly with Format Painter.

Group Formats in a Style.

Insert a Background Image into Your Worksheet.

Create a Transparent Image.

Chapter 8: Saving and Printing Worksheets.

Save a Workbook as a Template.

Print Multiple Cell Ranges on One Page.

Print Multiple Areas of a Workbook.

Print Multiple Worksheets of a Workbook.

Repeat Headings of a Row and Column.

Print Functions to Show Calculations.

Chapter 9: Extending Excel.

Hyperlink a Worksheet to Another Office Document.

Embed a Chart within PowerPoint.

Publish an Interactive Workbook.

Import a Worksheet from the Web.

Query a Web Site.

Query an Access Database.

Reuse a Saved Query.

Import a Worksheet into Access.

Chapter 10: Customizing Excel.

Add Features by Installing and Using Add-Ins.

Launch a Specific Workbook when Excel Opens.

Create a Custom Workspace.

Save Time by Creating a Custom View.

Create a Custom Number Format.

Create a Macro to Format Numbers.

Create a Button to Run a Macro.

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

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

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