Download Microsoft Excel 2013: Data Analysis and Business Modeling by Wyane Wilson PDF

By Wyane Wilson

Grasp enterprise modeling and research concepts with Microsoft Excel 2013, and rework facts into bottom-line effects. Written by means of award-winning educator Wayne Winston, this hands-on, scenario-focused advisor indicates you the way to exploit the most recent Excel instruments to combine facts from a number of tables—and the best way to successfully construct a relational facts resource within an Excel workbook.

Solve genuine enterprise issues of Excel—and sharpen your edge

Summarize info with PivotTables and Descriptive Statistics
discover new tendencies in predictive and prescriptive analytics
Use Excel pattern Curves, a number of regression, and exponential smoothing
grasp complicated Excel services comparable to OFFSET and INDIRECT
Delve into key monetary, statistical, and time functions
Make your charts more advantageous with the ability View tool
Tame advanced optimization issues of Excel Solver
Run Monte Carlo simulations on inventory costs and bidding models
practice vital modeling instruments corresponding to the Inquire add-in

Table of Contents
Chapter 1. diversity names
Chapter 2. look up functions
Chapter three. INDEX function
Chapter four. fit function
Chapter five. textual content functions
Chapter 6. Dates and date functions
Chapter 7. comparing investments through the use of internet current price criteria
Chapter eight. inner fee of return
Chapter nine. extra Excel monetary functions
Chapter 10. round references
Chapter eleven. IF statements
Chapter 12. Time and time functions
Chapter thirteen. The Paste distinct command
Chapter 14. 3-dimensional formulas
Chapter 15. The Auditing instrument and Inquire add-in
Chapter sixteen. Sensitivity research with information tables
Chapter 17. The target search command
Chapter 18. utilizing the situation supervisor for sensitivity analysis
Chapter 19. The COUNTIF, COUNTIFS, count number, COUNTA, and COUNTBLANK functions
Chapter 20. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
Chapter 21. The OFFSET function
Chapter 22. The oblique function
Chapter 23. Conditional formatting
Chapter 24. Sorting in Excel
Chapter 25. Tables
Chapter 26. Spinner buttons, scroll bars, choice buttons, money bins, combination bins, and staff record boxes
Chapter 27. The analytics revolution
Chapter 28. Introducing optimization with Excel Solver
Chapter 29. utilizing Solver to figure out the optimum product mix
Chapter 30. utilizing Solver to agenda your workforce
Chapter 31. utilizing Solver to resolve transportation or distribution problems
Chapter 32. utilizing Solver for capital budgeting
Chapter 33. utilizing Solver for monetary planning
Chapter 34. utilizing Solver to fee activities teams
Chapter 35. Warehouse situation and the GRG Multistart and Evolutionary Solver engines
Chapter 36. consequences and the Evolutionary Solver
Chapter 37. The touring salesclerk problem
Chapter 38. uploading information from a textual content dossier or document
Chapter 39. uploading facts from the Internet
Chapter forty. Validating data
Chapter forty-one. Summarizing info by utilizing histograms
Chapter forty two. Summarizing facts through the use of descriptive statistics
Chapter forty three. utilizing PivotTables and slicers to explain data
Chapter forty four. the information Model
Chapter forty five. PowerPivot
Chapter forty six. strength View
Chapter forty seven. Sparklines
Chapter forty eight. Summarizing information with database statistical functions
Chapter forty nine. Filtering information and removal duplicates
Chapter 50. Consolidating data
Chapter fifty one. developing subtotals
Chapter fifty two. Charting tricks
Chapter fifty three. Estimating straight-line relationships
Chapter fifty four. Modeling exponential growth
Chapter fifty five. the ability curve
Chapter fifty six. utilizing correlations to summarize relationships
Chapter fifty seven. creation to a number of regression
Chapter fifty eight. Incorporating qualitative components into a number of regression
Chapter fifty nine. Modeling nonlinearities and interactions
Chapter 60. research of variance: one-way ANOVA
Chapter sixty one. Randomized blocks and two-way ANOVA
Chapter sixty two. utilizing relocating averages to appreciate time series
Chapter sixty three. Winters’s method
Chapter sixty four. Ratio-to-moving-average forecast method
Chapter sixty five. Forecasting within the presence of certain events
Chapter sixty six. An advent to random variables
Chapter sixty seven. The binomial, hypergeometric, and destructive binomial random variables
Chapter sixty eight. The Poisson and exponential random variable
Chapter sixty nine. the conventional random variable
Chapter 70. Weibull and beta distributions: modeling computing device existence and period of a project
Chapter seventy one. Making likelihood statements from forecasts
Chapter seventy two. utilizing the lognormal random variable to version inventory prices
Chapter seventy three. creation to Monte Carlo simulation
Chapter seventy four. Calculating an optimum bid
Chapter seventy five. Simulating inventory costs and asset allocation modeling
Chapter seventy six. enjoyable and video games: simulating playing and carrying occasion probabilities
Chapter seventy seven. utilizing resampling to research data
Chapter seventy eight. Pricing inventory options
Chapter seventy nine. picking out buyer value
Chapter eighty. the industrial order volume stock model
Chapter eighty one. stock modeling with doubtful demand
Chapter eighty two. Queuing concept: the math of ready in line
Chapter eighty three. Estimating a requirement curve
Chapter eighty four. Pricing items through the use of tie-ins
Chapter eighty five. Pricing items by utilizing subjectively decided demand
Chapter 86. Nonlinear pricing
Chapter 87. Array formulation and capabilities

