搜尋結果
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
在較新版本的 Excel 中,這些函數已由新函數取代,新函數可提供更佳的準確性,並擁有更能反映其使用方式的名稱。 您還是可以使用這些函數以與舊版 Excel 相容,但是,若不需要回溯相容性,您應該開始使用新函數。
Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, SEARCH, DATE, and more. Also see 500 Formulas and 101 Functions.
2023年10月28日 · 公式與函數是Excel裡相當重要的計算與分析功能,簡單的計算利用公式就能快速完成,較複雜的分析就可仰賴函數的運算,而Excel內建了11大類別的函數,包括財務、日期及時間、數學與三角函數、統計⋯等,共超過300個以上的函數,如果對特定函數已經相當
Over 500 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.
Below is a brief overview of about 100 important Excel functions you should know, with links to detailed examples. We also have a large list of example formulas , a more complete list of Excel functions, and video training. If you are new to Excel formulas, see this introduction.
Excel Functions List. Below you will find a searchable list of ~200 Excel Functions. Next to each function, you’ll see a description of the function along with the function’s syntax. If you’d like to learn more about a function, simply click it’s row and go to the function page.