How to create your own custom defined Function using VBA Editor

Create aging / bucketing using custom aging function in excel, ready made solution available

How to create your own custom defined Function using VBA Editor

Highlight an entire row based on a rule applied on a cell using conditional formatting

How to highlight duplicate cells in a range using conditional formatting

Combine text and dates using Concatenate (& Operator ) and Text Function

Use Find & Select option to Find Comments, Data validation or Formulas using Find & select option

How to use Clear Function to remove all your comments , Formats, Data or all of them at once

Automate Excel sheet using Vlookup & IFERROR FUN,enter the key field others fields will populate

Drop Down List in Excel / data validation and its uses, how to convert range into table in excel

Use of Excel Add-Ins File Format, save your own functions using Add ins to enable it for all files

Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format

Microsoft Excel different files formats with extension and their uses

Count with multiple condition using countifs function, how to use countifs Function

Convert number into aging/bucketing by creating FUNCTION in VBA.Enable FUNCTION to work in all files

Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook

Run Macro on any excel file by just storing your MACRO in Personal Workbook/Use of personal workbook

Change Double touch right click setting to Single touch right click for Macbook Pro Users

Consolidate / Merge Multiple workbooks / sheets in single Workbook / sheet using Excel VBA MACRO

Copy all files and folders name in text file using DIR command in command prompt /CMD

Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names

Count duplicate values using IF Function when you are working on a lakhs of excel rows & columns

Most Commonly/frequently used top five excel Shortcut Keys

Count duplicate values using countIF function / Use of CountIF function to check duplicate values

How to SPLIT a big file of any format using WINZIP split Option and send it through email to user.