Understanding the COUNTIF Function in Excel
The COUNTIF function in Excel is a powerful and versatile tool for counting cells that meet specific criteria within a […]
Excel functions
How to Use the OFFSET Function in Excel
Learn OFFSET function in Microsoft Excel. This is super useful formula for dynamic range calculations.
DSUM Function in Microsoft Excel
Learn How to Use DSUM Function in Excel. DSUM calculates the total of numbers in a column based on different conditions.
A Guide to Excel’s IRR, XIRR, and MIRR Functions
Learn Excel’s IRR, XIRR and MIRR Functions. These functions are very useful for financial analysis.
Mastering the XLOOKUP Function in Excel
Learn the XLOOKUP function in Microsoft Excel for Powerful Lookup Operation.
Most Useful Text Functions in Excel
Learn 8 very important and useful TEXT functions in Microsoft Excel.
Use VLOOKUP and COLUMNS Function together in Excel
Learn the combination of VLOOKUP and COLUMNS function to get data from one workbook to another.
Sales Target vs Achievement and Growth Over Last Year (%) Calculation in Excel
Learn how to calculate Sales Target vs Achievement % and Growth % over last year in Microsoft Excel.
SWITCH Function in Excel: A Detailed Guide
Learn how to use the SWITCH Function in Excel. This is very powerful function which can be used as an alternative to IFS or Nested IF.
RANDBETWEEN Function in Excel
Learn how to use the RANDBETWEEN function in Excel. It is a powerful function which has great application in different field.
Spellnumber Function in Excel
Learn how to create and use Spell Number in Excel. This Converts the numeric values to word or spelling format.
TRUNC Function in Excel
Learn how to use TRUNC function in Excel to truncate numbers without rounding.
Rank Function in Excel
Learn how to use Rank Function in Excel. Also learn combination of Rank + Countif to ignore the tie values.
Important Formulas for the Beginners in Learning MS Excel
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.