Excel 2002 Bible
1st Edition
Published on 15. July 2001
Book
Paperback/Softback
LXXII, 912 pages
978-0-7645-3583-3 (ISBN)
Description
Microsoft Excel 2002 Bible delivers comprehensive, authoritative coverage of what you need to know about Excel. Learn to go beyond entering data and applying simple formulas. Microsoft Excel 2002 Bible empowers you to tap the enormous potential of Excel. This volume shows how to use Excel effectively on the Internet or intranet. It's an excellent all-in-one reference for anyone who uses Excel, from novices to experts.
More details
Persons
About the Author John Walkenbach is the author of more than two dozen spreadsheet books. Visit his Web site at http://www.j-walk.com. Brian Underdahl is the well-known, best-selling author of nearly 60 computer books including several current titles from Hungry Minds: Pocket PCs For Dummies, Internet Bible, 2nd Edition, Teach Yourself Windows 2000 Professional, and Teach Yourself Office XP. Brian spends most of his time at the keyboard writing about personal computing. When he finds the time, he enjoys taking in the view from the home he and his wife Darlene built in the mountains 2,000 feet above Reno, Nevada. He tries to find the time to attend Mensa meetings whenever possible, and has become a fairly decent gourmet cook in recent years, too.
Content
Preface.
Quick Start: Getting Acquainted with Excel.
PART I: Getting Started with Excel.
Chapter 1: Entering and Editing Worksheet Data.
Chapter 2: Essential Spreadsheet Operations.
Chapter 3: Printing Your Work.
Chapter 4: Working with Cell Ranges.
Chapter 5: Worksheet Formatting.
Chapter 6: Using and Creating Templates.
PART II: Working with Formulas and Functions.
Chapter 7: Creating and Using Formulas.
Chapter 8: Using Worksheet Functions.
Chapter 9: Using Functions and Formulas to Manipulate Text.
Chapter 10: Working with Dates, Times, and Related Functions.
Chapter 11: Creating Formulas That Count and Sum.
Chapter 12: Creating Formulas That Look Up Values.
PART III: Enhancing Your Excel Workbooks.
Chapter 13: Getting Started Making Charts.
Chapter 14: Learning Some Advanced Charting.
Chapter 15: Enhancing Your Work with Pictures and Drawings.
Chapter 16: Introducing Arrays.
Chapter 17: Performing Magic with Array Formulas.
PART IV: Analyzing Data with Excel.
Chapter 18: Importing Data From Other Sources.
Chapter 19: Working with Lists.
Chapter 20: Using External Database Files.
Chapter 21: Analyzing Data with Pivot Tables.
Chapter 22: Performing Spreadsheet What-If Analysis.
Chapter 23: Analyzing Data Using Goal Seeking and Solver.
Chapter 24: Analyzing Data with Analysis ToolPak.
PART V: Using Advanced Excel Features.
Chapter 25: Creating and Using Worksheet Outlines.
Chapter 26: Linking and Consolidating Worksheets.
Chapter 27: Customizing Toolbars and Menus.
Chapter 28: Excel and the Internet.
Chapter 29: Using Excel in a Workgroup.
Chapter 30: Sharing Data with Other Applications.
Chapter 31: Making Your Worksheets Error-Free.
PART VI: Programming Excel with VBA.
Chapter 32: Introducing Visual Basic for Applications.
Chapter 33: VBA Programming Fundamentals.
Chapter 34: Working with VBA Sub Procedures.
Chapter 35: Creating Custom Worksheet Functions.
Chapter 36: Introducing UserForms.
Chapter 37: UserForm Techniques.
Chapter 38: Working with Excel's Events.
Chapter 39: Creating Custom Excel Add-Ins.
Chapter 40: Creating Custom Toolbars.
Chapter 41: Creating Custom Menus.
Appendix: Worksheet Function Reference.
Index.