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

Data Analysis

  • Filter Data Based on Date in Excel
  • Use Data Form to input, edit and delete records in Excel
  • How to sum a total in multiple Excel tables
  • Working With Tables in Excel
  • Get column name from index in Excel Table

References

  • How to get last column number in range in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Last row number in range
  • How to retrieve first match between two ranges in Excel
  • Multi-criteria lookup and transpose in Excel

Data Validations

  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel
  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only
  • Excel Data validation number multiple 100

Tag: CHISQ.DIST function

CHISQ.DIST function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.DIST function in Excel? CHISQ.DIST function is one of Statistical functions in Microsoft Excel that returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. Syntax of CHISQ.DIST function CHISQ.DIST(x,deg_freedom,cumulative) The CHISQ.DIST function …

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

  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • Extract multiple matches into separate rows in Excel
  • How to use IFS function in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use Excel XOR Function

Date Time

  • Get first day of previous month in Excel
  • Convert Excel time to decimal hours in Excel
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • How to get same date next year or previous year in Excel

Grouping

  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel

General

  • Subtotal by color in Excel
  • Hide and Unhide Columns or Rows in Excel
  • Basic numeric sort formula in Excel
  • How to fill cell ranges with random text values in Excel
  • 44 Practical Excel IF function Examples
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning