myexcellearninglog

 SHORTCUTS I HAVE LEARNT 04/04/2025:   Format Painter Shortcut (Keyboard): 🔹 Alt → H → F → P (αλτχουφουπου) ✅ AutoFit Row Height: Alt + H + O + A (αλτχόα) ✅ AutoFit Column Width: Alt + H + O + I (αλτχόι) ✅ Alt + O + A → AutoFormat (αλτοέι)

FORMULAS I HAVE ALREADY LEARNT: =SUM =SUMIF =COUNTIF =UNIQUE =FILTER =SORTBY =IFNA =IFEEROR =VLOOKUP =XLOOKUP =SUBTOTAL =RIGHT/=LEFT =CONCATENATE =TEXT =MONTH/=YEAR

 27/03/2025 =SUBTOTAL(109, column name ) I am also going back to using power query and realised that that data guy from the NHS was a complete idiot lol.  POWER QUERY