Skip to product information
1 of 1

Alan Murray

Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

Low Stock: Only 2 copies remaining
Regular price £41.39 GBP
Regular price £49.99 GBP Sale price £41.39 GBP
17% OFF Sold out
Tax included. Shipping calculated at checkout.

YOU SAVE £8.60

  • Condition: Brand new
  • UK Delivery times: Usually arrives within 2 - 3 working days
  • UK Shipping: Fee starts at £2.39. Subject to product weight & dimension
Trustpilot 4.5 stars rating  Excellent
We're rated excellent on Trustpilot.
  • More about Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

This book is for anyone who wants to learn Excel from scratch or improve their existing Excel skills.
This book provides a comprehensive guide to Excel formulas, covering over 150 functions with practical examples. It covers basic to advanced topics, including VLOOKUP, SUMPRODUCT, and LAMBDA, and includes practice files to follow along. It is ideal for Excel users who want to improve their skills or learn Excel from scratch.

Format: Paperback / softback
Length: 816 pages
Publication date: 29 August 2022
Publisher: APress


SUMPRODUCT,COUNTIFS,MATCH,SORT,XLOOKUP,FILTER,SEQUENCE,SORTBY,UNIQUE,LAMBDA
This comprehensive guide to Excel formulas is designed to enhance and upgrade your knowledge of the versatile spreadsheet tool. With over 150 of the most useful Excel functions covered in detail, this book offers practical examples of their application, making it an invaluable resource for anyone looking to master Excel.

The book begins with a primer on Excel formulas and functions, covering the fundamentals from a basic level to intricate detail. It emphasizes the importance of understanding why formulas work, as well as how they operate, to gain a deep understanding of Excel. The book covers a wide range of popular functions in Excel, including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT, XLOOKUP, FILTER, SEQUENCE, SORTBY, UNIQUE, and LAMBDA.

By harnessing the power of these functions, you will learn how to return multiple results with a single formula, create top N lists, models, and reports, and simplify complex formulas with dynamic array engines and LAMBDA functions. The book also demonstrates how formulas can be used with other Excel features such as charts and Conditional Formatting to take your work to the next level.

Throughout the book, examples are provided to illustrate the practical application of the formulas. Practice files are also included to allow you to follow along with all the examples shown in the book and further enhance your understanding of Excel formulas.

Whether you are a beginner or an experienced Excel user, this guide will help you unlock the full potential of Excel and improve your productivity and efficiency in your work. So why wait? Enhance your Excel knowledge today with this comprehensive guide!

Weight: 1584g
Dimension: 177 x 252 x 52 (mm)
ISBN-13: 9781484271247
Edition number: 1st ed.

UK and International shipping information

UK Delivery and returns information:

  • Delivery within 2 - 3 days when ordering in the UK.
  • Shipping fee for UK customers from £2.39. Fully tracked shipping service available.
  • Returns policy: Return within 30 days of receipt for full refund.

International deliveries:

Shulph Ink now ships to Australia, Belgium, Canada, France, Germany, Ireland, Italy, India, Luxembourg Saudi Arabia, Singapore, Spain, Netherlands, New Zealand, United Arab Emirates, United States of America.

  • Delivery times: within 5 - 10 days for international orders.
  • Shipping fee: charges vary for overseas orders. Only tracked services are available for most international orders. Some countries have untracked shipping options.
  • Customs charges: If ordering to addresses outside the United Kingdom, you may or may not incur additional customs and duties fees during local delivery.
View full details