Gantt Chart in Excel – How To + Free Template + Online Gantt Chart...

Gantt chart is the simplest-most effective visual for planners and project managers. The most favourite tool to make gantt charts is Excel for two reasons: we curate data in Excel and; Excel stacked bar...

LIFO Inventory Valuation in Excel using Data Tables – How To

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

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 be achieved with even lesser efforts using power query. Power...

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 really wish we had a formula or a feature that...

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 few weeks explaining every bit that how its done from...

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 down list and are far superior and flexible than usual...

Turn off Excel Table Formulas / Structured references

Although I absolutely LOVE Excel tables and the reason is not just 1 or 5 or 10 but more than 20 to make you awesome in Excel. And one of such reason is structured references which in simple...

Convert Numbers to Words/Text in Excel WITHOUT pasting macros again! – NUMWORD Excel Addin

https://www.youtube.com/watch?v=huozBRRIq1c This has been long overdue and I am happy that an Excel add-in that helps convert numbers to words or text is finally here. Just install...

Working on Multiple Excel Worksheets – 3 Tricks to know!

Intro - Working across multiple worksheets at once! Excel's workbook can be divided in several worksheets and by design its quite efficient as worksheets can act and work as independent unit and still easily interact in...

Format Dates as Yearly Quarters in Excel – How To

For reporting purposes sometimes its elegant to show dates as quarters of the year instead of months. It helps managing clutter in a large set of data. As much as I wish there was...