Mastering Excel 2000 : Premium Edition

by Martin, Mindy C.; Hansen, Steven M.; Klingher, Beth

• ISBN13: 9780782123173
• ISBN10: 0782123171
• Format: Paperback
• Copyright: 1999-05-01
• Publisher: John Wiley & Sons Inc

Summary

Microsoft expert authors bring this revamped edition to increase the scope of real-world examples demonstrating Excel's features. And there is still more coverage on the difficult topic of Pivot Tables. The CD-ROM provides users with Web-related software, Excel and Windows productivity software, and more.

Table of Contents

Introduction	xxxi
PART I EASING INTO EXCEL 2000	1	(96)
The Excel Environment	3	(38)
Managing Your Files	41	(26)
Managing Windows and Workbooks	67	(30)
PART II WORKSHEETS	97	(178)
Worksheet Basics	99	(38)
Entering and Editing Data	137	(52)
Formatting Your Worksheet	189	(60)
Layout and Printing	249	(26)
PART III FUNCTIONS	275	(168)
Working with Functions and Formulas	277	(42)
Essential Functions	319	(50)
Dates and Times	369	(24)
Financial Functions	393	(26)
Statistical Functions	419	(24)
PART IV CHARTS, MAPS, AND GRAPHICS	443	(154)
Charting Basics	445	(44)
Advanced Charting Techniques	489	(32)
Mapping	521	(38)
Drawing and Graphics	559	(38)
PART V ANALYZING YOUR DATA	597	(116)
Outlines and Data Consolidation	599	(30)
What-If Analysis	629	(42)
Using Excel Add-Ins	671	(42)
PART VI WORKING WITH DATABASES	713	(92)
Creating Excel Databases	715	(24)
Advanced Database Management Techniques	739	(32)
Getting At External Data	771	(34)
PART VII MASTERING PIVOT REPORTS	805	(88)
Understanding and Using PivotTable Reports	807	(22)
Tapping into the Power of PivotTable Reports	829	(32)
Pivot Reports in the Enterprise	861	(32)
PART VIII NETWORKING WITH EXCEL	893	(130)
Internet, Intranet, and Extranet	895	(46)
Importing and Exporting Files	941	(26)
Collaborating with Excel	967	(34)
Distributing Your Excel Application	1001	(22)
PART IX EXCEL AND VBA	1023	(178)
VBA Macros and the Visual Basic Editor	1025	(34)
Basics of VBA	1059	(52)
Using VBA with Excel	1111	(46)
Creating Useful Forms	1157	(44)
Appendices	1201	(39)
A What's New in Excel 2000	1201	(12)
B Excel Functions	1213	(16)
C Excel Shortcut Keys	1229	(11)
Index	1240