[Excel Tips] - Readable Names for Complex Formulas

Here is a quick excel tip. In general for Excel formula column will be very difficult to understand. In that case we can read them as you want using below tip. 

• Select the cells containing formulas
• Go to Formulas > Define Name > Apply Names
• Hold Shift and select all the names
• Click OK
• Your formulas will now have names instead of cell references 

*Courtesy: Chandoo - Makes you 'Excel'lent!