#Ebook Deal/Day: Microsoft Excel 2010: Data Analysis and Business Modeling - $17.99 (Save 50%)

Publisher:?Microsoft Press

Released:?January 2011

Pages:?720

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 Wayne?s proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

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 Problems Chapter 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 Questions Problems 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 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 Questions Problems 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 Questions Problems 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 Answers to This Chapter?s Question Problems Chapter 31 Using Solver to Solve Transportation or Distribution Problems Answer to This Chapter?s Question Problems Chapter 32 Using Solver for Capital Budgeting Answer to This Chapter?s Question Problems Chapter 33 Using Solver for Financial Planning Answers to This Chapter?s Questions Problems Chapter 34 Using Solver to Rate Sports Teams Answer to This Chapter?s Question Problems Chapter 35 Warehouse Location and the GRG Multistart and Evolutionary Solver Engines Understanding the GRG Multistart and Evolutionary Solver Engines Answer to This Chapter?s Questions Problems Chapter 36 Penalties and the Evolutionary Solver Answers to This Chapter?s Questions Problems Chapter 37 The Traveling Salesperson Problem Answers to This Chapter?s Questions Problems Chapter 38 Importing Data from a Text File or Document Answers to This Chapter?s Question Problems Chapter 39 Importing Data from the Internet Answers to This Chapter?s Questions Problems Chapter 40 Validating Data Answers to This Chapter?s Questions Problems Chapter 41 Summarizing Data by Using Histograms Answers to This Chapter?s Questions Problems Chapter 42 Summarizing Data by Using Descriptive Statistics Answers to This Chapter?s Questions Problems Chapter 43 Using PivotTables and Slicers to Describe Data Answers to This Chapter?s Questions Problems Chapter 44 Sparklines Answers to This Chapter?s Questions Problems Chapter 45 Summarizing Data with Database Statistical Functions Answers to This Chapter?s Questions Problems Chapter 46 Filtering Data and Removing Duplicates Answers to This Chapter?s Questions Problems Chapter 47 Consolidating Data Answer to This Chapter?s Question Problems Chapter 48 Creating Subtotals Answers to This Chapter?s Questions Problems Chapter 49 Estimating Straight Line Relationships Answers to This Chapter?s Questions Problems Chapter 50 Modeling Exponential Growth Answers to This Chapter?s Question Problems Chapter 51 The Power Curve Answer to This Chapter?s Question Problems Chapter 52 Using Correlations to Summarize Relationships Answer to This Chapter?s Question Problems Chapter 53 Introduction to Multiple Regression Answers to This Chapter?s Questions Chapter 54 Incorporating Qualitative Factors into Multiple Regression Answers to This Chapter?s Questions Chapter 55 Modeling Nonlinearities and Interactions Answers to This Chapter?s Questions Problems for Through Chapter 56 Analysis of Variance: One-Way ANOVA Answers to This Chapter?s Questions Problems Chapter 57 Randomized Blocks and Two-Way ANOVA Answers to This Chapter?s Questions Problems Chapter 58 Using Moving Averages to Understand Time Series Answers to This Chapter?s Question Problem Chapter 59 Winters?s Method Time Series Characteristics Parameter Definitions Initializing Winters?s Method Estimating the Smoothing Constants Remarks Problems Chapter 60 Ratio-to-Moving-Average Forecast Method Answers to This Chapter?s Questions Problem Chapter 61 Forecasting in the Presence of Special Events Answers to This Chapter?s Questions Problems Chapter 62 An Introduction to Random Variables Answers to This Chapter?s Questions Problems Chapter 63 The Binomial, Hypergeometric, and Negative Binomial Random Variables Answers to This Chapter?s Questions Problems Chapter 64 The Poisson and Exponential Random Variable Answers to This Chapter?s Questions Problems Chapter 65 The Normal Random Variable Answers to This Chapter?s Questions Problems Chapter 66 Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project Answers to This Chapter?s Questions Problems Chapter 67 Making Probability Statements from Forecasts Answers to This Chapter?s Questions Problems Chapter 68 Using the Lognormal Random Variable to Model Stock Prices Answers to This Chapter?s Questions Problems Chapter 69 Introduction to Monte Carlo Simulation Answers to This Chapter?s Questions Problems Chapter 70 Calculating an Optimal Bid Source: http://feedproxy.google.com/~r/oreilly/mspebookdeal/~3/xXH_oEkNFYY/0790145301192.do ryan zimmerman oscars red carpet jennifer lopez wardrobe malfunction emma stone hugo hugo nfl combine Subscribe to: Post Comments (Atom) Followers Blog Archive ►  2013 (35) ►  July (3) ►  June (5) ►  April (15) ►  March (1) ►  January (11) ▼  2012 (865) ►  December (42) ►  November (64) ►  October (54) ►  September (82) ►  August (32) ►  July (102) ►  June (53) ►  May (96) ►  April (153) ▼  March (118) If you're looking to buy, build, or improve a ... Annan urges Syrian government as 'stronger party' ... Finance a Better Resolution for Payday Fiscal loan... IPO market heats up, more startups going public Stay Home & Have Fun | Top TV Stuff Household Then They Ponder Why Their Cat Is Apparently Hungr... Scientists reveal genetic mutation depicted in van... New CEO at IBM revives Augusta membership debate Investing 101: Chinese Stocks with Conflicting Sma... Important Details Relating To Colon Cancer Treatme... LG 55LK520 55-Inch 1080p 120 Hz LCD HDTV Reviews |... Gael Garcia Bernal Faces 'Twittervention' In New A... Verizon's CEO has a plan for wireless pay-TV, if t... Issues You May Face Having An Accident With A Fina... Specialist Lighting Solutions | Home Improvement P... Gymnastics - The Epitome of Sport Breast Cancer Politics: Does Komen Finally Deserve... Inside the Mummification of Space Shuttle Discovery Believe It Or Not, Earn money Web surveys Really w... Newsmakers and links: Mar. 26, 2012 - Michiguide.c... AppFirst Unveils New Initiatives to Deliver Busine... ASUS teases 'awesome new features' for Transformer... Pope heads to Cuba to shore up Catholic Church AP Enterprise: Vegas rail: a gamble or good thing? PC Magazine Debuts on the iPad | Your Shopping Res... asics ? Blog Archive ? mulberry outlets Automotive... Cervical cancer test kit jumps Asian cultural hurdles Which social networks do you use regularly on your... ?Screenshots Of Despair? Reveals The New Human Con... asics ? Blog Archive ? burberry shirts Real Estate... High blood sugar lowers chances of surviving a hea... Irenetindia.org | Fighting Heart Disease: Preservi... SmartFren Andro 4 HP Android CDMA Terbaru Obama taps public health expert for World Bank How to Protect Your Privacy During Your Workers&#3... mashsocialmedia: 11 Hilarious 'Mad Men' Parody Twi... How to Select the Best Contact Lenses ? SpinPad Home Lighting Uplifts Interior and Exterior Decora... Who knew? Fruit flies get kidney stones too, may h... Video: French gunman dead in leap from window Nas Is Aiming For 'Something Different' On Life Is... The Better Bacon Book: Bacon on Bacon on Bacon on ... Approaches to Cease Disturbing Anxiety attacks | L... asics ? Blog Archive ? tiger asics Business Market... Smartphone Use Among College Students Concerns Som... For Your Business Retail Distribution Review Finan... The Media Are Invited to Attend the FIRST ... - AZ... Scientists explain pileups of gigantic alien worlds asics ? Blog Archive ? ?? ?????? Health and Fitnes... Aziz Ansari releases comedy special online for $5 The Exciting Future for Writers | Mystery Writing ... Procuring Home Equity Loans | Spot The Fox On Writing vs. Speaking ? Scott Berkun Researchers: Wallenberg Budapest mission no fluke Mitt Romney stumps in Illinois ahead of primary (W... Pioneer launches RMX1000 Remix Station, now no tun... Can anyone help with business presentation? - Bill... Specifics of the value of your dog's diet and ... Marcel Hirscher wins World Cup overall title Feelin? lucky on St. Patrick?s Day? Try these iPho... Kurds say Exxon still working in North Iraq Things To Look For In An SEO Company | Host a Webs... 15 things you didn't know about Ireland iPad 2 trade-ins: Pick cash, gift card, PayPal Time Lapse Saint Petersburg (Theagitator) The Business Limitations To Entrepreneurialism | T... Asian Apple fans snap up new iPad on 1st day Hatch Fares Well in Utah Caucuses (Taegan Goddard'... Tendulkar scores cricket's first 100th century Hollywood producers to gain honors at GLAAD awards How to attack 34 liquor business market ? enterpri... Natural Remedies For Back Pain | Article Monkey Sponsored By: Insert Coin: Help some dudes make a robot fighting... COMMUNICATIONS ARTICLES ? An Introduction to Vehic... HTC Vivid Ice Cream Sandwich update starting to tr... Learn Something About Estate Planning Today ? Cute... The robby cruz blog ? The way to readily help save... Working Out To Lose Weight ? Useful ... - New Heal... Discover How Internet Marketing Can be Beneficial ... Career Transition Ministry Resume Search And Job Posting ? Two Techniques To ... The Benefits Of Commercial Real Estate | Article G... Promising new drug target for kidney disease Afghan civilian deaths could delay strategic pact ... Village Real Estate Nashville News You Can Use! | ... Pricing Strategic Business Plans | Women In Sales Sudan investment conference called off as US pulls... Healthy Soup Recipes ? How they can help you lose ... #Ebook Deal/Day: Microsoft Excel 2010: Data Analys... Stalk Team Gizmodo on Twitter [Twitter] CARPE DIEM: Has the Real Estate Market Finally Bot... PFT: If Peyton picks Broncos, what next for Tebow? Asteroid 2012 DA14 definitely won't hit Earth. So ... Fashion Friday: Review & Giveaway ? Bella on the B... Joomla Ideal for Scaling Small Companies | seealiv... EzineArticles Alert: Arts-and-Entertainment:Philos... Can easily Video gaming Increase your Round of gol... How you can Accomplish Commitment In a Relationship Florida Baptist Convention theological education s... ►  February (50) ►  January (19) ►  2011 (725) ►  December (33) ►  November (94) ►  October (98) ►  September (68) ►  August (106) ►  July (11) ►  June (96) ►  May (219) About Me nupiily View my complete profile Simple theme. Powered by Blogger.