Taylor's Library

Normal view MARC view ISBD view

Excel 2002 formulas / John Walkenbach

By: Walkenbach, John.
Series: Professional mindware.Publisher: New York, N.Y. : M&T Books, c2001Description: xxxvi, 825 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.).ISBN: 076454800X (pbk.).Subject(s): Microsoft Excel (Computer file) | Business -- Computer programs | Electronic spreadsheetsDDC classification: 005.369
Contents:
Preface. - Acknowledgments. - Pt. 1. Basic information. Ch. 1. Excel in a Nutshell. Ch 2. Basic facts about formulas. Ch. 3. Working with names. - Pt. II. Using functions in your formulas. Ch. 4. Introducing worksheet functions. Ch. 5. Manipulating text. Ch. 6. Working with dates and times. Ch. 7. Counting and summing techniques. Ch. 8. Lookups. Ch. 9. Databases and lists. Ch. 10. Miscellaneous calculations. - Pt. III. Financial formulas. Ch 11. Introducing financial formulas. Ch. 12. Discounting and depreciation financial functions. Ch. 13. Advanced uses of financial functions and formulas. - Pt. IV. Array formulas. Ch. 14. Introducing arrays. Ch. 15. Performing magic with array formulas. - Pt. V. Miscellaneous formula techniques. Ch 16. Intentional circular references. Ch 17. Charting techniques. Ch. 18. Pivot tables. Ch. 19. Conditional formatting and data validation. Ch. 20. Creating megaformulas. Ch. 21. Tools and methods for debugging formulas. - Pt. VI. Developing custom worksheet functions. Ch. 22. Introducing VBA. Ch. 23. Function procedure basics. Ch. 24. VBA programming concepts. C 25. VBA custom function examples. - Appendixes. Appendix A. Working with imported 1-2-3- files. Appendix B. Excel function reference. Appendix C. Using custom number formats. Appendix D. Additonal excel resources. Appendix E. What's on the CD-ROM. - Index. - End-user licence agreement. - CD-ROM installation instructions.
Item type Current location Call number Vol info Copy number Status Notes Date due Barcode Remark
Accompanying Material (Media Resource) TU External Storage-LCS
005.369 WAL (Browse shelf) CD-ROM 1 Available SOCIT,15008,03,GR 1000117759 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

Accompanying CD-ROM includes chapter examples from Excel workbooks discussed in the book, a trial version of the author's Power Utility Pak 2000, a demo version of the author's Sound-Proof 2000, and the latest version of Acrobat Reader from Adobe.

Includes index.

Preface. - Acknowledgments. - Pt. 1. Basic information. Ch. 1. Excel in a Nutshell. Ch 2. Basic facts about formulas. Ch. 3. Working with names. - Pt. II. Using functions in your formulas. Ch. 4. Introducing worksheet functions. Ch. 5. Manipulating text. Ch. 6. Working with dates and times. Ch. 7. Counting and summing techniques. Ch. 8. Lookups. Ch. 9. Databases and lists. Ch. 10. Miscellaneous calculations. - Pt. III. Financial formulas. Ch 11. Introducing financial formulas. Ch. 12. Discounting and depreciation financial functions. Ch. 13. Advanced uses of financial functions and formulas. - Pt. IV. Array formulas. Ch. 14. Introducing arrays. Ch. 15. Performing magic with array formulas. - Pt. V. Miscellaneous formula techniques. Ch 16. Intentional circular references. Ch 17. Charting techniques. Ch. 18. Pivot tables. Ch. 19. Conditional formatting and data validation. Ch. 20. Creating megaformulas. Ch. 21. Tools and methods for debugging formulas. - Pt. VI. Developing custom worksheet functions. Ch. 22. Introducing VBA. Ch. 23. Function procedure basics. Ch. 24. VBA programming concepts. C 25. VBA custom function examples. - Appendixes. Appendix A. Working with imported 1-2-3- files. Appendix B. Excel function reference. Appendix C. Using custom number formats. Appendix D. Additonal excel resources. Appendix E. What's on the CD-ROM. - Index. - End-user licence agreement. - CD-ROM installation instructions.