Excel: The Missing Manual

Overview

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, Excel: The Missing Manual is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs.Never a candidate for "the most...

See more details below
Paperback
$29.56
BN.com price
(Save 26%)$39.95 List Price
Other sellers (Paperback)
  • All (30) from $1.99   
  • New (9) from $22.83   
  • Used (21) from $1.99   
Excel 2003: The Missing Manual: The Missing Manual

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, Excel: The Missing Manual is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs.Never a candidate for "the most user-friendly of Microsoft programs," Excel demands study, practice and dedication to gain even a working knowledge of the basics. Excel 2003 is probably even tougher to use than any previous version of Excel. However, despite its fairly steep learning curve, this marvelously rich program enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Excel can help you to collaborate effectively, and protect and control access to your work. Power users can take advantage of industry-standard Extensible Markup Language (XML) data to connect to business processes.To unleash the power of the program and mine the full potential of their database talents, users need an authorative and friendly resource. None is more authoritative or friendlier than Excel: The Missing Manual. Not only does the book provide exhaustive coverage of the basics, it provides numerous tips and tricks, as well as advanced data analysis, programming and Web interface knowledge that pros can adopt for their latest project. Neophytes will find everything they need to create professional spreadsheets and become confident users.Excel: The Missing Manual covers: worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and programming.If you buy just one book about using Excel, this has GOT to be it. This book has all you need to help you excel at Excel.

Covering all features of Excel 2002 and 2003, this book is a complete guide to the spreadsheet software presented in the bestselling Missing Manual format. This book goes beyond the basics, taking the reader as far as he or she needs to go.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Most people use only a tiny fraction of Excel’s power. Not because that’s all they need, because it’s all they understand. A friendly, 100 percent readable, easy-to-use manual would sure help. Here it is.

With Matthew McDonald’s help, you’re finally going to learn how to print your formulas, create PivotTables that work, use math and statistical functions (some of which can definitely, positively help you, no matter what you do with Excel).

You’ll learn how to calculate with dates and times (and format them exactly as you want); how to sort, group, and outline data; how to make your charts look just perfect. If you so desire, McDonald will even get you started with XML, web queries, even a first taste of VBA programming. Bill Camarda, from the March 2005 Read Only

From the Publisher
"Excel 2003 enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes."
Read More Show Less

Product Details

  • ISBN-13: 9780596006648
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 12/28/2004
  • Series: Missing Manual Series
  • Edition number: 1
  • Pages: 792
  • Sales rank: 536,563
  • Product dimensions: 7.18 (w) x 9.21 (h) x 1.54 (d)

Meet the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Read More Show Less

Table of Contents

