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

Data Analysis

  • How to Sort by Color in Excel
  • Move chart to a separate worksheet in Excel
  • How to calculate current stock or inventory in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • Conditional Formatting Icon Sets Examples in Excel

References

  • How to use Excel MMULT Function
  • Offset in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to reference named range different sheet in Excel
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation with conditional list
  • How To Create Drop-down List in Excel
  • Prevent invalid data entering in specific cells
  • Excel Data validation exists in list

Tag: GAMMA function

GAMMA function: Description, Usage, Syntax, Examples and Explanation

by

What is GAMMA function in Excel? GAMMA function is one of Statistical functions in Microsoft Excel that return the gamma function value. Syntax of GAMMA function GAMMA(number) The GAMMA function syntax has the following arguments. Number    Required. Returns a number. GAMMA formula explanation GAMMA uses the following equation: Г(N+1) = N * Г(N) If Number is …

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

  • Complete List of Excel Logical Functions, References and Examples
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel

Date Time

  • Get last day of month in Excel
  • Count holidays between two dates in Excel
  • Display Days until expiration date in Excel
  • How to calculate Next working/business day in Excel
  • Basic timesheet formula with breaks in Excel

Grouping

  • Running count group by n size in Excel
  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Map inputs to arbitrary values in Excel

General

  • Advanced Number Formats in Excel
  • Check if range contains a value not in another range in Excel
  • Check if multiple cells have same value in Excel
  • How to count total number of cells in a rectangular range in Excel
  • Creating and Opening an existing file in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning