Synopses & 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.
Review
"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."
Synopsis
- Complete, comprehensive, accurate, "The" Missing Manual
- "Not" for dummies
Synopsis
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.
Synopsis
Becoming an Excel jockey takes practice, dedication, and expert guidance. And, despite its fairly steep learning curve, Excel is a marvelously rich program that enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Whether you're new to Excel or an intermediate-level spreadsheet aficionado, "Excel: The Missing Manual is sure to become your go-to resource and training partner. Like all Missing Manuals, this book is an advanced-beginner river of knowledge that offers jumping off points to side and more advanced topics. Covering all the features of Excel 2002 and 2003, including worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and more, "Excel: The Missing Manual is an easy-to-read, humorous, thorough, and downright enjoyable guide to the world's most popular spreadsheet program.
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;