Posts

Budget 2025-2025 : Summary

MS EXCEL: Bonus badass function ( Indirect, hyperlink, webservice, filterxml)

MS EXCEL: Dynamic Arrays (sort(), filter(), sortby(), unique (), sequence (), randarray(), frequency (), bin, let(), transpose ()

MS EXCEL: Date& Time functions( Date, today(), now(), year/month/day, Eomonth, yearfrac, weekday, workday, networkday, datedif)

MS EXCEL: Text formulas( upper/lower, proper, trim, concatenate, text, value, mid, left, len, search, find, substitute)