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

Data Analysis

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Add Outline to Data in Excel
  • Filter Data Based on Date in Excel
  • How to do a t-Test in Excel?

References

  • How to reference named range different sheet in Excel
  • How to use Excel VLOOKUP Function
  • How to use Excel MMULT Function
  • Merge tables with VLOOKUP in Excel
  • How to get address of last cell in range in Excel

Data Validations

  • Excel Data validation exists in list
  • How To Create Drop-down List in Excel
  • Excel Data validation must begin with
  • Data validation must not exist in list
  • Excel Data validation specific characters only

Tag: GEOMEAN function

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

by

What is GEOMEAN function in Excel? GEOMEAN function is one of Statistical functions in Microsoft Excel that returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates. Syntax of GEOMEAN function GEOMEAN(number1, [number2], …) The GEOMEAN 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

  • How to use IFS function in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • Not Equal To ‘<>‘ operator in Excel
  • Return blank if in Excel

Date Time

  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Get last working day in month in Excel
  • How to get Holiday Date from Year in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • HOUR function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel

General

  • How to add sequential row numbers to a set of data in Excel
  • How to Delete Cells, Row and Rows in Excel
  • How to make excel worksheets print on one page?
  • AutoFit Column Width, AutoFit Row Height in Excel
  • How to set or clear a print area in Excel Worksheet
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning