Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting Rules in Excel
  • How to sum a total in multiple Excel tables
  • How to add Trendline to a chart in Excel
  • Remove Duplicates Example in Excel
  • Add Outline to Data in Excel

References

  • How to use Excel FORMULATEXT function
  • How to get last column number in range in Excel
  • Extract data with helper column in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to use Excel ROWS Function

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation only dates between
  • Excel Data validation date in next 30 days
  • Data validation must not exist in list
  • Excel Data validation date in specific year

Tag: F.TEST function

F.TEST function: Description, Usage, Syntax, Examples and Explanation

by

What is F.TEST function in Excel? F.TEST function is one of Statistical functions in Microsoft Excel that returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Get date from day number in Excel
  • How to enter Today’s Date or Static Date and Time in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel

General

  • How to Delete Cells, Row and Rows in Excel
  • Delete Blank Rows at Once in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Sum by group in Excel
  • How to generate random times at specific intervals in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning