Microsoft Excel 2010: Data Analysis and Business Modeling 3rd Edition

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-character access code, including the hyphens. Set up your free Safari account (required), following the instructions on-screen. Enjoy unlimited access to your online edition of the Web! PLEASE NOTE: Each access code may only be redeemed once. Again, for assistance, please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 or 707-827-7019.

Master the business modeling and analysis techniques that help you transform data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical, scenario-focused guide-fully updated for Excel 2010. Use Waynes proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken Microsoft Excel 2010: Data Analysis and Business Modeling 3rd Edition - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and the recipient of more than 30 teaching awards. For the past 20 years, Wayne has also taught Fortune 500 companies how to use Excel to make smarter business decisions. He has written 15 books on Excel, management science, and mathematics in sports.

(Computer Bookshops Limited)

Introduction; What You Should Know Before Reading This Book; How to Use This Book; Using the Companion Content; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Errata and Book Support; We Want to Hear from You; Stay in Touch; Acknowledgments; Chapter 1: Whats New in Excel 2010; 1.1 Customizable Ribbon; 1.2 Sparklines; 1.3 Slicers; 1.4 PowerPivot; 1.5 New Excel Solver; 1.6 File Tab; 1.7 New Excel Functions; 1.8 New Equation Editor; 1.9 Improved Data Bars; 1.10 Paste Special Live Preview; Chapter 2: Range Names; 2.1 How Can I Create Named Ranges?; 2.2 Answers to This Chapters Questions; 2.3 Problems; Chapter 3: Lookup Functions; 3.1 Syntax of the Lookup Functions; 3.2 Answers to This Chapters Questions; 3.3 Problems; Chapter 4: The INDEX Function; 4.1 Syntax of the INDEX Function; 4.2 Answers to This Chapters Questions; 4.3 Problems; Chapter 5: The MATCH Function; 5.1 Answers to This Chapters Questions; 5.2 Problems; Chapter 6: Text Functions; 6.1 Text Function Syntax; 6.2 Answers to This Chapters Questions; 6.3 Problems; Chapter 7: Dates and Date Functions; 7.1 Answers to This Chapters Questions; 7.2 Problems; Chapter 8: Evaluating Investments by Using Net Present Value Criteria; 8.1 Answers to This Chapters Questions; 8.2 Problems; Chapter 9: Internal Rate of Return; 9.1 Answers to This Chapters Questions; 9.2 Problems; Chapter 10: More Excel Financial Functions; 10.1 Answers to This Chapters Questions; 10.2 Problems; Chapter 11: Circular References; 11.1 Answers to This Chapters Questions; 11.2 Problems; Chapter 12: IF Statements; 12.1 Answers to This Chapters Questions; 12.2 Problems; Chapter 13: Time and Time Functions; 13.1 Answers to This Chapters Questions; 13.2 Problems; Chapter 14: The Paste Special Command; 14.1 Answers to This Chapters Questions; 14.2 Problems; Chapter 15: Three-Dimensional Formulas; 15.1 Answers to This Chapters Questions; Chapter 16: The Auditing Tool; 16.1 Answers to This Chapters Questions; 16.2 Problems; Chapter 17: Sensitivity Analysis with Data Tables; 17.1 Answers to This Chapters Questions; 17.2 Problems; Chapter 18: The Goal Seek Command; 18.1 Answers to This Chapters Questions; 18.2 Problems; Chapter 19: Using the Scenario Manager for Sensitivity Analysis; 19.1 Answer to This Chapters Question; 19.2 Problems; Chapter 20: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; 20.1 Answers to This Chapters Questions; 20.2 Problems; Chapter 21: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions; 21.1 Answers to This Chapters Questions; 21.2 Problems; Chapter 22: The OFFSET Function; 22.1 Answers to This Chapters Questions; 22.2 Problems; Chapter 23: The INDIRECT Function; 23.1 Answers to This Chapters Questions; 23.2 Problems; Chapter 24: Conditional Formatting; 24.1 Answers to This Chapte...

(Computer Bookshops Limited)