Excel: The Missing Manual

Excel: The Missing Manual

Paperback

$35.96 $39.95 Save 10% Current price is $35.96, Original price is $39.95. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Tuesday, November 20

Product Details

ISBN-13: 9780596006648
Publisher: O'Reilly Media, Incorporated
Publication date: 12/28/2004
Series: Missing Manual Series
Pages: 792
Product dimensions: 7.00(w) x 9.19(h) x 1.54(d)

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

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;

What People are Saying About This

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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Excel: The Missing Manual 4.3 out of 5 based on 0 ratings. 11 reviews.
Anonymous More than 1 year ago
She turns toward elena and shoots her "we are not friends" she then turns and says to everyone, "if you guys dissagree then dawn can bring her back but she was pretty annoying"
Anonymous More than 1 year ago
She looks around.
Anonymous More than 1 year ago
*Walks in* Huh. I forgot about this place. I thought it fell inactive
Anonymous More than 1 year ago
Walks in.
Anonymous More than 1 year ago
*walks in and starts to sing titanium*
Anonymous More than 1 year ago
Hey
Anonymous More than 1 year ago
Walks in and looks around.
Anonymous More than 1 year ago
She steps in nervously. "I am a runaway and heard anout this place, can anyone help me?"
Anonymous More than 1 year ago
I walk in. Im wearing training clothes. I strech to warm up, then I practice my ningalike skills. I do turns and flips. Then I set up a corse using my superspeed to move it along.
Anonymous More than 1 year ago
Guest More than 1 year ago
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.