|
|
Usually ships within 1 to 3 working days
|
- Product code: 20427
- ISBN: 0764539671,
ISBN13: 9780764539671,
936 pages, paperback
Published by John Wiley & Sons on 2003
, 2003 Rate this book...
Rating: 0.0/5 (0 votes cast)
|
|
|
|
|
Description of Excel 2003 Bible |
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
|
Contents of Excel 2003 Bible |
Preface
PART I: Getting Started with Excel
1. Introducing Excel
2. Entering and Editing Worksheet Data
3. Essential Worksheet Operations
4. Working with Cells and Ranges
5. Worksheet Formatting
6. Understanding Files and Templates
7. Printing Your Work
PART II: Working with Formulas and Functions
8. Introducing Formulas and Functions
9. Creating Formulas That Manipulate Text
10. Working with Dates and Times
11. Creating Formulas That Count and Sum
12. Creating Formulas That Look Up Values
13. Creating Formulas for Financial Applications
14. Introducing Array Formulas
15. Performing Magic with Array Formulas
PART III: Creating Charts and Graphics
16. Getting Started Making Charts
17. Learning Advanced Charting
18. Enhancing Your Work with Pictures and Drawings
PART IV: Analyzing Data with Excel
19. Working with Lists
20. Using External Database Files
21. Analyzing Data with Pivot Tables
22. Performing Spreadsheet What-If Analysis
23. Analyzing Data Using Goal Seek and Solver
24. Analyzing Data with the Analysis ToolPak
PART V: Using Advanced Excel Features
25. Using Custom Number Formats
26. Customizing Toolbars and Menus
27. Using Conditional Formatting and Data Validation
28. Creating and Using Worksheet Outlines
29. Linking and Consolidating Worksheets
30. Excel and the Internet
31. Sharing Data with Other Applications
32. Using Excel in a Workgroup
33. Making Your Worksheets Error-Free
PART VI: Programming Excel with VBA
34. Introducing Visual Basic for Applications
35. Creating Custom Worksheet Functions
36. Creating UserForms
37. Using UserForm Controls in a Worksheet
38. Working with Excel Events
39. VBA Examples
40. Creating Custom Excel Add-Ins
PART VII: Appendixes
Appendix A: Worksheet Function Reference
Appendix B: What's on the CD-ROM
Appendix C: Just for Fun
Appendix D: Additional Excel Resources
Appendix E: Excel Shortcut Keys
Index
End-User License Agreement
|
About John Walkenbach |
John Walkenbach is the author of approximately three dozen spreadsheet books. Visit his Web site at http://.j-walk.com.
|
Buyers of Excel 2003 Bible also bought
Bulk buying
| If you need bulk copies of Excel 2003 Bible, or are interested in opening a corporate account, please contact us. |
|
|
Shopping basket