Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

Murray, Alan

  • 出版商: Apress
  • 出版日期: 2022-08-29
  • 售價: $2,690
  • 貴賓價: 9.5$2,556
  • 語言: 英文
  • 頁數: 816
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484271246
  • ISBN-13: 9781484271247
  • 相關分類: Excel
  • 立即出貨 (庫存=1)

商品描述

Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.

The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.

The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness the power of the dynamic array engine and functions such as SEQUENCE, SORTBY, UNIQUE, XLOOKUP and FILTER to create top N Lists, models and reports that would seem impossible without array formulas. In the final chapter, we discover the amazing LAMBDA function in Excel. Create your own Excel functions to simplify future Excel formulas and share them with others.

In this book, the formulas are not only written to return values to the grid, but also for use with other Excel features such as charts and Conditional Formatting, to take them to another level. Practice files are provided to follow all examples shown in the book.

What Will You Learn

  • Gain intimate knowledge of Excel formulas
  • Understand efficient and practical use of Defined Names and Tables
  • Master the most popular functions of Excel - VLOOKUP, COUNTIFS, MATCH, SUMPRODUCT, and so much more
  • Learn to return multiple results from a single formula with the magical array formulas.
  • Know the best lookup functions for dynamic spreadsheets
  • Know true power of classic Excel functions such as IF, SUM, and INDEX
  • Use new Excel functions including XLOOKUP, VSTACK, LET, and LAMBDA

Who Is This Book For
Excel users who are familiar with formulas but want to improve their current skill level

商品描述(中文翻譯)

增強並提升您的 Excel 知識,這本全面的 Excel 公式指南將為您介紹超過 150 個最實用的 Excel 函數,並提供大量實際的使用示例。本書已全面更新,包含了 2022 年最新發布的函數示例。本書以易讀的方式撰寫,您可以從頭到尾閱讀,或者隨時拿起來學習新知識,只需 5 分鐘。

本書以 Excel 公式和函數為開端。從基礎水平開始,深入細節,建立對基礎知識的牢固理解。學習「為什麼」而不僅僅是「如何」,對於真正理解 Excel 公式來說非常重要。擁有堅實的基礎是最高級的技能。

本書涵蓋了 Excel 中所有最受歡迎的函數,包括 VLOOKUP、SUMPRODUCT、COUNTIFS、MATCH、SORT 等等。您將學習如何使用單個公式返回多個結果。利用動態數組引擎和函數(如 SEQUENCE、SORTBY、UNIQUE、XLOOKUP 和 FILTER)來創建前 N 列、模型和報表,這些在沒有數組公式的情況下似乎不可能實現。在最後一章中,我們將發現 Excel 中令人驚嘆的 LAMBDA 函數。創建自己的 Excel 函數,簡化未來的 Excel 公式並與他人共享。

在本書中,這些公式不僅用於將值返回到網格中,還可與其他 Excel 功能(如圖表和條件格式設定)一起使用,將它們提升到另一個水平。提供練習文件,以便按照書中所示的所有示例進行操作。

您將學到什麼:
- 獲得對 Excel 公式的深入了解
- 理解定義名稱和表格的高效實用使用
- 掌握 Excel 的最受歡迎的函數 - VLOOKUP、COUNTIFS、MATCH、SUMPRODUCT 等等
- 學習如何使用神奇的數組公式從單個公式返回多個結果
- 知道動態電子表格的最佳查找函數
- 知道經典 Excel 函數(如 IF、SUM 和 INDEX)的真正威力
- 使用新的 Excel 函數,包括 XLOOKUP、VSTACK、LET 和 LAMBDA

本書適合對公式有一定了解但希望提高目前技能水平的 Excel 用戶。

作者簡介

Alan Murray is a Microsoft MVP and Excel trainer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier.

Alan runs his own blog - Computergaga (https: //computergaga.com) and writes for multiple other websites. His YouTube channel has over 550 videos and over 35 million views.

He organizes a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each other's company (https: //www.meetup.com/London-Excel-Meetup-Group/).

作者簡介(中文翻譯)

Alan Murray 是一位微軟最有價值專家 (Microsoft MVP) 和 Excel 訓練師。他在 Excel 領域已經幫助人們超過 20 年。他熱愛培訓,並從中獲得樂趣,因為他知道自己能讓人們的工作更輕鬆。

Alan 經營自己的部落格 - Computergaga (https://computergaga.com),並為多個其他網站撰寫文章。他的 YouTube 頻道擁有超過 550 個影片和超過 3500 萬次觀看次數。

他在倫敦組織了一個免費的每月 Excel 聚會,任何人都可以來學習 Excel、聊天並享受彼此的陪伴 (https://www.meetup.com/London-Excel-Meetup-Group/)。