|
|
Excel 2002: The Complete ReferenceStock informationGeneral Fields
Special Fields
DescriptionThis resource shows how to select, implement and utilize Excel 10\\\'s features and also prepares readers to take and pass all levels of the Microsoft Office User Specialist (MOUS) certification exams. Reviews"Microsoft Corporation has shipped the first beta version of its next Office applications suite, with officials calling the upgrade the most significant and innovative release of Office ever." - Peter Gallie, eWeek, August 30, 2000" Author descriptionKathy Ivens (Philadelphia, PA) has been a computer consultant since 1984. She has authored, co-authored, contributed to, and ghost written more than forty volumes on computer subjects. She is a frequent contributor to national magazines on computer topics, writing reviews and articles, and is a contributing editor for Windows 2000 Magazine and Windows NT Magazine. Conrad Carlberg (S. Carlsbad, CA) is a former Microsoft MVP for Excel. Table of contentsIntroduction; Part I Getting Started; Chapter 1: Excel Basics; Chapter 2: Entering Information; Chapter 3: Working with Files; Chapter 4: Manipulating Data; Chapter 5: Structuring Worksheets; Chapter 6: Printing; Part II Analyzing Data; Chapter 7: Managing Data; Chapter 8: Using Formulas; Chapter 9: Worksheet Functions; Chapter 10: Advanced Work with Formulas; Chapter 11: Charting Data; Chapter 12: Drawing Objects; Chapter 13: Data Maps; Chapter 14: Pivot Tables; Chapter 15: Reaching Solutions with Brute Force; Part III The Outside World: Chapter 16: Acquiring Data; Chapter 17: Sharing Workbooks; Chapter 18: Using Web Technology; Part IV Extending Excel's Reach with VBA; Chapter 19: Automating Repetitive Tasks; Chapter 20: The Visual Basic Editor and the Excel Object Model; Chapter 21: Writing Subroutines; Chapter 22: Writing Functions; Chapter 23: Controlling Input with User Forms; Chapter 24: Techniques for Handling VBA Arrays; Part V Appendixes; Appendix A: Becoming a Microsoft Office User Specialist; Appendix B: Microsoft Office User Specialist Exam Objectives Appendix C: Excel Functions; Index |