Microsoft Excel Version 2002 Inside Out

by Microsoft Corporation

• ISBN13: 9780735612815
• ISBN10: 0735612811
• Edition: 1st
• Format: Paperback
• Copyright: 2001-05-09
• Publisher: Microsoft Press

Summary

Microsoft Excel Version 2002 Inside Out is the foremost reference to Excel version 2002 for PC "super users". Complete in one volume, this book provides a thorough overview of the most-used features and functions of Microsoft's popular spreadsheet program. The book provides the information, advanced users really need. It delivers comprehensive information about each major Excel tool and task, including using worksheets, analyzing data, interfacing with other applications, using charts, creating databases and managing lists, and more. The book also shows how to create macros, use custom functions, and master Excel by using the Microsoft Visual Basicr development system. Throughout the book you'll find a wealth of timesaving Excel tips and tricks, troubleshooting techniques, and indexes, plus a CD-ROM that holds an electronic version of the book's text, handy Web links, sample macros and code, tutorials, utilities and additional third party software. This is the authoritative handbook you'll keep by your computer and use whenever you're stuck or stumped!

Author Biography

Craig Stinson is a journalist and author. He has written or coauthored more than 20 books including Windows Vista Inside Out, Deluxe Edition and Microsoft Office Excel 2007 Inside Out.

Table of Contents

Part 1 Examining the Excel Environment
What's New in Microsoft Excel 2002	3	(10)
Running Excel	13	(52)
Custom-Tailoring the Excel Workspace	65	(26)
Part 2 Building Worksheets	91	(54)
Worksheet Design Tips	93	(8)
How to Work a Worksheet	101	(32)
How to Work a Workbook	133	(12)
Part 3 Formatting and Editing Worksheets	145	(140)
Worksheet Editing Techniques	147	(52)
Worksheet Formatting Techniques	199	(46)
Advanced Formatting and Editing Techniques	245	(40)
Part 4 Adding Graphics and Printing	285	(68)
Creating Spiffy Graphics	287	(48)
Printing and Presenting	335	(18)
Part 5 Creating Formulas and Performing Data Analysis	353	(176)
Building Formulas	355	(48)
Using Functions	403	(10)
Everyday Functions	413	(26)
Formatting and Calculating Date and Time	439	(16)
Functions for Financial Analysis	455	(16)
Functions for Analyzing Statistics	471	(28)
Performing What-If Analysis	499	(30)
Part 6 Collaboration and the Internet	529	(60)
Collaborating with Excel	531	(22)
Transferring Files to and from Internet Sites	553	(16)
Linking and Embedding	569	(10)
Using Hyperlinks	579	(10)
Part 7 Integrating Excel with Other Applications	589	(20)
Integrating Excel with Word and PowerPoint	591	(18)
Part 8 Creating Charts	609	(94)
Basic Charting Techniques	611	(14)
Enhancing the Appearance of Your Charts	625	(46)
Working with Chart Data	671	(16)
Advanced Charting Techniques	687	(16)
Part 9 Managing Databases and Lists	703	(128)
Managing Information in Lists	705	(44)
Working with External Data	749	(40)
Analyzing Data with PivotTable Reports	789	(42)
Part 10 Working with Visual Basic and Macros	831	(70)
Recording Macros	833	(20)
Creating Custom Functions	853	(10)
A Sample Visual Basic Application	863	(24)
Debugging Macros and Custom Functions	887	(14)
Part 11 Appendixes	901	(2)
Appendix A Installing Microsoft Excel	903	(8)
Appendix B Using Speech and Handwriting Recognition	911	(14)
Appendix C Keyboard Shortcuts	925	(24)
Appendix D Function Reference	949