Buy New
-
To see product details, add this item to your cart.
Ships from: MyPrepbooks Sold by: MyPrepbooks
Used - Very Good
-
To see product details, add this item to your cart.
Ships from: Bay State Book Company Sold by: Bay State Book Company
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)
Purchase options and add-ons
Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.
Solve real problems with Microsoft Excel―and build your competitive advantage
- Quickly transition from Excel basics to sophisticated analytics
- Use recent Power Query enhancements to connect, combine, and transform data sources more effectively
- Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA
- Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music
- Build more sophisticated and compelling charts
- Use the new XLOOKUP function to revolutionize your lookup formulas
- Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries
- Illuminate insights from geographic and temporal data with 3D Maps
- Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios
- Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics
- Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook
- ISBN-100137613660
- ISBN-13978-0137613663
- Edition7th
- PublisherMicrosoft Press
- Publication dateDecember 16, 2021
- LanguageEnglish
- Dimensions7.38 x 2.36 x 9.13 inches
- Print length1168 pages
Frequently bought together

Customers who viewed this item also viewed
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to AdvancedPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- Microsoft Excel 365 BiblePaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- Storytelling with Data: A Data Visualization Guide for Business ProfessionalsPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- Advanced Excel Formulas: Unleashing Brilliance with Excel FormulasPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- Ultimate Microsoft Excel Formula & Function Reference Guide: 500+ Practical Tips for Beginners to Experts including AI prompts for ChatGPTPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Monday, Sep 21
- Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience for Maximum Productivity and Efficiency With all Formulas & Functions and Practical ExamplesPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
Customers also bought or read
- Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)
Paperback$40.61$40.61FREE delivery Oct 3 - 7 - Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) (Business Skills)
Paperback$38.42$38.42FREE delivery Sep 28 - 30 - Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Paperback$31.22$31.22Delivery Sun, Sep 20 - Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More
Paperback$19.99$19.99Delivery Mon, Sep 21 - Hands-On Financial Modeling with Excel for Microsoft 365: Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis
Paperback$36.26$36.26FREE delivery Sun, Sep 20 - Storytelling with Data: A Data Visualization Guide for Business Professionals#1 Best SellerBusiness Communication
Paperback$15.74$15.74Delivery Sun, Sep 20 - Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
Paperback$36.00$36.00FREE delivery Mon, Sep 21 - Business Analytics: The Art of Modeling With Spreadsheets
Paperback$106.23$106.23FREE delivery Mon, Sep 21 - The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Paperback$49.34$49.34FREE delivery Sun, Sep 20 - Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
Paperback$27.40$27.40Delivery Sep 24 - 25 - SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Paperback$36.49$36.49FREE delivery Mon, Sep 21 - Excel Data Analysis For Dummies (For Dummies (Computer/Tech))
Paperback$19.14$19.14Delivery Mon, Sep 21 - Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Paperback$38.31$38.31FREE delivery Tue, Sep 22 - The Definitive Guide to Power Query (M): Mastering complex data transformation with Power Query
Paperback$32.71$32.71Delivery Sun, Sep 20 - Building Interactive Dashboards in Microsoft 365 Excel: Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
Paperback$29.99$29.99Delivery Mon, Sep 21 - Collect, Combine, and Transform Data Using Power Query in Excel and Power BI (Business Skills)
Paperback$33.48$33.48FREE delivery Fri, Sep 18 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Mon, Sep 21 - Mastering Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros#1 Best SellerVisual Basic Programming
Paperback$29.98$29.98Delivery Mon, Sep 21 - Microsoft Excel VBA and Macros: Your guide to efficient automation (Business Skills)
Paperback$35.98$35.98$3.99 delivery Sep 29 - Oct 2 - Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
Paperback$43.99$43.99FREE delivery Oct 1 - 16 - Federal Income Taxation of Corporations and Stockholders in a Nutshell
Paperback$65.00$65.00FREE delivery Sun, Sep 20 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data#1 Best SellerComputer Programming Structured Design
Paperback$19.99$19.99Delivery Sun, Sep 20 - Ultimate Microsoft Excel Formula & Function Reference Guide: 500+ Practical Tips for Beginners to Experts including AI prompts for ChatGPT
Paperback$34.23$34.23Delivery Mon, Sep 21
From the Publisher
How to use this book
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) features a companion website that makes available to you all the sample files, solution files, and templates you can use with the book’s examples. The download includes both the final Excel workbooks and the starting templates you can work with on your own.
Editorial Reviews
About the Author
Wayne L. Winston is Professor Emeritus of Decision Sciences at the Indiana University School of Business. He has also taught at the University of Houston and Wake Forest. He has won more than 40 teaching awards and taught Excel modeling and analytics at many Fortune 500 companies, accounting firms, the U.S. Army, and the U.S. Navy. He is a two-time Jeopardy! champion, and also is a co-developer of a player tracking system utilized by Mark Cuban and the Dallas Mavericks.
Product details
- Publisher : Microsoft Press
- Publication date : December 16, 2021
- Edition : 7th
- Language : English
- Print length : 1168 pages
- ISBN-10 : 0137613660
- ISBN-13 : 978-0137613663
- Item Weight : 2.31 pounds
- Dimensions : 7.38 x 2.36 x 9.13 inches
- Best Sellers Rank: #186,135 in Books (See Top 100 in Books)
- #22 in Microsoft Office Guides
- #29 in Microsoft Excel Guides
- #37 in Spreadsheet Books
- Customer Reviews:
About the authors

Discover more of the author’s books, see similar authors, read book recommendations and more.

Discover more of the author’s books, see similar authors, read book recommendations and more.

















