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

Data Analysis

  • Data Series in Excel
  • How to add Trendline to a chart in Excel
  • How To Insert and Customize Sparklines in Excel
  • How to Use Solver Tool in Excel
  • Add Outline to Data in Excel

References

  • How to use Excel OFFSET function
  • How to use Excel TRANSPOSE Function
  • Count rows that contain specific values in Excel
  • How to get address of last cell in range in Excel
  • How to get last column number in range in Excel

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation date in specific year
  • Excel Data validation must not contain
  • Excel Data validation exists in list
  • Excel Data validation allow weekday 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

  • Not Equal To ‘<>‘ operator in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • IF with wildcards in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get work hours between dates in Excel
  • Convert text timestamp into time in Excel
  • How to calculate months between dates in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get date from day number in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel

General

  • Creating and Opening an existing file in Excel
  • How to calculate percent change in Excel
  • Automatically fill series of cells in Excel using AutoFill
  • Convert column letter to number in Excel
  • Hide and Unhide Columns or Rows in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning