Rank Function in Excel
Learn how to use Rank Function in Excel. Also learn combination of Rank + Countif to ignore the tie values.
Excel functions
Learn 10 Essential Excel Formulas for Beginners
In this article, you will learn 10 very useful Excel functions specially for the beginners in learning Excel.
Spellnumber VBA Code for Qatari Riyal and Dirham
Get the VBA code required for converting the numeric value of Qatari Riyal and Dirhams to spelling in Microsoft Excel.
How to Use IF Function in Excel
Learn how to use the IF function in Excel. This is a logical function to test condition and do calculation based on TRUE and FALSE results.
How to Calculate CAGR in Microsoft Excel
Learn how to calculate the CAGR (Compound Annual Growth Rate) in Microsoft Excel.
Index and Match Function in Excel for Powerful 2D Lookup
Learn how to use the Index and Match function in Excel. This is very useful lookup function that can be used as an alternative to VLOOKUP, HLOOKUP and XLOOKUP.