Genre : Business & Economics
Publisher : Pearson Education
ISBN_10 : 9780735681071
Copyright Year : 2014-01-15
File Format : All Formats
File Download : 888
Price : FREE


E-BOOK EXCERPT

Master business modeling and analysis techniques 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 effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

Genre : Computers
Publisher :
ISBN_10 : 0735619018
Copyright Year : 2004-01
File Format : All Formats
File Download : 602
Price : FREE


E-BOOK EXCERPT

Provides an introduction to data analysis and business modeling using Microsoft Excel.

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

Genre : Computers
Publisher : Microsoft Press
ISBN_10 : 9781509304226
Copyright Year : 2016-11-29
File Format : All Formats
File Download : 864
Price : FREE


E-BOOK EXCERPT

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

Genre : Computers
Publisher : Microsoft Press
ISBN_10 : 9781509306084
Copyright Year : 2019-03-28
File Format : All Formats
File Download :
Price : FREE


E-BOOK EXCERPT

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. Solve real business problems with Excel—and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics Use PowerQuery or Get & Transform to connect, combine, and refine data sources Leverage Office 365’s new Geography and Stock data types and six new functions Illuminate insights from geographic and temporal data with 3D Maps Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts Use Excel trend curves, multiple regression, and exponential smoothing Delve into key financial, statistical, and time functions Master all of Excel’s great charts Quickly create forecasts from historical time-based data Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams Run Monte Carlo simulations on stock prices and bidding models Learn about basic probability and Bayes’ Theorem Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook Automate repetitive analytics tasks by using macros

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

📒 Microsoft Excel 2010 by Wayne L. Winston

Genre : Computers
Publisher :
ISBN_10 : 0735643369
Copyright Year : 2011
File Format : All Formats
File Download : 700
Price : FREE


E-BOOK EXCERPT

An award-winning business professor and corporate consultant shares the best of his real-world experience in this practical, scenario-focused guide--fully updated for Excel 2010.

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

📒 Decision Analytics by Conrad George Carlberg

Genre : Business & Economics
Publisher : Que Publishing
ISBN_10 : 9780789751683
Copyright Year : 2013
File Format : All Formats
File Download : 272
Price : FREE


E-BOOK EXCERPT

Explains how to distil big data into manageable sets and use them to optimise business and investment decisions. Reveals techniques to improve a wide range of decisions, and use simple Excel charts to grasp the results. Includes downloadable Excel workbooks to adapt to your own requirements.

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

Genre : Computers
Publisher : Pearson Education
ISBN_10 : 9780735676565
Copyright Year : 2013-03-15
File Format : All Formats
File Download : 500
Price : FREE


E-BOOK EXCERPT

Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint Authors’ note on using Microsoft Excel 2016: This book’s content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

📒 Microsoft Office Excel 2007 by Wayne L. Winston

Genre : Computers
Publisher :
ISBN_10 : UOM:39015070742716
Copyright Year : 2007
File Format : All Formats
File Download : 601
Price : FREE


E-BOOK EXCERPT

Provides an introduction to data analysis and business modeling using Microsoft Excel.

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

📒 Predictive Analytics by Conrad Carlberg

Genre : Business & Economics
Publisher : Que Publishing
ISBN_10 : 9780134683829
Copyright Year : 2017-07-13
File Format : All Formats
File Download : 384
Price : FREE


E-BOOK EXCERPT

EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS! Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. Learn the “how” and “why” of using data to make better decisions, and choose the right technique for each problem Capture live real-time data from diverse sources, including third-party websites Use logistic regression to predict behaviors such as “will buy” versus “won’t buy” Distinguish random data bounces from real, fundamental changes Forecast time series with smoothing and regression Account for trends and seasonality via Holt-Winters smoothing Prevent trends from running out of control over long time horizons Construct more accurate predictions by using Solver Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning Handle complex consumer choice problems with advanced logistic regression Benchmark Excel results against R results

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release

Genre : Business & Economics
Publisher : Nelson Education
ISBN_10 : 9781305947542
Copyright Year : 2016-03-31
File Format : All Formats
File Download : 984
Price : FREE


E-BOOK EXCERPT

Become a master of data analysis, modeling, and spreadsheet use with BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 6E! This popular quantitative methods text helps you maximize your success with its proven teach-by-example approach, student-friendly writing style, and complete Excel 2016 integration. (It is also compatible with Excel 2013, 2010, and 2007.) The text devotes three online chapters to advanced statistical analysis. Chapters on data mining and importing data into Excel emphasize tools commonly used under the Business Analytics umbrella -- including Microsoft Excel's "Power BI" suite. Up-to-date problem sets and cases demonstrate how chapter concepts relate to real-world practice. In addition, the Companion Website includes data and solutions files, PowerPoint slides, SolverTable for sensitivity analysis, and the Palisade DecisionTools Suite (@RISK, BigPicture, StatTools, PrecisionTree, TopRank, RISKOptimizer, NeuralTools, and Evolver).

#1Bestseller in [pdf] [tuebl] [kindle] [epub] [mobi] [audiobook], #1 e-Book New Release