Microsoft Excel Data Analysis and Business Modeling

Microsoft Excel Data Analysis and Business Modeling

by Wayne Winston

984 pages· 2016· ISBN 9781509304219
About
Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016's most valuable innovations for data analysis and business modeling. It's packed with realistic problems and solutions to help you gain mastery -- including over 150 that are new or revised. Coverage includes: Quickly transitioning from basic Excel to more sophisticated analytics Summarizing data with PivotTables and Descriptive Statistics Exploring new trends in predictive and prescriptive analytics Using Excel Trend Curves, multiple regression, and exponential smoothing Mastering advanced Excel functions such as OFFSET and INDIRECT Delving into key financial, statistical, and time functions Making charts more effective with Power View Tame complex optimization problems with Excel Solver Running Monte Carlo simulations on stock prices and bidding models Using Excel 2016's new FORECAST and Power Map tools Working with the AGGREGATE function and Table Slicers Creating multiple PivotTables from a filter Using HYPERLINKS, ISFORMULA, and UNICODE Performing sensitivity analyses with more than two variables Making the most of the Inquire add-in And much more "

Discuss Microsoft Excel Data Analysis and Business Modeling with other readers

Join or start a book club for Microsoft Excel Data Analysis and Business Modeling on Readfeed. Live chat, shared reading progress, and AI discussion questions — free to get started.

Frequently asked questions

How do I join a book club for Microsoft Excel Data Analysis and Business Modeling?

Sign up free on Readfeed, then browse public clubs or start your own club with Microsoft Excel Data Analysis and Business Modeling as the current read. Invite friends with a share link and discuss together with live chat and AI discussion questions.

Can I discuss Microsoft Excel Data Analysis and Business Modeling with other readers online?

Yes. Readfeed book clubs let you chat live, share progress, and join discussions about Microsoft Excel Data Analysis and Business Modeling with readers worldwide — whether your club is virtual, in-person, or hybrid.

Is Readfeed free?

Yes. Creating an account and joining book clubs is free. Sign up to find readers who love the same books and start discussing today.