Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
暫譯: 進階 Excel 公式：釋放 Excel 公式的智慧

Murray, Alan

Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
  • 出版商: Apress
  • 出版日期: 2022-08-29
  • 售價: $2,130
  • 貴賓價: 9.5 折 $2,024
  • 語言: 英文
  • 頁數: 816
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484271246
  • ISBN-13: 9781484271247
  • 相關分類: Excel

    • 海外代購書籍(需單獨結帳)

相關主題

商品描述

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）是微軟 MVP 及 Excel 培訓師。他在 Excel 領域已經幫助人們超過 20 年。他熱愛培訓，並從中獲得快樂，因為他知道自己正在使人們的工作生活變得更輕鬆。

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

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

類似商品