By Wayne Winston

Grasp enterprise modeling and research innovations with Microsoft Excel 2013, and remodel information into bottom-line effects. Written through award-winning educator Wayne Winston, this hands-on, scenario-focused advisor indicates you ways to exploit the newest Excel instruments to combine info from a number of tables—and how one can successfully construct a relational facts resource inside of an Excel workbook.
Solve genuine enterprise issues of Excel—and sharpen your edge
Summarize facts with PivotTables and Descriptive Statistics.
Explore new developments in predictive and prescriptive analytics.
Use Excel development Curves, a number of regression, and exponential smoothing.
Master complicated Excel features equivalent to OFFSET and INDIRECT.
Delve into key monetary, statistical, and time functions.
Make your charts more desirable with the ability View tool.
Tame advanced optimization issues of Excel Solver.
Run Monte Carlo simulations on inventory costs and bidding models.
Apply very important modeling instruments comparable to the Inquire add-in.

Show description

Read or Download Microsoft Excel 2013 Data Analysis and Business Modeling PDF

Best e-commerce books

Search Engine Optimization - An Hour A Day

Impression seek engine effects and convey particular site visitors on your site with an hour an afternoon of search engine marketing (SEO). Drawing on years of expertise as profitable website positioning experts, Jennifer Grappone and Gradiva Couzin supply distinct, sensible, and sometimes strangely basic ideas for making improvements to effects.

B-to-B Electronic Marketplaces: Successful Introduction in the Chemical Industry

The creation of the net originated not just the institution of an alternate channel for the promoting and promoting of goods, yet much more importantly, it serves as a platform to establish B-to-B E-marketplaces. This improvement permits dealers and dealers to innovate whole enterprise procedures.

Geschäftsmodelle in Industrie 4.0 und dem Internet der Dinge: Der Weg vom Anspruch in die Wirklichkeit

Timothy Kaufmann beschreibt verschiedene Geschäftsmodelle, Kundenbeispiele und geeignete Werkzeuge für die Umsetzung von Industrie four. zero und dem web der Dinge, die schon heute große Chancen für neue Geschäftsmodelle und die Optimierung von bestehenden bieten. Das vorliegende crucial soll Sie ermutigen, sich jetzt auf den Weg zu begeben!

Additional resources for Microsoft Excel 2013 Data Analysis and Business Modeling

Example text

In column B, compute the cash flows for each year. 2. In column C, compute the cumulative cash flows for each year. Now you can use the MATCH function (with match type=1) to determine the row number of the first year in which cumulative cash flow is positive. This calculation gives you the payback period. The cells in B1:B3 have the range names listed in A1:A3. Year 0 cash flow (–Initial_investment) is entered in cell B5. Year 1 cash flow (Year_1_cf) is entered in cell B6. Copying the B6*(1+Growth) formula from B7 to B8:B20 computes the cash flow for Year 2 through Year 15.

Now look at some specific examples of how to use range names. xlsx. Answers to this chapter’s questions This section provides the answers to the questions that are listed at the beginning of the chapter. I want the total sales in Arizona, California, Montana, New York, and New Jersey. Can I use a formula to compute the total sales in a form such as AZ+CA+MT+NY+NJ instead of SUM(A21:A25) and still get the right answer? xlsx file, in which you assigned each state’s abbreviation as the range name for the state’s sales.

Text values must be enclosed in quotation marks (“”). In cell B14, the MATCH(“Phoenix”,B4:B11,0) formula returns 7 because cell B10 (the seventh cell in B4:B11) is the first cell in the range that matches Phoenix. In cell E12, the MATCH(0,E4:E11,1) formula returns 4 because the last number that is less than or equal to 0 in the E4:E11 range is in cell E7 (the fourth cell in the lookup range). In cell G12, the MATCH(–4,G4:G11,–1) formula returns 7 because the last number that is greater than or equal to –4 in the G4:G11 range is contained in cell G10 (the seventh cell in the lookup range).

Download PDF sample

Rated 4.93 of 5 – based on 42 votes