Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel-and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook

Learn to take full advantage of the power of spreadsheet modeling with PRACTICAL MANAGEMENT SCIENCE, 6E, geared entirely to Excel 2016. This edition uses an active-learning approach and realistic problems with the right amount of theory to ensure you establish a strong foundation. Exercises offer practical, hands-on experience with the methodologies. Examples and problems from finance, marketing, and operations management, and other areas of business illustrate how management science applies to your chosen profession -- and how you can use these skills on the job. The authors emphasize modeling rather than algebraic formulations and memorization of particular models. This edition also includes access to Palisade DecisionTools Suite (BigPicture, @RISK, PrecisionTree, StatTools, TopRank, NeuralTools, and Evolver) as well as SolverTable, for sensitivity analysis on optimization models. Chapters 15-17 are available online via MindTap.

Master data analysis, modeling and the effective use of spreadsheets with the popular BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 7E. The quantitative methods approach in this edition helps you maximize your success with a proven teach-by-example presentation, inviting writing style and complete integration of the latest version of Excel. The approach is also compatible with earlier versions of Excel for your convenience. This edition is more data-oriented than ever before with a new chapter on the two main Power BI tools in Excel -- Power Query and Power Pivot -- and a new section of data visualization with Tableau Public. Current problems and cases demonstrate the importance of the concepts you are learning. In addition, a useful Companion Website provides data and solutions files, SolverTable for optimization sensitivity analysis and Palisade DecisionTools Suite. MindTap online resources are also available.

Master business modeling and analysis techniques with Microsoft Excel 2019, 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.

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