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

Data Analysis

  • How to create dynamic reference table name in Excel
  • How to Create Thermometer Chart in Excel
  • How to count table rows in Excel
  • How to Create Area Chart in Excel
  • Excel Bar Chart

References

  • To count total rows in a range in Excel
  • Find closest match in Excel
  • How to get last row in numeric data in Excel
  • Count rows with at least n matching values
  • How to use Excel FORMULATEXT function

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation must not contain
  • Prevent invalid data entering in specific cells
  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total

Tag: DURATION function

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

by

What is DURATION function in Excel? DURATION function is one of the Financial functions in Microsoft Excel that returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price’s response to …

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

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel

Date Time

  • Count day of week between dates in Excel
  • Get date from day number in Excel
  • Convert decimal seconds to Excel time
  • How to Calculate Age in Excel
  • How to calculate nth day of year in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel
  • Categorize text with keywords in Excel
  • Group times into unequal buckets in Excel

General

  • Mark Workbook as Final in Excel
  • Customize Ribbon In Excel
  • Excel Default Templates
  • How to calculate decrease by percentage in Excel
  • How to calculate percent of students absent in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning