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

Data Analysis

  • Chart Axes in Excel
  • How to sum a total in multiple Excel tables
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Randomize/ Shuffle List in Excel
  • Conditional Formatting Color Scales Examples in Excel

References

  • Find closest match in Excel
  • How to retrieve first match between two ranges in Excel
  • How to use Excel TRANSPOSE Function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation must not contain
  • Excel Data validation must contain specific text
  • Excel Data validation require unique number
  • Data validation must not exist in list

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

  • How to use Excel FALSE Function
  • How to use Excel XOR Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel
  • How to use Excel NOT Function

Date Time

  • Count birthdays by month in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Add business days to date in Excel
  • How to calculate Day of the Year in Excel
  • Display Date is same month in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Running count group by n size in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into unequal buckets in Excel
  • If cell contains one of many things in Excel

General

  • How to generate random number between two numbers in Excel
  • How to calculate percent variance in Excel
  • How to count total columns in range in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
  • Freeze and Unfreeze Panes in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning