Normal view MARC view ISBD view

Microsoft Excel 2000 Bible ; programming with VBA & formulae

By:

Walkenbach John

Material type: Text

TextPublication details: 2000 IDG Books New DelhiDescription: xl, 1381p. 24 cm ; PbkISBN:

978-8126500905

Subject(s):

Business--Computer programs Electronic spreadsheets Microsoft Excel (Computer file)

Contents:

Preface -- Acknowledgments -- Part I: Getting Started. Chap. 1. A bit of background -- Chap. 2. What's new in Excel 2000? -- Chap. 3. Getting acquainted with Excel -- Part II. Introductory concepts. Chap. 4. Navigating through Excel -- Chap. 5. Working with files and workbooks -- Chap. 6. Entering and editing worksheet data -- Chap. 7. Essential spreadsheet operations -- Chap. 8. Working with cell ranges -- Chap. 9. Creating and using formulas -- Chap. 10. Using worksheet functions -- Chap. 11. Worksheet formatting -- Chap. 12. Printing your work -- Chap. 13. Chart-making basics -- Chap. 14. Enhancing your work with pictures and drawings -- Chap. 15. Putting it all together -- Part III. Advanced features. Chap. 16. Advanced charting -- Chap. 17. Creating maps with Microsoft Map -- Chap. 18. Creating and using worksheet outlines -- Chap. 19. Linking and consolidating worksheets -- Chap. 20. Creating and using array formulas -- Chap. 21. Using Excel in a workgroup -- Part IV. Analyzing data. Chap. 22. Importing data from other sources -- Chap. 23. Working with lists -- Chap. 24. Using external database files -- Chap. 25. Analyzing data with pivot tables -- Chap. 26. Performing spreadsheet what-if analysis -- Chap. 27. Analyzing data using Goal Seeking and Solver -- Chap. 28. Analyzing data with Analysis ToolPak -- Part V. Other topics. Chap. 29. Sharing data with other applications -- Chap. 30. Excel and the Internet -- Chap. 31. Making your spreadsheets error-free -- Chap. 32. Fun stuff -- Part VI. Customizing Excel -- Chap. 33. Customizing toolbars and menus -- Chap. 34. Using and creating templates -- Chap. 35. Using Visual Basic for applications -- Chap. 36. Creating custom worksheet functions -- Chap. 37. Creating custom dialog boxes -- Chap. 38. Using dialog box controls in your worksheet -- Chap. 39. VBA programming examples -- Chap. 40. Creating custom Excel add-ins -- Appendix A. Using online help : a primer -- Appendix B. Worksheet function reference -- Appendix C. Excel's shortcut keys -- Appendix D. What's on the CD-ROM -- Index -- End-user license agreement -- CD-ROM installation instructions.

Summary: You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.

Tags from this library: No tags from this library for this title. Log in to add tags.

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
Books	H.T. Parekh Library	GSB Collection	001.642 EXC WAL (Browse shelf(Opens below))	In transit from H.T. Parekh Library to H.T. Parekh Library since 20/11/2022		22982

Rs.499/- CD ROM

Preface --
Acknowledgments --
Part I: Getting Started. Chap. 1. A bit of background --
Chap. 2. What's new in Excel 2000? --
Chap. 3. Getting acquainted with Excel --
Part II. Introductory concepts. Chap. 4. Navigating through Excel --
Chap. 5. Working with files and workbooks --
Chap. 6. Entering and editing worksheet data --
Chap. 7. Essential spreadsheet operations --
Chap. 8. Working with cell ranges --
Chap. 9. Creating and using formulas --
Chap. 10. Using worksheet functions --
Chap. 11. Worksheet formatting --
Chap. 12. Printing your work --
Chap. 13. Chart-making basics --
Chap. 14. Enhancing your work with pictures and drawings --
Chap. 15. Putting it all together --
Part III. Advanced features. Chap. 16. Advanced charting --
Chap. 17. Creating maps with Microsoft Map --
Chap. 18. Creating and using worksheet outlines --
Chap. 19. Linking and consolidating worksheets --
Chap. 20. Creating and using array formulas --
Chap. 21. Using Excel in a workgroup --
Part IV. Analyzing data. Chap. 22. Importing data from other sources --
Chap. 23. Working with lists --
Chap. 24. Using external database files --
Chap. 25. Analyzing data with pivot tables --
Chap. 26. Performing spreadsheet what-if analysis --
Chap. 27. Analyzing data using Goal Seeking and Solver --
Chap. 28. Analyzing data with Analysis ToolPak --
Part V. Other topics. Chap. 29. Sharing data with other applications --
Chap. 30. Excel and the Internet --
Chap. 31. Making your spreadsheets error-free --
Chap. 32. Fun stuff --
Part VI. Customizing Excel --
Chap. 33. Customizing toolbars and menus --
Chap. 34. Using and creating templates --
Chap. 35. Using Visual Basic for applications --
Chap. 36. Creating custom worksheet functions --
Chap. 37. Creating custom dialog boxes --
Chap. 38. Using dialog box controls in your worksheet --
Chap. 39. VBA programming examples --
Chap. 40. Creating custom Excel add-ins --
Appendix A. Using online help : a primer --
Appendix B. Worksheet function reference --
Appendix C. Excel's shortcut keys --
Appendix D. What's on the CD-ROM --
Index --
End-user license agreement --
CD-ROM installation instructions.

You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.

There are no comments on this title.

to post a comment.