Prices are checked against each store and labelled with when. Store links may earn us a commission. Price via Klarna.
It checks today's price at every store, compares the alternatives and answers in about a minute.
This is a hands-on, scenario-focused guide to building business models and analyzing data in Microsoft Excel, written for working analysts and students who already know the basics. The 2021 edition is the most heavily revised yet, adding six new chapters and covering dynamic arrays, STOCKHISTORY, one-click data analysis, Power Query, Power Pivot and the Data Model. It also shows how to build custom functions without VBA using LAMBDA and its helper functions. With over 900 practice problems, many drawn from real analyst work, it is a workbook as much as a reference, and it goes deeper into modeling than general Excel how-to books.
In stock
Store links may earn us a commission. Price via Klarna.
Lowest price we've seen: $34.59 on Nov 7 at Kobo. Tracked across 1 store since Nov 7.
This is a hands-on, scenario-focused guide to business modeling and data analysis with Microsoft Excel. It is more extensively updated than any previous edition and includes six new chapters.
The book covers one-click data analysis, STOCKHISTORY, dynamic arrays and Power Query. It shows how to create custom functions without VBA by using LAMBDA and LAMBDA helper functions. It also explains how to use the Data Model and Power Pivot to build and use relational data sources inside an Excel workbook.
Readers can practice with over 900 problems. Many are based on real challenges faced by working analysts.
