| Description |
1 online resource (xlii, 866 pages) : illustrations |
| Contents |
Ch. 1. Introducing Excel -- Ch. 2. What's new in Excel 2007? -- Ch. 3. Entering and editing worksheet data -- Ch. 4. Essential worksheet operations -- Ch. 5. Working with cells and ranges -- Ch. 6. Introducing tables -- Ch. 7. Worksheet formatting -- Ch. 8. Understanding Excel's files -- Ch. 9. Using and creating templates -- Ch. 10. Printing your work -- Ch. 11. Introducing formulas and functions -- Ch. 12. Creating formulas that manipulate text -- Ch. 13. Working with dates and times -- Ch. 14. Creating formulas that count and sum -- Ch. 15. Creating formulas that look up values -- Ch. 16. Creating formulas for financial applications -- Ch. 17. Introducing array formulas -- Ch. 18. Performing magic with array formulas -- Ch. 19. Getting started making charts -- Ch. 20. Learning advanced charting -- Ch. 21. Visualizing data using conditional formatting -- Ch. 22. Enhancing your work with pictures and drawings -- Ch. 23. Customizing the quick access toolbar -- Ch. 24. Using custom number formats -- Ch. 25. Using data validation -- Ch. 26. Creating and using worksheet outlines -- Ch. 27. Linking and consolidating worksheets -- Ch. 28. Excel and the Internet -- Ch. 29. Sharing data with other applications -- Ch. 30. Using Excel in a workgroup -- Ch. 31. Protecting your work -- Ch. 32. Making your worksheets error-free -- Ch. 33. Using Microsoft query with external database files -- Ch. 34. Introducing pivot tables -- Ch. 35. Analyzing data with pivot tables -- Ch. 36. Performing spreadsheet what-if analysis -- Ch. 37. Analyzing data using goal seek and solver -- Ch. 38. Analyzing data with the analysis ToolPak -- Ch. 39. Introducing Visual Basic for applications -- Ch. 40. Creating custom worksheet functions -- Ch. 41. Creating UserForms -- Ch. 42. Using UserForm controls in a worksheet -- Ch. 43. Working with Excel events -- Ch. 44. VBA examples -- Ch. 45. Creating custom Excel add-ins |
| Summary |
Annotation This book is a single reference thats indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully 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 wont find anywhere elseJohn Walkenbach, aka "Mr. Spreadsheet," is one of the liworlds leading authorities on ExcelThoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration featuresIncludes a valuable CD-ROM with templates and worksheets from the bookNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file |
| Bibliography |
Includes bibliographical references and index |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) blmlsh |
|
Microsoft Excel (Computer file) fast |
| Subject |
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
COMPUTERS -- Desktop Applications -- Spreadsheets.
|
|
Business -- Computer programs
|
|
Electronic spreadsheets
|
| Form |
Electronic book
|
| ISBN |
9780470117088 |
|
0470117087 |
|
9786610740581 |
|
6610740585 |
|
