Microsoft Excel 2010 Data Analysis And Business Modeling

0.0

This book helps to solve business problems and to make better decisions. One can learn how to use Excel more effectively. Key Features of the book : ?Model investment risks and returns ?Analyze your sales team’s effectiveness ?Create best, worst, and most-likely case scenarios ?Compare lease vs. buy, and calculate loan terms ?See how price, advertising, and seasonality affect sales ?Managing inventory with precision ?Quantify the value of customer loyalty ?Calculate your break-even number and ROI ?Maximize scheduling efficiency ?Express ��home-field advantage” in real numbers ?Project company growth; predict election results, and more! ?Plus—introduce yourself to PowerPivot for Excel Table of contents Introduction  1. What's New in Excel 2010  2 Range Names  3 Lookup Functions  4 The INDEX Function  5 The MATCH Function 6 Text Functions  7 Dates and Date Functions  8 Evaluating Investments by Using Net Present Value Criteria  9 Internal Rate of Return  10 More Excel Financial Functions  11 Circular References  12 I F Statements  13 Time and Time Functions  14 The Paste Special Command  15 Three-Dimensional Formulas  16 The Auditing Tool  17 Sensitivity Analysis with Data Tables  18 The Goal Seek Command  19 Using the Scenario Manager for Sensitivity Analysis  20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions  21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions  22 The OFFSET Function  23 The INDIRECT Function  24 Conditional Formatting  25 Sorting in Excel  26 Tables  27 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes  28 An Introduction to Optimization with Excel Solver  29 Using Solver to Determine the Optimal Product Mix  30 Using Solver to Schedule Your Workforce  31 Using Solver to Solve Transportation or Distribution Problems  32 Using Solver for Capital Budgeting  33 Using Solver for Financial Planning  34 Using Solver to Rate Sports Teams  35 Warehouse Location and the GRG Multistart and Evolutionary Solver Engines  36 Penalties and the Evolutionary Solver  37 The Traveling Salesperson Problem  38 Importing Data from a Text File or Document 39 Importing Data from the Internet  40 Validating Data  41 Summarizing Data by Using Histograms 42 Summarizing Data by Using Descriptive Statistics 43 Using PivotTables and Slicers to Describe Data  44 Sparklines  45 Summarizing Data with Database Statistical Functions  46 Filtering Data and Removing Duplicates  47 Consolidating Data  48 Creating Subtotals  49 Estimating Straight Line Relationships  50 Modeling Exponential Growth  51 The Power Curve  52 Using Correlations to Summarize Relationship .  53 Introduction to Multiple Regression  54 Incorporating Qualitative Factors into Multiple Regression  55 Modeling Nonlinearities and Interactions  56 Analysis of Variance: One-Way ANOVA  57 Randomized Blocks and Two-Way ANOVA  58 Using Moving Averages to Understand Time Series  59 Winters's Method  60 Ratio-to-Moving-Average Forecast Method  61 Forecasting in the Presence of Special Events  62 An Introduction to Random Variables  63 The Binomial, Hypergeometric, and Negative Binomial Random Variables  64 The Poisson and Exponential Random Variable  65 The Normal Random Variable  66 Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project  67 Making Probability Statements from Forecasts  68 Using the Lognormal Random Variable to Model Stock Prices  69 Introduction to Monte Carlo Simulation  70 Calculating an Optimal Bid  71 Simulating Stock Prices and Asset Allocation Modeling  72 Fun and Games: Simulating Gambling and Sporting Event Probabilities  73 Using Resampling to Analyze Data  74 Pricing Stock Options  75 Determining Customer Value  76 The Economic Order Quantity Inventory Model  77 Inventory Modeling with Uncertain Demand  78 Queuing Theory: The Mathematics of Waiting in Line  79 Estimating a Demand Curve  80 Pricing Products by Using Tie-Ins  81 Pricing Products by Using Subjectively Determined Demand 82 Nonlinear Pricing  83 Array Formulas and Functions  84 PowerPivot  Index