Excel 2003: The Missing Manual: The Missing Manual (Google eBook)

Front Cover
"O'Reilly Media, Inc.", Dec 22, 2004 - Computers - 792 pages
4 Reviews

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.

  

What people are saying - Write a review

great product

User Review  - efsmith55 - Overstock.com

when you need to learn Excel, this is the best book to learn from. It is easy to read and understand. I knew nothing of the subject matter and this book got me thur with flying colors. The missing ... Read full review

Review: Excel 2010: The Missing Manual

User Review  - Lisa Weathers - Goodreads

This book is very basic if you are an advanced excel user. The version I downloaded from B&N does not contain a table of contents so unless you want to search 3813 pages for what you are looking for ... Read full review

Contents

Creating and Navigating Worksheets
3
Adding Information to Worksheets
37
Moving Data Around a Worksheet
55
Formatting Worksheets
73
Managing Worksheets and Workbooks
115
Viewing and Printing Worksheets
137
Building Basic Formulas
167
Math and Statistical Functions
199
Formatting and Perfecting Charts
449
Inserting Graphics
483
Scenarios and Goal Seeking
507
Pivot Tables
529
Worksheet Collaboration
557
Exchanging Data with Other Programs
587
XML
611
Connecting Worksheets to the Web
629

Financial Functions
231
Manipulating Dates Times and Text
251
Lookup Reference and Information Functions
279
Advanced Formula Writing
305
Data Lists
337
Grouping and Outlining Data
363
Templates
381
Creating Basic Charts
415
Automating Tasks with Macros
653
Programming Spreadsheets with VBA
673
Getting Help in Excel
701
Customizing Excel
711
Quick Menu Reference
719
Index
745
Copyright

Common terms and phrases

About the author (2004)

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007: The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007: The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly. His web site is http: //www.prosetech.com/.

Bibliographic information