F.TEST function - Microsoft Support
Learn how to use the F.TEST function in Excel to test whether two samples have different variances. See the syntax, arguments, remarks, and example of the F.TEST function.
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex statistical or engineering analyses in Excel. The tool provides output tables and charts for various data analysis functions, such as regression, correlation, t-test, and more.
F.DIST function - Microsoft Support
Learn how to use the F.DIST function in Excel to calculate the F probability distribution for two data sets with different degrees of freedom. See the syntax, arguments, remarks, and example of the function.
LOOKUP function - Microsoft Support
Learn how to use LOOKUP function to search for a value in a single row or column and return a value from the same position in another row or column. Compare LOOKUP with VLOOKUP and XLOOKUP, and see examples of vector and array forms.
Excel functions (alphabetical) - Microsoft Support
Find and learn about Excel functions by name, type, and description. Browse the list of functions from A to Z or use Ctrl+F to search by keywords.
Load the Analysis ToolPak in Excel - Microsoft Support
Learn how to use the Analysis ToolPak to perform complex statistical or engineering analyses in Excel. Follow the steps to load the tool and access its functions, charts, and output tables.
F.INV function - Microsoft Support
The F.INV function returns the inverse of the F probability distribution. If p = F.DIST(x,...), then F.INV(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets.
Excel functions (by category) - Microsoft Support
Browse Excel functions by their functionality, such as Logical, Text, or Statistical. Find detailed information about a function by clicking its name or use Ctrl+F to search by keywords.
INDIRECT function - Microsoft Support
Learn how to use the INDIRECT function to return the reference specified by a text string. See syntax, arguments, examples, and limitations of this function in Excel for Microsoft 365, Mac, and web.
Create custom functions in Excel - Microsoft Support
Learn how to create and use custom functions in Excel using VBA code. Custom functions can perform calculations based on arguments passed to them and return values to worksheet formulas.
Check if a cell contains text (case-insensitive) - Microsoft Support
Learn how to use the IF, SEARCH, and ISNUMBER functions to find text in Excel cells, regardless of upper- or lowercase. See examples, steps, and tips for using wildcard characters and filters.