Microsoft Excel 2013: Data Analysis and Business Modeling

by Wayne L. Winston

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

Genres: Reference, Nonfiction, Technology, Business

888 pages, Kindle Edition

First published December 30, 2013

Reviews

[Calvin · Rating 5 out of 5]

This is one of the best book about excel I ever read. The author knows the subject really well, every function is described and given context when and how to use them. Since he's knowledgeable in statistics, you can skip a lot of statistics books and just read the parts where the author uses those statistical analysis via excel.

I read this book in one go since I have been using excel for more than 8 years and know what formulas I usually use. Reading how each formula can be used under various scenarios are great to improve your excel. However, I probably will always use this book as a future reference when I am faced with various questions related to analytics

[Achi · Rating 4 out of 5]

Amazingly Helpful, detailed explanations and good examples. I beginning to feel like Excel God.

[Delhi Irc]

Location: GG6 IRC
Accession No: DL028449

[Glenn Burnside · Rating 4 out of 5]

I actually read the 2016 edition but that ones not listed on goodreads. So, I'm marking this one instead. Great reference book with tons of supporting sample docs to work with. This book finally got me unstuck on using powerpivot modelling with DAX expressions inside of excel. Looking forward to seeing what I can do with that.