Advanced Excel Formulas: Unleashing Brilliance in Excel - Alan Murray; | Foyles Bookstore
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Advanced Excel Formulas: Unleashing Brilliance in Excel
Foyalty 120

Advanced Excel Formulas: Unleashing Brilliance in Excel (Paperback)

Pre-order for despatch on publication.


Enhance and upgrade your Excel knowledge with this comprehensive text on Excel formulas. The book will not only help you become an Excel expert, but will also help you analyze data more efficiently and effectively.

The book starts with basic mathematical functions that are the building blocks of automated Excel models and reports, including IF, IFS, AND, OR, IFNA, and more, and it covers logical functions. You will go through the use and hidden brilliance of defined names and learn how to deploy ranges and formulas in Excel (this is a chapter you won't want to miss). The book will help you make the most of Tables. You need to use Tables in modern Excel and their role with dynamic arrays is a key one. You will understand various text functions as well as learning Excel's date and time functions. The book covers how to use the infamous VLOOKUP function, with multiple examples of advanced techniques. SUMIFS, COUNTIFS, SUMPRODUCT, and AGGREGATION functions are discussed in detail. Dynamic array formulas are next. The game has changed. You will learn the power dynamic array engine and the new formulas such as SEQUENCE, SORTBY, and UNIQUE. You will learn to use the XLOOKUP function, followed by the FILTER function and a few different ways to create Table Rankings and Top N Lists with formulas. These are common tasks, but difficult to perform without advanced Excel formula skills. The book will show you how to get status information about a cell and the operating environment through the CELL, TYPE, and INFO functions. And the book ends with the use of the new LET and LAMBDA functions. You can start creating your own functions today with the amazing LAMBDA.

After reading this book, you will have improved your current Excel skills and learned new functions and formulas.

What Will You Learn

Know the best lookup functions for dynamic spreadsheets

Use Defined Names and Tables

Understand the next level aggregation functions

Retrieve status of cells and the Excel environment

Use new Excel functions, including XLOOKUP, LET, and LAMBDA

Who Is This Book For

Excel users who are familiar with formulas but want to improve their current skill level

Computing & ITComputer programming / software developmentMicrosoft programming Publisher: APress Publication Date: 13/05/2022 ISBN-13: 9781484271247  Details: Type: Paperback Format: Books
Availability: Pre-order for despatch on publication. Pre-Order

Alan Murray is a Microsoft MVP and Excel trainer. He has been helping people with Excel for over 20 years. He loves training and the joy he gets from knowing he is making working lives easier. Alan runs his own blog, Computergaga, and writes for multiple websites. His YouTube channel has over 550 videos and over 30 million views. He organizes a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each other's company.

More books by Alan Murray

Leave Review

Our Christmas Last Posting Dates can be found here

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.


Location 1st Book Each additional book Average Delivery Time
Free UK Standard Delivery on Orders Over £25 (2nd Class)     3-5 Days
UK Standard Delivery (2nd Class) £2.99 £0.00 3-5 Days
UK 1st Class Delivery £3.99 £0.00 2-3 Days

Click & Collect / 
Delivery to a Foyles Bookshop


Free Free Click and Collect and Delivery to Store is available for all our shops. Collection times will vary depending on availability of items. Individual despatch times for each item will be given at checkout.
Please wait for order arrival confirmation email before making a journey to collect.
UK Courier* £7.95 £0.00 1 Working Day
Western Europe**Airmail £9.00 £1.00 7-8 Days
Rest of World Airmail*** £12.50 £1.00 7-10 Days

* For courier service please contact the Charing Cross Road store

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

*** We are currently unable to delivery to the following countries - Afghanistan, Bangladesh, Ghana, Iraq, Lebanon, Macao, Pakistan, Puerto Rico, Saint Barthelemy, Turkey, Uzbekistan, Virgin Island US

For goods delivered outside of the UK, the consignee (ie the person to whom the consignment is sent) will be the declarant and importer into the country for which the consignment is destined. The consignee will be responsible for both customs clearance and payment of customs duties and local taxes where required.

Customs Charges - if you are ordering goods for delivery outside of the UK, please note that your consignment may be subject to VAT (Value Added Tax), other taxes, customs duties and/or fees levied by the destination country. Any such charges levied in relation to customs clearance must be borne by you. It is accepted by you that Foyles has no control over additional charges in relation to customs clearance. Foyles recommend that you check with your local customs officials or post office for more information regarding importation taxes/duties that may be applicable to your online order.

Delivery Help & FAQs

A Year of Books Subscription Packages 

Delivery is free for the UK. Western Europe costs £60 for each 12 month subscription package purchased. For the Rest of the World the cost is £100 for each package purchased. All delivery costs are charged in advance at time of purchase. For more information please visit the A Year of Books page.

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

Structure and Interpretation of the...
Sunu Engineer; Anu Engineer
Introducing .NET 6: Getting Started...
Nico Vermeir
Pro C# 10 with .NET 6: Foundational...
Andrew Troelsen; Philip Japikse
Practical Azure Application...
Thurupathan Vijayakumar
© W&G Foyle Ltd