Series:

Business Skills

2 total works

Cover of Microsoft Excel Data Analysis and Business Modeling

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

 

Cover of Microsoft Excel 2010 Data Analysis and Business Modeling
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010!

Use Excel to solve real business problems—and sharpen your edge!




Model investment risks and returns
Analyze your sales team’s effectiveness
Create best, worst, and most-likely case scenarios
Compare lease vs. buy, and calculate loan terms
See how price, advertising, and seasonality affect sales
Manage inventory with precision
Quantify the value of customer loyalty
Calculate your break-even number and ROI
Maximize scheduling efficiency
Express “home-field advantage” in real numbers
Project company growth, predict election results, and more!
Plus—introduce yourself to PowerPivot for Excel

Your companion web content includes:


Downloadable eBook
Hundreds of scenario-based practice problems
All the book’s sample files—plus customizable templates