Show description

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

Similar microsoft books

Microsoft Dynamics AX 2012 Development Cookbook

Improve robust, profitable Dynamics AX initiatives with effective X++ code with this e-book and booklet. confirmed recipes that may be reused in different winning Dynamics AX tasks. Covers common ledger, bills payable, money owed receivable, undertaking modules and normal performance of Dynamics AX. step by step directions and valuable screenshots for simple studying.

MCSA/MCSE: Exchange Server 2003 Implementation and Management Study Guide (Exam 70-284)

This is the publication you must organize for the enforcing and handling Microsoft alternate Server 2003 examination (70-284). This learn consultant used to be built to satisfy the exacting standards of cutting-edge certification applicants. as well as the constant and available educational procedure that earned Sybex the "Best learn consultant" designation within the 2003 CertCities Readers selection Awards, this booklet provides:Clear and concise details on handling an trade community surroundings sensible examples and insights drawn from real-world adventure you are going to additionally locate authoritative insurance of key examination subject matters, including:Installing, Configuring and Troubleshooting alternate Server 2003 dealing with, tracking, and Troubleshooting alternate Server desktops coping with, tracking, and Troubleshooting trade association dealing with protection within the alternate surroundings coping with recipient gadgets and tackle Lists handling and tracking applied sciences that help alternate Server 2003

Creating a Presentation in PowerPoint: Visual QuickProject Guide

PowerPoint is almost ubiquitous in trendy international - in enterprise settings, after all, yet in faculties and universities, golf equipment and firms - virtually in every single place you switch. it isn't a tricky software to exploit, however the shows humans create in PowerPoint variety broadly in caliber - striking or uninteresting, enlivening or enervating.

Additional info for Microsoft Excel 2013: Data Analysis and Business Modeling

Sample text

Preview box. Many dialog boxes show an image that reflects the options you select. 30 31 [ Team LiB ] [ Team LiB ] Using Task Panes When you start an Office program, a task pane appears by default on the right or left side of the program window. The task pane displays various options that relate to the current task. There are several types of options available in the task pane. You can search for information, select options, and click links, like the ones on a Web page, to perform commands. You can also display different task panes, move back and forward between task panes, and close a task pane to provide a larger work area.

You can also click the buttons on the taskbar to switch between open workbooks and other Office documents. Resize and Move a Window All windows contain the same sizing buttons: • Maximize button. Click to make a window fill the entire screen. • Restore Down button. Click to reduce a maximized window to a reduced size. • Minimize button. Click to shrink a window to a taskbar button. To restore the window to its previous size, click the appropriate taskbar button. • Close button. Click to shut a window.

Click OK. 41 42 Did You Know? You can hide the Office Assistant. When the Office Assistant is turned on, you can hide the Office Assistant. To hide the Office Assistant, right-click the Assistant, and then click Hide. [ Team LiB ] [ Team LiB ] Saving a Workbook When you create a new Excel workbook, the title bar displays a default title, such as Book1 or Book2. When you save a workbook for the first time, you need to give it a meaningful name and specify where you want to store it. Once you have saved a workbook, you should continue to save it as you work so that changes you make are saved in the file.

Download PDF sample

Rated 4.12 of 5 – based on 26 votes