Category: Excel Formulas

Welcome to Excel Avon How to use DATEDIF Formula in Excel The DATEDIF Function in Excel is categorized under Excel Date or Time Functions  As a financial analyst we may …

Welcome to Excel Avon How to use LARGE & SMALL formulas in Excel Summary In this formula you can learn LARGE formula in Excel, A large function in excel …

Welcome to Excel Avon How to use TEXTJOIN Formula in Excel Summary TEXTJOIN in Excel marge Text string from multiple cells or Ranges. You can specify your choice of …

Welcome to Excel Avon  How to use SUBSTITUTE Formula in Excel In this post I Will Explain SUBSTITUTE FORMULA .Replace text based on content or The Excel SUBSTITUTE formula …

How to use AVERAGEIF Formula in Excel Summary The Excel AVERAGEIF function in excel calculates the average of cell or range that meet supplied criteria.  Formula =AVERAGEIF(Range, Criteria, ) …