Excel Data Analysis & Business Modeling Book/CD Package
av Wayne L Winston
Bloggar
- Format:
- Mixed media product
- Utgiven:
- 2004-01-01
- Språk:
- Engelska
Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You also get all the books problem-and-solution files on CDfor all the practice you need to solve complex problems and work smarter with Excel.
Learn how to solve real business problems with Excel!
- Create best, worst, and most-likely scenarios for sales
- Calculate how long it would take to recoup a projects startup costs
- Plan personal finances, such as computing loan terms or saving for retirement
- Estimate a products demand curve
- Simulate stock performance over a year
- Determine which product mix will yield the greatest profits
- Interpret the effects of price and advertising on sales
- Assign a dollar value to customer loyalty
- Manage inventory and order quantities with precision
- Create customer service queues with short wait times
- Estimate the probabilities of equipment failure
- Model business uncertainties
- Get new perspectives on data with PivotTable dynamic views
- Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more!
On the CD:
- Practice files for all the books exercises
- Solutions for problem sets
- Fully searchable eBook
(Computer Bookshops Limited)
Fler böcker av Wayne L Winston
|
|
|
|
|||
MathleticsWayne L Winston (inbunden) |
Practical Management ScienceWayne L Winston, S Albright (häftad) |
Microsoft Excel 2010: Data Analysis and Business Mod...Wayne L Winston (häftad) |
Financial Models Using Simulation and OptimizationWayne L Winston (häftad) | |||
|
204:- Köp
|
550:- Köp
|
248:- Köp
|
330:- Köp
|
Kundrecensioner
Bli först med att recensera och betygsätt boken Excel Data Analysis & Business Modeling Book/CD Package -
du kan vinna 200 kr varje vecka i tävlingen "Veckans recension".
Bloggat om Excel Data Analysis & Business Modeling Book/CD Package
Innehållsförteckning
IntroductionChapter 1: Range NamesChapter 2: Natural Language Range NamesChapter 3: Lookup FunctionsChapter 4: The INDEX FunctionChapter 5: The MATCH FunctionChapter 6: Text FunctionsChapter 7: Dates and Date FunctionsChapter 8: Evaluating Investments with Net Present Value CriteriaChapter 9: Internal Rate of ReturnChapter 10: Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT FunctionsChapter 11: Circular ReferencesChapter 12: IF StatementsChapter 13: The Paste Special CommandChapter 14: The Auditing ToolChapter 15: Sensitivity Analysis with Data TablesChapter 16: The Goal Seek CommandChapter 17: Using the Scenario Manager for Sensitivity AnalysisChapter 18: Creating and Using Spinners for Sensitivity AnalysisChapter 19: The COUNTIF, COUNT, COUNTA, and COUNTBLANK FunctionsChapter 20: The SUMIF FunctionChapter 21: The OFFSET FunctionChapter 22: The INDIRECT FunctionChapter 23: Conditional FormattingChapter 24: An Introduction to Optimization with the Excel SolverChapter 25: Using Solver to Determine the Optimal Product MixChapter 26: Using Solver to Solve Transportation or Distribution ProblemsChapter 27: Using Solver to Schedule Your WorkforceChapter 28: Using Solver for Capital BudgetingChapter 29: Using Solver for Financial PlanningChapter 30: Using Solver to Rate Sports TeamsChapter 31: Importing Text or Microsoft Word Data into ExcelChapter 32: Importing Data from the Web into ExcelChapter 33: Validating DataChapter 34: Summarizing Data with HistogramsChapter 35: Summarizing Data with Descriptive StatisticsChapter 36: Using PivotTables to Describe DataChapter 37: Summarizing Data with Database Statistical FunctionsChapter 38: Filtering DataChapter 39: Consolidating DataChapter 40: Creating SubtotalsChapter 41: Estimating Straight Line RelationshipsChapter 42: Modeling Exponential GrowthChapter 43: The Power CurveChapter 44: Using Correlations to Summarize RelationshipsChapter 45: Introduction to Multiple RegressionChapter 46: Incorporating Qualitative Factors into Multiple RegressionChapter 47: Modeling Nonlinearities and InteractionsChapter 48: Analysis of Variance: One-Way ANOVAChapter 49: Randomized Blocks and Two-Way ANOVAChapter 50: Using Moving Averages to Understand Time SeriesChapter 51: Forecasting with Moving AveragesChapter 52: Forecasting in the Presence of Special EventsChapter 53: An Introduction to Random VariablesChapter 54: The Binomial and Hypergeometric Random VariablesChapter 55: The Poisson and Exponential Random VariableChapter 56: The Normal Random VariableChapter 57: Weibull and Beta Distributions: Modeling Machine Life and Duration of a ProjectChapter 58: Introduction to Monte Carlo SimulationChapter 59: Calculating an Optimal BidChapter 60: Simulating Stock Prices and Asset Allocation ModelingChapter 61: Fun and Games: Simulating Gambling and Sporting Event ProbabilitiesChapter 62: Using Resampling to Analyze DataChapter 63: Pricing Stock OptionsChapter 64: Determining Customer ValueCha...
(Computer Bookshops Limited)
