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

Data Analysis

  • Data Series in Excel
  • Error Bars in Excel
  • How to create dynamic reference table name in Excel
  • How To Create Pareto Chart in Excel
  • How to calculate current stock or inventory in Excel

References

  • Offset in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to use Excel FORMULATEXT function
  • How to get address of first cell in range in Excel
  • Left Lookup in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation number multiple 100
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days

Tag: RRI function

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

by

What is RRI function in Excel? RRI function is one of the Financial functions in Microsoft Excel that returns an equivalent interest rate for the growth of an investment. Syntax of RRI function RRI(nper, pv, fv) The RRI function syntax has the following arguments. Nper    Required. Nper is the number of periods for the investment. Pv    …

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

  • OR function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function

Date Time

  • Get days between dates ignoring years in Excel
  • Convert decimal minutes to Excel time
  • Add years to date in Excel
  • Dynamic date list in Excel
  • Get day name from date in Excel

Grouping

  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers at uneven intervals in Excel
  • Categorize text with keywords in Excel

General

  • Find Most Frequently Occurring Word in Excel Worksheet
  • Check if multiple cells have same value in Excel
  • Basic text sort formula in Excel
  • How to generate random number between two numbers in Excel
  • 3D SUMIF for multiple worksheets in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning