Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010124245 | HF5548.4.M523 W346 2007 | Open Access Book | Book | Searching... |
Searching... | 30000010177973 | HF5548.4.M523 W346 2007 | Open Access Book | Book | Searching... |
Searching... | 30000003511254 | HF5548.4.M523 W346 2007 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
This book is a single reference that s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won t find anywhere else John Walkenbach, aka "Mr. Spreadsheet," is one of the world s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Author Notes
John Walkenbach , arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 40-plus books include Excel 2003 Power Programming with VBA , Excel Charts , and John Walkenbach′s Favorite Excel Tips & Tricks , all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.
Table of Contents
| Part I Basic Information |
| Chapter 1 Excel in a Nutshell |
| Chapter 2 Basic Facts about Formulas |
| Chapter 3 Working with Names |
| Part II Using Functions in Your Formulas |
| Chapter 4 Introducing Worksheet Functions |
| Chapter 5 Manipulating Text |
| Chapter 6 Working with Dates and Times |
| Chapter 7 Counting and Summing Techniques |
| Chapter 8 Using Lookup Functions |
| Chapter 9 Tables and Worksheet Databases |
| Chapter 10 Miscellaneous Calculations |
| Part III Financial Formulas |
| Chapter 11 Borrowing and Investing Formulas |
| Chapter 12 Discounting and Depreciation Formulas |
| Chapter 13 Financial Schedules |
| Part IV Array Formulas |
| Chapter 14 Introducing Arrays |
| Chapter 15 Performing Magic with Array Formulas |
| Part V Miscellaneous Formula Techniques |
| Chapter 16 Intentional Circular References |
| Chapter 17 Charting Techniques |
| Chapter 18 Pivot Tables |
| Chapter 19 Conditional Formatting and Data Validation |
| Chapter 20 Creating Megaformulas |
| Chapter 21 Tools and Methods for Debugging Formulas |
| Part VI Developing Custom Worksheet Functions |
| Chapter 22 Introducing VBA |
| Chapter 23 Function Procedure Basics |
| Chapter 24 VBA Programming Concepts |
| Chapter 25 VBA Custom Function Examples |
| Part VII Appendixes |
| Appendix A Excel Function Reference |
| Appendix B Using Custom Number Formats |
| Appendix C Additional Excel Resources |
| Appendix D What's on the CD-ROM |
| Index |
