SpellNumber UAE Dirhams is an Excel function manually through VBA Programming to change a given number in UAE Dirhams to written words. In other words, it converts a numeric value of AED into English words including Fils. The SpellNumber macro spells the numeric value to words as the name suggests. There is no direct function […]

SpellNumber Without Currency is a manually created function through VBA Programming to change a number to written text. In other words, it converts a numeric value in excel into English words without currency. The SpellNumber macro spells the numeric value to words as the name suggests. There is no direct function in Microsoft Excel to […]

We use auto filters to filter subsets of data in Excel, but this filtering is limited to actual data. We can use Advanced Filter feature to filter multiple columns with different criteria. Understanding with an example will be easy. Open a workbook in Excel and copy below data into the sheet. You can also use […]

We require calculating the difference between two dates for many purposes in our daily life. Excel consists of many functions that easily calculate the difference between two dates. Mostly this difference is required for Payroll purposes for calculating the number of days worked in a month for preparing salaries. In Accounting, it is required for […]

In Excel, it is possible to insert rows in multiple sheets all at once. You don’t need to edit or insert the rows individually to every sheet. If there are multiple sheets, this becomes a tedious job. Thus, we need to find an easy way to do this action. You can insert rows in multiple […]