MICROSOFT EXCE L 2013: DATA ANALYSIS AND BUSINESS BUSINESS MODELING, By WINSTON, WAYNE L. About The Book Price: Rs. 795.00 Rs. 795.00 ISBN: 978-81-203-4960-5 ISBN: 978-81-203-4960-5 Pages: 808 Pages: 808 Binding: Paper Binding: Paper Back
DESCRIPTION
Master busi busi ness modeli modeli ng and anal ysis te techniques chniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to to effectively effectively buil d a rela tional data source ins ide an Excel workbook. Solve real busi ness problems with Excel—and sharpen your edge • • • • • • • • •
Summarize data with Summarize with PivotTables PivotTables and Descriptive Statistics Explore new tren trends ds in predictive predictive and prescriptive prescriptive analytics Use Excel Trend Trend Curves, multipl e regressi on, and exponential exponential smoothing Master advanced Excel Excel functions functions such as OFFSET OFFSET and INDIRECT INDIRECT Delve into key financi al, statistical , and time functions Make your charts more effective effective with with the Power View tool Tame complex optimiza tion probl ems with Excel Solver Run Mont Monte e Carlo si mulations on stock prices and bidding mode models ls Apply App ly important mode modeli li ng tools such as the the Inquire add-in
CONTENTS
Introduction
Chapter 1 Range names Chapter 2 Lookup functions Chapter 3 INDEX function Chapter 4 MATCH function Chapter 5 Text functions Chapter 6 Dates and date functions Chapter 7 Evaluating investments by using net present value criteria Chapter 8 Internal rate of return Chapterr 9 More Excel financi al functions Chapte Chapterr 10 Circul ar refe Chapte reference rencess Chapter 11 IF statements Chapter 12 Time and time functions Chapter 13 The Paste Special command Chapterr 14 Three-dime Chapte Three-dimensional nsional formu formulas las Chapterr 15 The Auditing Chapte Auditing tool a nd Inquire a dd-in Chapter 16 Sensitivity analysis with data tables Chapter 17 The Goal Seek command Chapterr 18 Using the Scenario Chapte Scenario Manager for sensitivity anal ysis Chapter 19 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions Chapter 20 The SUMIF, AVERAG AVERAGEIF, EIF, SUMIFS, a nd AVERAGEIFS AVERAGEIFS functi ons Chapter 21 The OFFSET function Chapter 22 The INDIRECT function Chapterr 23 Conditional formatt Chapte formatting ing Chapterr 24 Sorting in Excel Chapte Chapter 25 Tables Chapterr 26 Spinner buttons, Chapte buttons, scroll bars, option buttons, buttons, check boxes, combo boxes, and group li st boxes Chapterr 27 The analytics revolution Chapte Chapterr 28 Introducing optimization with Excel Solver Chapte Chapter 29 Using Solver to determine the optimal product mix Chapter 30 Using Solver to schedule your workforce Chapterr 31 Using Solver to solve transportation or distri bution problems Chapte problems Chapterr 32 Using Solver for ca pital budge Chapte budgeting ting Chapter 33 Using Solver for financial planning Chapter 34 Using Solver to rate sports teams Chapterr 35 Warehouse location and the GRG Multistart Chapte Multistart and Evolutionary Solver eng engines ines Chapterr 36 Penalties and the Evolutionary Chapte Evolutionary Solver Chapterr 37 The traveling Chapte traveling sal espe esperson rson probl em Chapter 38 Importing data from a text file or document Chapter 39 Importing data from the Internet Chapterr 40 Val idating data Chapte Chapterr 41 Sum Chapte Summarizing marizing data by usi ng histograms
Chapter 42 Summarizing data by usi ng descri Chapter descri ptive statistics Chapterr 43 Using Pi votT Chapte votTables ables a nd sli cers to descri descri be data data Chapter 44 The Data Model Chapter 45 PowerPivot Chapter 46 Power View Chapterr 47 Sparkli nes Chapte Chapterr 48 Summarizing data with database statis tical functions Chapte Chapterr 49 Filtering data a nd removing Chapte removing dupli cates Chapterr 50 Consol idating data Chapte Chapterr 51 Creating subtotals Chapte subtotals Chapterr 52 Charting tri cks Chapte Chapterr 53 Estimating straight-line relationshi ps Chapte Chapter 54 Modeling exponential growth Chapter 55 The power curv e Chapterr 56 Usi ng correlations to summarize relationships Chapte Chapterr 57 I ntrod Chapte ntroduction uction to multipl e regressi regressi on Chapterr 58 I ncorporating quali tative factors into multiple regressi Chapte regressi on Chapterr 59 Modeling nonlineari ties and interactions Chapte Chapter 60 Analysis of variance: one-way ANOVA Chapter 61 Randomized blocks and two-way ANOVA Chapter 62 Using moving averages to understand time series Chapter 63 Winters’s method Chapter 64 Ratio-to-moving-average forecast method Chapter 65 Forecasting in the presence of special events Chapterr 66 An introduction Chapte introduction to ra ndom variables Chapterr 67 The binomial Chapte binomial , hypergeom hypergeomet etric, ric, and negative binomial random varia bles Chapterr 68 The Poisson and exponential Chapte exponential random varia ble Chapterr 69 The normal Chapte normal r andom variabl e Chapterr 70 Weibull and beta Chapte beta dis tributions: modeling modeling machine life and duration of a project Chapterr 71 Making probabil ity s tate Chapte tateme ments nts from forecasts Chapterr 72 Using the lognormal Chapte lognormal random varia ble to model model stock pri ces Chapterr 73 Introduction to Monte Chapte Monte Carlo s imulation Chapter 74 Calculating an optimal bid Chapterr 75 Simulating stock pri ces and ass et all ocation modeli Chapte modeli ng Chapterr 76 Fun and games: simulating gambling a nd sporting event Chapte event probabili ties Chapterr 77 Using resampli ng to analyze data Chapte Chapterr 78 Pri cing s tock options Chapte options Chapter 79 Determining customer value Chapter 80 The economic order quantity inventory model Chapter 81 Inventory modeling with uncertain demand Chapter 82 Queuing theory: the mathematics of waiting in line Chapter 83 Estimating a demand curve Chapterr 84 Pri cing products by using tie-ins Chapte Chapterr 85 Pric ing products by using s ubjectively determ Chapte determined ined demand demand Chapterr 86 Nonlinear pri cing Chapte Chapterr 87 Array formulas and functions Chapte
Index
PHI Learning Private Limited © 2011. 2011. Email:
[email protected] For more information visit : www.phindia.com