--- product_id: 450680633 title: "Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas" price: "€ 63.18" currency: EUR in_stock: true reviews_count: 12 url: https://www.desertcart.de/products/450680633-advanced-excel-formulas-unleashing-brilliance-with-excel-formulas store_origin: DE region: Germany --- # Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas **Price:** € 63.18 **Availability:** ✅ In Stock ## Quick Answers - **What is this?** Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas - **How much does it cost?** € 63.18 with free shipping - **Is it available?** Yes, in stock and ready to ship - **Where can I buy it?** [www.desertcart.de](https://www.desertcart.de/products/450680633-advanced-excel-formulas-unleashing-brilliance-with-excel-formulas) ## Best For - Customers looking for quality international products ## Why This Product - Free international shipping included - Worldwide delivery with tracking - 15-day hassle-free returns ## Description Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas [Murray, Alan] on desertcart.com. *FREE* shipping on qualifying offers. Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas Review: THE best book on Excel functions and formulas - As many data aficionados know by now, Microsoft Excel has changed a LOT since 2018. The introduction of dynamic arrays (SORT, XLOOKUP, FILTER and a whole host of other new functions) as well as LET and Lambda to allow users to create fully customizable reports and analyses with even one just formula has been a complete game-changer. Using this new set of tools in the most robust and efficient way is a must for anyone who doesn’t want to be left behind. However, most Excel users are still only using VLOOKUP, Pivot Tables and possibly SUMIFS formulas as the most advanced tools in their spreadsheet arsenals. And that is seriously NOT cutting it any longer! Until now the only way to really learn this new data environment was though a lot of research and much trial and error. Fortunately for all of us, there is now this excellent book, Advanced Excel Formulas by Alan Murray (from Comptergaga.com and a long time Microsoft MVP and Excel trainer). Throughout this comprehensive book from Alan (along with technical editing by one of my Excel mentors, Mark Proctor), you get the full lay of the land of this new environment. After finishing the book, I can safely say that Alan covers the entirety of this new data landscape. Starting with the basics that we’re all familiar with, he goes through the importance of using Tables (something I’ve been advocating for many years now) as well as the newer functions for manipulating text, thorough reviews of the best older functions (VLOOKUP, SUMPRODUCT, and CHOOSE/SWITCH) and many chapters on the newer functions listed above before finishing up with the uses of LET, Lambda (creating your own functions without VBA) and all of the Lambda helper functions. If you’re at all interested in upping your Excel game, this is a must-have resource and one I’ll be going back to many times as I work on incorporating all that I’ve learned into my work. Highest recommendation. Review: Taking Hard Concepts and Simplifying Them - This book is incredible, I’ve never seen someone break down concepts like Xlookups in such simple terms. They have a GitHub with all of the sample files to work along with too. I’m so happy I found this book! ## Technical Specifications | Specification | Value | |---------------|-------| | Best Sellers Rank | #85,110 in Books ( See Top 100 in Books ) #10 in Microsoft Office Guides #18 in Microsoft Excel Guides #23 in Spreadsheet Books | | Customer Reviews | 4.8 4.8 out of 5 stars (77) | | Dimensions | 7 x 1.5 x 10 inches | | Edition | First Edition | | ISBN-10 | 1484271246 | | ISBN-13 | 978-1484271247 | | Item Weight | 3.2 pounds | | Language | English | | Print length | 846 pages | | Publication date | August 29, 2022 | | Publisher | Apress | ## Images ![Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas - Image 1](https://m.media-amazon.com/images/I/51Qy072zS+L.jpg) ## Customer Reviews ### ⭐⭐⭐⭐⭐ THE best book on Excel functions and formulas *by J***S on April 2, 2024* As many data aficionados know by now, Microsoft Excel has changed a LOT since 2018. The introduction of dynamic arrays (SORT, XLOOKUP, FILTER and a whole host of other new functions) as well as LET and Lambda to allow users to create fully customizable reports and analyses with even one just formula has been a complete game-changer. Using this new set of tools in the most robust and efficient way is a must for anyone who doesn’t want to be left behind. However, most Excel users are still only using VLOOKUP, Pivot Tables and possibly SUMIFS formulas as the most advanced tools in their spreadsheet arsenals. And that is seriously NOT cutting it any longer! Until now the only way to really learn this new data environment was though a lot of research and much trial and error. Fortunately for all of us, there is now this excellent book, Advanced Excel Formulas by Alan Murray (from Comptergaga.com and a long time Microsoft MVP and Excel trainer). Throughout this comprehensive book from Alan (along with technical editing by one of my Excel mentors, Mark Proctor), you get the full lay of the land of this new environment. After finishing the book, I can safely say that Alan covers the entirety of this new data landscape. Starting with the basics that we’re all familiar with, he goes through the importance of using Tables (something I’ve been advocating for many years now) as well as the newer functions for manipulating text, thorough reviews of the best older functions (VLOOKUP, SUMPRODUCT, and CHOOSE/SWITCH) and many chapters on the newer functions listed above before finishing up with the uses of LET, Lambda (creating your own functions without VBA) and all of the Lambda helper functions. If you’re at all interested in upping your Excel game, this is a must-have resource and one I’ll be going back to many times as I work on incorporating all that I’ve learned into my work. Highest recommendation. ### ⭐⭐⭐⭐⭐ Taking Hard Concepts and Simplifying Them *by Z***H on September 29, 2025* This book is incredible, I’ve never seen someone break down concepts like Xlookups in such simple terms. They have a GitHub with all of the sample files to work along with too. I’m so happy I found this book! ### ⭐⭐⭐⭐ Website found with difficulty *by R***J on February 5, 2024* Had some difficulties to find the website because of the added brackets on the web address. --- ## Why Shop on Desertcart? - 🛒 **Trusted by 1.3+ Million Shoppers** — Serving international shoppers since 2016 - 🌍 **Shop Globally** — Access 737+ million products across 21 categories - 💰 **No Hidden Fees** — All customs, duties, and taxes included in the price - 🔄 **15-Day Free Returns** — Hassle-free returns (30 days for PRO members) - 🔒 **Secure Payments** — Trusted payment options with buyer protection - ⭐ **TrustPilot Rated 4.5/5** — Based on 8,000+ happy customer reviews **Shop now:** [https://www.desertcart.de/products/450680633-advanced-excel-formulas-unleashing-brilliance-with-excel-formulas](https://www.desertcart.de/products/450680633-advanced-excel-formulas-unleashing-brilliance-with-excel-formulas) --- *Product available on Desertcart Germany* *Store origin: DE* *Last updated: 2026-05-19*