Excel 2003: The Missing Manual: The Missing Manual"O'Reilly Media, Inc.", 22 déc. 2004 - 792 pages 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. |
Table des matières
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 |
Creating Basic Charts | 415 |
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 |
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 |
Connecting Worksheets to the Web | 629 |
Automating Tasks with Macros | 653 |
Programming Spreadsheets with VBA | 673 |
Getting Help in Excel | 701 |
Customizing Excel | 711 |
Quick Menu Reference | 719 |
745 | |