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

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

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

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

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