Converting Dates to Quarters for Usual or Custom Fiscal Year using Excel Power Query

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...

Count + Sum Cells based on Cell Colour in Excel – How To

One of the most sought after feature among heavy Excel users i.e. count or sum cells in Excel based on cell background color. I...

All Excel Accounting and Bookkeeping Solution – Template

Its been a while you got any update on Excel but I hope this much awaited template plus complete how to series will follow in next...

Multiple Column Data Validation Lists in Excel – How To

Today we are learning how to make dynamic multi columnar data validation lists in Excel that helps display much more data in the drop...