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

Data Analysis

  • Use Data Form to input, edit and delete records in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • How To Create Frequency Distribution in Excel
  • Managing Conditional Formatting Rules in Excel
  • Number and Text Filters Examples in Excel

References

  • Lookup entire row in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROWS Function
  • How to use Excel INDIRECT Function
  • How to get address of first cell in range in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation
  • Prevent invalid data entering in specific cells
  • Excel Data validation only dates between
  • Excel Data validation allow uppercase only

Tag: LOGNORM.INV function

LOGNORM.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is LOGNORM.INV function in Excel? LOGNORM.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,…) then LOGNORM.INV(p,…) = x. Use the lognormal distribution to analyze logarithmically transformed data. …

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

  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • AND function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Convert text to date in Excel
  • How to calculate next anniversary date or birthday in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel

General

  • How to fill cell ranges with random text values in Excel
  • Find, Select, Replace and Go To Special in Excel
  • How to create dynamic worksheet reference in Excel
  • Delete Blank Rows at Once in Excel
  • Creating and Opening an existing file in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning