Home › Computers › Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
  • Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) by Wayne Winston book cover
  • Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) by Wayne Winston book cover
1 2

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)

by Wayne Winston

A practical guide to Excel modeling and analysis

$43.48 USD
$72.47 USD $43.48 USD
Save 40%

Paperback New English

Delivery to your door
In stock·Dispatches in 1–2 business days
Standard shipping* from $4.35
Standard shipping transit* 5–8 business days after dispatch

Faster options are available.

Rates and delivery estimates depend on your destination and item quantity. Estimates are informational only; the final shipping method and rate are selected at checkout.
Secure checkout
American Express Apple Pay DiscoverGoogle Pay Mastercard PayPalVisa
30-day eligible returns Returns & refunds policy

AlbakiReads Editorial

A practical guide to Excel modeling and analysis

Wayne Winston’s seventh-edition guide moves from Excel fundamentals into business analytics through scenario-based instruction and more than 900 practice problems, many drawn from working analysts’ challenges. Its subject matter spans data preparation with Power Query, formulas and custom functions, charting, and relational data models with Power Pivot. Further chapters cover predictive methods such as regression and exponential smoothing, alongside probability, Bayes’ theorem, and Monte Carlo simulation. The book also addresses features named for Office 2021 and Microsoft 365, including dynamic arrays, XLOOKUP, STOCKHISTORY, and 3D Maps, making it a substantial reference for applying spreadsheet tools to business questions.

Good fit for readers who enjoy

  • Excel users seeking a structured progression from basics to advanced analysis and modeling
  • Business analysts who want practice problems grounded in workplace scenarios
  • Readers interested in Excel features for data transformation, forecasting, and visualization

Themes

Spreadsheet-based business analysisData modeling and transformationPredictive analytics and simulationExcel formulas, charts, and visualization

Based on publisher information and book metadata.

Book overview

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

 

Shipping & returnsShipping options, delivery timing, and our return policy.

In-stock items normally dispatch within 1–2 business days. The ZIP-code estimator on this page is informational only; the final shipping method, price, and availability are confirmed at checkout for your full order.

For the initial delivery estimate we use these transit windows after dispatch: Standard 5–8 business days, Expedited 2–4 business days, and Priority 1–2 business days. Holiday delays are not included.

Eligible items can be returned within 30 days in accordance with our return policy.

Customer reviews

M
AlbakiReads
Malaika Taylor

I highly recommend to for anyone looking for inner clarity

T
AlbakiReads
Thomas DiMassa

Great service and fast service

E
AlbakiReads
Ella

Great shopping experience! The book arrived quickly, was well packaged, and matched the description perfectly. I would definitely shop with you again

O
AlbakiReads
Olivia

Smooth.