| Description |
1 online resource (721 pages) |
| Contents |
Table of Contents; Introduction; What You Should Know Before Reading This Book; Chapter 1. What's New in Excel 2010; Customizable Ribbon; Sparklines; Slicers; PowerPivot; New Excel Solver; File Tab; New Excel Functions; New Equation Editor; Improved Data Bars; Paste Special Live Preview; Chapter 2. Range Names; How Can I Create Named Ranges?; Answers to This Chapter's Questions; Problems; Chapter 3. Lookup Functions; Syntax of the Lookup Functions; Answers to This Chapter's Questions; Problems; Chapter 4. The INDEX Function; Syntax of the INDEX Function; Answers to This Chapter's Questions |
|
ProblemsChapter 5. The MATCH Function; Answers to This Chapter's Questions; Problems; Chapter 6. Text Functions; Text Function Syntax; Answers to This Chapter's Questions; Problems; Chapter 7. Dates and Date Functions; Answers to This Chapter's Questions; Problems; Chapter 8. Evaluating Investments by Using Net Present Value Criteria; Answers to This Chapter's Questions; Problems; Chapter 9. Internal Rate of Return; Answers to This Chapter's Questions; Problems; Chapter 10. More Excel Financial Functions; Answers to This Chapter's Questions; Problems; Chapter 11. Circular References |
|
Answers to This Chapter's QuestionsProblems; Chapter 12. IF Statements; Answers to This Chapter's Questions; Problems; Chapter 13. Time and Time Functions; Answers to This Chapter's Questions; Problems; Chapter 14. The Paste Special Command; Answers to This Chapter's Questions; Problems; Chapter 15. Three-Dimensional Formulas; Answers to This Chapter's Questions; Problems; Chapter 16. The Auditing Tool; Answers to This Chapter's Questions; Problems; Chapter 17. Sensitivity Analysis with Data Tables; Answers to This Chapter's Questions; Problems; Chapter 18. The Goal Seek Command |
|
Answers to This Chapter's QuestionsProblems; Chapter 19. Using the Scenario Manager for Sensitivity Analysis; Answer to This Chapter's Question; Problems; Chapter 20. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; Answers to This Chapter's Questions; Problems; Chapter 21. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions; Answers to This Chapter's Questions; Problems; Chapter 22. The OFFSET Function; Answers to This Chapter's Questions; Problems; Chapter 23. The INDIRECT Function; Answers to This Chapter's Questions; Problems; Chapter 24. Conditional Formatting |
|
Answers to This Chapter's QuestionsProblems; Chapter 25. Sorting in Excel; Answers to This Chapter's Questions; Problems; Chapter 26. Tables; Answers to This Chapter's Questions; Problems; Chapter 27. Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes; Answers to This Chapter's Questions; Problems; Chapter 28. An Introduction to Optimization with Excel Solver; Problems; Chapter 29. Using Solver to Determine the Optimal Product Mix; Answers to This Chapter's Questions; Problems; Chapter 30. Using Solver to Schedule Your Workforce |
| Summary |
Customer Service Note: We are sorry for the inconvenience, but the voucher with the online access code is missing from the first printing of this title. However, we do have the code, available upon request. Please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 to obtain your 24-character access code. This code will give you access to your online edition of this Microsoft Press book that is hosted on Safari Books Online! Once you have obtained your unique access code: Go to http://microsoftpress.oreilly.com/?safarienabled and enter your unique 24-char |
| Notes |
Answers to This Chapter's Question |
|
Print version record |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) fast |
| Subject |
Industrial management -- Computer programs -- Statistical methods
|
|
Decision making -- Computer programs
|
|
Decision making -- Computer programs
|
|
Management.
|
|
Business & Economics.
|
|
Management Theory.
|
| Form |
Electronic book
|
| ISBN |
9780735660298 |
|
0735660298 |
|