The Missing Credits;
About the Author;
About the Creative Team;
Acknowledgements;
The Missing Manual Series;
Introduction;
What Excel Is all About;
About This Book;
Safari-Enabled;
Part I: Worksheet Basics;
Chapter 1: Creating and Navigating Worksheets;
1.1 Creating a Basic Worksheet;
1.2 Editing Data;
1.3 Navigating in Excel;
1.4 Saving Files;
1.5 Opening Files;
Chapter 2: Adding Information to Worksheets;
2.1 Adding Different Types of Data;
2.2 Quick Ways to Add Data;
Chapter 3: Moving Data Around a Worksheet;
3.1 Selecting Cells;
3.2 Moving Cells Around;
3.3 Adding and Moving Columns or Rows;
Chapter 4: Formatting Worksheets;
4.1 Formatting Cell Values;
4.2 Formatting Cell Appearance;
4.3 Smart Ways to Apply Formatting;
Chapter 5: Managing Worksheets and Workbooks;
5.1 Worksheets and Workbooks;
5.2 Find and Replace;
5.3 Spell Check;
Chapter 6: Viewing and Printing Worksheets;
6.1 Controlling Your View;
6.2 Printing;
Part II: Formulas and Functions;
Chapter 7: Building Basic Formulas;
7.1 Creating a Basic Formula;
7.2 Formula Shortcuts;
7.3 Copying Formulas;
Chapter 8: Math and Statistical Functions;
8.1 Rounding Numbers;
8.2 Groups of Numbers;
8.3 General Math Functions;
8.4 Trigonometry and Advanced Math;
8.5 Advanced Statistics;
Chapter 9: Financial Functions;
9.1 The World of Finance;
9.2 Financial Functions;
9.3 Depreciation;
9.4 Other Financial Functions;
Chapter 10: Manipulating Dates, Times, and Text;
10.1 Manipulating Text;
10.2 Manipulating Dates and Times;
10.3 Math with Dates and Times;
10.4 Date and Time Functions;
10.5 Analysis ToolPak Date Functions;
Chapter 11: Lookup, Reference, and Information Functions;
11.1 The Basic Lookup;
11.2 Advanced Lookups;
11.3 Information Functions;
11.4 Tutorial: Quickly Generating Invoices from a Product Catalog;
Chapter 12: Advanced Formula Writing;
12.1 Conditions in Formulas;
12.2 Descriptive Names for Cell References;
12.3 Variable Data Tables;
12.4 Controlling Recalculation;
12.5 Solving Formula Errors;
Part III: Organizing Worksheets;
Chapter 13: Data Lists;
13.1 The Basics of Data Lists;
13.2 The Data Form;
13.3 Sorting and Filtering a List;
13.4 Performing List Calculations;
Chapter 14: Grouping and Outlining Data;
14.1 Basic Data Grouping;
14.2 Grouping Timesavers;
Chapter 15: Templates;
15.1 Understanding Templates;
15.2 Starting from a Template;
15.3 Creating Templates;
15.4 Fine-Tuning Templates;
Part IV: Charts and Graphics;
Chapter 16: Creating Basic Charts;
16.1 Charting 101;
16.2 Basic Tasks with Charts;
16.3 Practical Charting;
16.4 Chart Types;
Chapter 17: Formatting and Perfecting Charts;
17.1 Formatting Chart Elements;
17.2 Improving Your Charts;
17.3 Advanced Charting;
Chapter 18: Inserting Graphics;
18.1 Adding Pictures to a Worksheet;
18.2 Excel's Clip Art Library;
18.3 Drawing Shapes;
18.4 Drawing Graphic Objects in Charts;
Part V: Advanced Data Analysis;
Chapter 19: Scenarios and Goal Seeking;
19.1 Using Scenarios;
19.2 Using Goal Seek;
19.3 Solver;
Chapter 20: Pivot Tables;
20.1 Summary Tables Revisited;
20.2 Building Pivot Tables;
20.3 Advanced Pivot Tables;
Part VI: Sharing Data with the Rest of the World;
Chapter 21: Worksheet Collaboration;
21.1 Your Excel Identity;
21.2 Using Comments;
21.3 Using Change Tracking;
21.4 Setting Up a Review Chain;
21.5 Workbook Sharing;
Chapter 22: Exchanging Data with Other Programs;
22.1 Sharing Information in Windows;
22.2 Embedding and Linking Objects;
22.3 Transferring Data;
22.4 Excel and Databases;
Chapter 23: XML;
23.1 XML 101;
23.2 The Excel XML Story;
23.3 Linking Spreadsheets to XML;
Chapter 24: Connecting Worksheets to the Web;
24.1 Putting Worksheets on the Web;
24.2 Performing Web Queries;
24.3 Using Hyperlinks;
Part VII: Programming Excel;
Chapter 25: Automating Tasks with Macros;
25.1 Macros 101;
25.2 The Macro Recorder;
25.3 Creating Practical Macros;
Chapter 26: Programming Spreadsheets with VBA;
26.1 The Visual Basic Editor;
26.2 Understanding Macro Code;
26.3 Exploring the VBA Language;
Part VII: Appendixes;
Appendix A: Getting Help in Excel;
A.1 Asking Questions;
A.2 The Office Assistant;
A.3 Other Help Menu Options;
Appendix B: Customizing Excel;
B.1 The Customize Dialog Box;
Appendix C: Quick Menu Reference;
C.1 File Menu;
C.2 Edit Menu;
C.3 View Menu;
C.4 Insert Menu;
C.5 Format Menu;
C.6 Tools Menu;
C.7 Data Menu;
C.8 Chart Menu;
C.9 Window Menu;
C.10 Help Menu;
Colophon;

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

    Posted January 31, 2005

    comprehensive and concise

    I'm a little leery of taking the title 'Missing Manual' literally. Other books in this series have discussed the Macintosh and other Apple offerings, where indeed typically Apple provided only a paucity of information in its manuals. But for Excel, Microsoft does offer comprehensive hardcopy documentation. This book is really one of a numerous set of third party offerings that try to improve on Microsoft. The strongest argument for this book is that it appears to combine a comprehensive description of Excel with a conciseness of that explanation. In other words, it really doesn't belong in the Missing Manual series, but rather in O'Reilly's regular and long running series of texts, that share these properties. You know, the books with the purple covers. Granted, the book is bulky. But that reflects over a decade of Excel being continually refined and added to. The conciseness of the explanations means typically some prior exposure to spreadsheets in general, and Excel in particular, would greatly aid your understanding.

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

    Posted May 2, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

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