Microsoft Excel 2013 Data Analysis and Business Modeling (Repost)
Wayne Winston, "Microsoft Excel 2013 Data Analysis and Business Modeling"
English | 2014 | ISBN: 0735669139 | PDF | pages: 889 | 27.7 mb
English | 2014 | ISBN: 0735669139 | PDF | pages: 889 | 27.7 mb
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