Excel, SAP, Oracle & automation tips — plus wacky facts
Stop retyping the same emails: save .oft templates, insert Quick Parts paragraphs, use My Templates in new Outlook and fill-in placeholders for payment reminders…
Read article →Make important mail stand out: colour mail from your manager, show attachment size and category columns, group by conversation or sender, and save custom…
Read article →Find any mail in seconds with from:, hasattachments:, received: and AND/OR/NOT, and save repeated searches as Search Folders that update themselves.
Read article →Design Outlook rules that don't fight each other: conditions and exceptions, rule order, "stop processing more rules", and server-side vs client-only rules.
Read article →XIRR returns the annualised return for cash flows on specific dates — the right way to measure SIP and mutual-fund returns.
Read article →Find each customer’s most recent order date, last price paid or latest status with MAXIFS, XLOOKUP search-from-last, SORTBY+UNIQUE and LOOKUP(2,1/…) — so duplicates show…
Read article →Grab text from screenshots, scanned PDFs, videos or error dialogs on Windows — using the Snipping Tool’s text actions or Microsoft PowerToys Text Extractor.
Read article →The floppy disk save icon outlived the floppy disk by decades. Where the 3.5-inch disk came from, why it became the save symbol, and…
Read article →What changes with S/4HANA: the Universal Journal, Business Partner, Fiori launchpad apps, analytical apps, personalisation, and how classic GUI and Fiori coexist.
Read article →Snap layouts, clipboard history, Focus sessions, voice typing, Live Captions and more — twelve Windows 11 features that save time every day.
Read article →How purchasing (procure-to-pay) and sales (order-to-cash) flow through SAP: PR, PO, goods receipt, invoice verification; sales order, delivery, billing; document flow.
Read article →Where Ctrl+Z, Ctrl+X, Ctrl+C and Ctrl+V came from — from Xerox PARC’s modeless editing to the Apple Lisa and Windows keyboards we use today.
Read article →
