Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
暫譯: Microsoft Excel 函數快速參考:高品質數據分析、儀表板等應用指南

Mehta, Mandeep

  • 出版商: Apress
  • 出版日期: 2021-01-08
  • 售價: $1,770
  • 貴賓價: 9.5$1,682
  • 語言: 英文
  • 頁數: 255
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484266129
  • ISBN-13: 9781484266120
  • 相關分類: ExcelData Science
  • 海外代購書籍(需單獨結帳)

商品描述

This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.
The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples.
With this book by your side, you'll always have the answer to your Excel function syntax questions.
What You Will Learn
  • Work with basic Excel functions
  • Use the LOOKUP function
  • Take advantage of new functions in information functions
  • Create a mega formula
Who This Book Is For
Administrators, analysts, and anyone else working with Microsoft Excel.


商品描述(中文翻譯)

這本簡明的語法參考手冊以良好的組織格式呈現了 Excel 函數的基本語法,可作為快速且方便的參考。您可以利用它來提升您的 Excel 知識並提高生產力。它將幫助您提升數據分析、儀表板、模型和範本的質量。

《Microsoft Excel 函數快速參考》幫助您設置工作簿、輸入數據並進行格式化以便於查看。書中首先概述了 Excel 函數,解釋了不同類型的 Excel 函數,接著介紹了字串函數和日期函數。然後涵蓋了時間、查找、聚合和邏輯函數,並附有練習題。此外,您還將看到 Excel 中的數學函數和資訊函數。您還能夠創建複雜的預測工作表、關鍵績效指標 (KPIs) 和時間線。文本中的每個函數都通過有用且啟發性的範例進行說明。

有了這本書,您將隨時能找到有關 Excel 函數語法問題的答案。

您將學到什麼


  • 使用基本的 Excel 函數

  • 使用 LOOKUP 函數

  • 利用資訊函數中的新函數

  • 創建一個大型公式

本書適合誰
本書適合管理員、分析師以及任何使用 Microsoft Excel 的人。

作者簡介

Mandeep has more than 20 years of experience in administration, operations, software development, and reporting. He mostly works with cross-functional teams in ensuring operational and service excellence. Mandeep has worked with Capgemini for more than ten years and is currently working as a freelancer in conducting various training in MS Office and providing data services.

作者簡介(中文翻譯)

Mandeep 擁有超過 20 年的行政、運營、軟體開發和報告經驗。他主要與跨功能團隊合作,以確保運營和服務的卓越。Mandeep 在 Capgemini 工作了超過十年,目前作為自由工作者,進行各種 MS Office 的培訓並提供數據服務。

最後瀏覽商品 (20)