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

Posted by

By Wyane Wilson

Grasp enterprise modeling and research recommendations with Microsoft Excel 2013, and rework facts into bottom-line effects. Written through award-winning educator Wayne Winston, this hands-on, scenario-focused advisor exhibits you the way to exploit the newest Excel instruments to combine info from a number of tables—and tips to successfully construct a relational information resource within an Excel workbook.

Solve actual company issues of Excel—and sharpen your edge

Summarize facts with PivotTables and Descriptive Statistics
discover new developments in predictive and prescriptive analytics
Use Excel pattern Curves, a number of regression, and exponential smoothing
grasp complex Excel capabilities corresponding to OFFSET and INDIRECT
Delve into key monetary, statistical, and time functions
Make your charts better with the facility View tool
Tame advanced optimization issues of Excel Solver
Run Monte Carlo simulations on inventory costs and bidding models
observe vital modeling instruments comparable 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 web current price criteria
Chapter eight. inner expense 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 exact command
Chapter 14. three-d formulas
Chapter 15. The Auditing device and Inquire add-in
Chapter sixteen. Sensitivity research with information tables
Chapter 17. The objective search command
Chapter 18. utilizing the state of affairs 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, alternative buttons, money bins, combination packing containers, and staff checklist 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 time table 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 expense activities teams
Chapter 35. Warehouse position and the GRG Multistart and Evolutionary Solver engines
Chapter 36. consequences and the Evolutionary Solver
Chapter 37. The touring salesclerk problem
Chapter 38. uploading info from a textual content dossier or document
Chapter 39. uploading information from the Internet
Chapter forty. Validating data
Chapter forty-one. Summarizing information through the use of 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 knowledge Model
Chapter forty five. PowerPivot
Chapter forty six. energy View
Chapter forty seven. Sparklines
Chapter forty eight. Summarizing information with database statistical functions
Chapter forty nine. Filtering info and elimination duplicates
Chapter 50. Consolidating data
Chapter fifty one. growing 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. advent 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 detailed events
Chapter sixty six. An advent to random variables
Chapter sixty seven. The binomial, hypergeometric, and adverse binomial random variables
Chapter sixty eight. The Poisson and exponential random variable
Chapter sixty nine. the traditional random variable
Chapter 70. Weibull and beta distributions: modeling computing device lifestyles and length of a project
Chapter seventy one. Making chance statements from forecasts
Chapter seventy two. utilizing the lognormal random variable to version inventory prices
Chapter seventy three. advent 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 wearing occasion probabilities
Chapter seventy seven. utilizing resampling to research data
Chapter seventy eight. Pricing inventory options
Chapter seventy nine. picking out shopper value
Chapter eighty. the industrial order volume stock model
Chapter eighty one. stock modeling with doubtful demand
Chapter eighty two. Queuing thought: the math of ready in line
Chapter eighty three. Estimating a requirement curve
Chapter eighty four. Pricing items by utilizing tie-ins
Chapter eighty five. Pricing items by utilizing subjectively made up our minds demand
Chapter 86. Nonlinear pricing
Chapter 87. Array formulation and capabilities

Show description

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

Best microsoft books

Knight's Microsoft Business Intelligence 24-Hour Trainer (Book & DVD)

A book-and-video advent to Microsoft's company Intelligence tools
If you're simply beginning to get a deal with on Microsoft enterprise Intelligence (BI) instruments, this ebook and accompanying video offers you the simply the correct amount of knowledge to accomplish uncomplicated enterprise research and reporting. You'll discover the elements and similar instruments that include the Microsoft BI toolset in addition to the recent BI good points of workplace 2010. After a easy primer on BI and knowledge modeling, the specialist staff of authors will give you step by step classes within the booklet and movies at the accompanying DVD on easy methods to use SQL Server Integration companies, SQL Server research prone, SQL Server Reporting prone, Excel BI (including PowerPivot), and SharePoint. * Integrates tutorial video clips with all of the classes present in the publication to reinforce your studying event* Explores the Microsoft company Intelligence (BI) toolset in addition to the hot BI gains of workplace 2010* Encourages you to perform what you've discovered in "Try It Out" sections* includes video demonstrations that stroll you thru the right way to take on every one lesson featured within the book
With Knight's Microsoft company Intelligence 24-Hour coach, veteran authors current you with an incredible introductory book-and-video package deal for you to start operating with the BI toolset instantly! /p
Note: As a part of the print model of this name, video classes are integrated on DVD. For book types, video classes might be accessed at wrox. com utilizing a hyperlink supplied within the inside of the e-book.

Beginning Microsoft SQL Server 2008 Programming

Beginning easily and progressively progressing to more and more complex themes, this advent to the SQL Server database specializes in what's unique concerning the SQL environment—SQL Server 2008, in particular—versus different programming environments. writer Robert Vieira attracts on his event as one of many best experts on Microsoft SQL Server and makes use of his exact educational method of clarify the numerous adjustments to the elemental center elements of SQL Server 2008.

Microsoft Outlook Version 2002 Inside Out

This supremely geared up reference packs 1000s of timesaving ideas, troubleshooting information, and convenient workarounds in concise, fast-answer format-it's all muscle and no fluff. observe the easiest and quickest how one can practice daily initiatives, and problem your self to new degrees of Outlook mastery! * construct on what you realize approximately Outlook and quick dive into what is new * Automate regimen projects, similar to backing up your mailbox * set up, synchronize, and archive serious info * customise Outlook-from templates and add-ins the entire solution to HTML * combine Outlook with Outlook exhibit and different MicrosoftR place of work purposes * Configure Outlook as a Microsoft trade Server purchaser * paintings off line or over the net * manage and deal with public folders * help roaming and cellular clients * strengthen your individual varieties and apps utilizing Microsoft visible BasicR for functions and script

Network+ Study Guide & Practice Exams: Exam N10-003

The community+ research advisor covers the entire ambitions at the CompTIA examination, together with the good points and services of networking elements, and making sure that readers have the data and abilities had to set up, configure and troubleshoot simple networking undefined, protocols and providers. It covers examination issues similar to media and topologies, protocols and criteria, community implementation, and community aid, in addition to new examination themes on applied sciences comparable to instant networking and Ethernet.

Extra resources for Microsoft Excel 2013: Data Analysis and Business Modeling

Sample text

We will also study the different types of controls that can be used in the pages. In addition, we'll review how and where actions are added to the pages. Chapter 5, Queries and Reports, we will learn about both Queries and Reports, two methods of extracting data for presentation to users. For Queries, we will study how they are constructed and some of the ways they are utilized. For Reports, we will walk through report data flow and the variety of different report types. We will study the two Report Designers, the C/SIDE Report Designer and the Visual Studio Report Designer and how a NAV report is constructed using both of these.

The following table summarizes object numbering practice: Object Number range 1 – 9,999 10,000 – 49,999 50,000 – 99,999 100,000 – 98,999,999 Above 98,999,999 Usage Base-application objects Country-specific objects Customer-specific objects Partner-created objects Microsoft territory • Work Date: This is a date controlled by the user operator. It is used as the default date for many transaction entries. The System Date is the date recognized by Windows. The Work Date, which can be adjusted at any time by the user, is specific to the workstation and can be set to any point in the future or the past.

Once your errata are verified, your submission will be accepted and the errata will be uploaded to our website or added to any list of existing errata under the Errata section of that title. com/books/ content/support and enter the name of the book in the search field. The required information will appear under the Errata section. Piracy Piracy of copyrighted material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously.

Download PDF sample

Rated 4.68 of 5 – based on 22 votes