Synopsis
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
"synopsis" may belong to another edition of this title.
About the Author
WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! champion.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for Microsoft Excel Data Analysis and Business Modeling...
Stock Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00103071454
Stock Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00104613048
Stock Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Acceptable. Item in acceptable condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00105922617
Stock Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: Orion Tech, Kingwood, TX, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Seller Inventory # 1509304215-3-35592822
Seller Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: Greenworld Books, Arlington, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: very_good. Fast Free Shipping â" Very Good condition book with a firm cover and clean pages. Shows normal use and some light wear or limited notes markings. A solid, nice copy to enjoy. Seller Inventory # GWV.1509304215.VG
Stock Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: Indiana Book Company, Marion, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Ships same or next business day with delivery confirmation. Good condition. May or may not contain highlighting. Expedited shipping available. Seller Inventory # 1000009347212-1
Seller Image
Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Seller: MERS Goodwill-Kansas City, Blue Springs, MO, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. The book has been read but is in good condition. It has very minimal damage to the cover, including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. The binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, and no writing in the margins. There are no missing pages. See the seller's listing for full details and a description of any imperfections. Seller Inventory # WMEKV.1509304215.G
Stock Image
Microsoft Excel Data Analysis and Business Modeling
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1509304215I4N00
Stock Image
Microsoft Excel Data Analysis and Business Modeling
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1509304215I4N00
Stock Image
Microsoft Excel Data Analysis and Business Modeling
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1509304215I3N00