Excel

LIFO Inventory Valuation in Excel using Data Tables

How good is it that we learn to automate cumbersome calculations in Excel like FIFO and LIFO. Last time we discussed FIFO valuation using...

Converting Dates to Quarters for Usual or Custom Fiscal Year using...

A while back we learnt how to convert normal to date to yearly quarters using formulas and in that we learnt different presentations. Same can...