Microsoft Excel Data Analysis and Business Modeling
Search in google:
This practical, business-focused guide delivers the best of Winston's classroom experience in 70+ concise chapters, organized by real-world scenarios. Quickly find and apply exactly the information needed to solve a specific business problem—from asset allocation modeling to estimating exponential growth, forecasting sales, optimizing portfolios, and other critical functions. All the book's sample files are contained on the CD-ROM.
Introduction1Range Names12Natural Language Range Names113Lookup Functions154The INDEX Function235The MATCH Function276Text Functions337Dates and Date Functions438Evaluating Investments with Net Present Value Criteria519Internal Rate of Return5910Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions6711Circular References7712IF Statements8313The Paste Special Command9914The Auditing Tool10715Sensitivity Analysis with Data Tables11516The Goal Seek Command12917Using the Scenario Manager for Sensitivity Analysis13718Creating and Using Spinners for Sensitivity Analysis14319The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions15120The SUMIF Function15921The OFFSET Function16322The INDIRECT Function17523Conditional Formatting18124An Introduction to Optimization with the Excel Solver19125Using Solver to Determine the Optimal Product Mix19726Using Solver to Solve Transportation or Distribution Problems20927Using Solver to Schedule Your Workforce21528Using Solver for Capital Budgeting22129Using Solver for Financial Planning22730Using Solver to Rate Sports Teams23331Importing Text or Microsoft Word Data into Excel23932Importing Data from the Web into Excel24533Validating Data25334Summarizing Data with Histograms26135Summarizing Data with Descriptive Statistics27136Using PivotTables to Describe Data28137Summarizing Data with Database Statistical Functions30538Filtering Data31539Consolidating Data32340Creating Subtotals32941Estimating Straight Line Relationships33342Modeling Exponential Growth34143The Power Curve34544Using Correlations to Summarize Relationships35145Introduction to Multiple Regression35746Incorporating Qualitative Factors into Multiple Regression36547Modeling Nonlinearities and Interactions37548Analysis of Variance: One-Way ANOVA38149Randomized Blocks and Two-Way ANOVA38750Using Moving Averages to Understand Time Series39751Forecasting with Moving Averages40152Forecasting in the Presence of Special Events40953An Introduction to Random Variables41954The Binomial and Hypergeometric Random Variables42555The Poisson and Exponential Random Variable43356The Normal Random Variable43757Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project44758Introduction to Monte Carlo Simulation45359Calculating an Optimal Bid46360Simulating Stock Prices and Asset Allocation Modeling46961Fun and Games: Simulating Gambling and Sporting Event Probabilities47962Using Resampling to Analyze Data48963Pricing Stock Options49364Determining Customer Value50765The Economic Order Quantity Inventory Model51366Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder?51967Queuing Theory: The Mathematics of Waiting in Line52568Estimating a Demand Curve53369Pricing Products with Tie-ins53970Pricing Products Using Subjectively Determined Demand54371Nonlinear Pricing54772Array Formulas and Functions55573Picking Your Fantasy Football Team573Index581
