Excel’s PowerQuery has many clever tricks, one of them is merging and matching data from multiple tables into a single table. Combine, clean, and transform data from multiple sources into the single format you need; a table, PivotTable or PivotChart It’s a simple relational database with relations set to match up the rows in each […]
Ever since Word 2013 there’s been a line alignment bug in Word. Line and Arrow shapes aren’t straight, horizontal or vertical. Here’s how to fix this ten year (and counting) bug. Whenever a line or arrow is inserted (Insert | Shapes | Lines ) the result is always a little off. The end points never […]
There’s about to be a big change in how you login to Outlook.com (Hotmail.com, live.com email and it’s best to get ready now. We explain which email apps are already setup OK, some apps might need a simple change while others have to be replaced. From 16 September 2024, Outlook.com won’t just accept a simple […]
Don’t fall for the myth that’s stopped you from more secure online accounts. For some years we’ve been banging on about Two-Factor Authentication. ‘2-fac’ is one of the main protections against online hacking and identity theft. Savvy online users have 2Fac for their main online accounts: Microsoft/Office 365 account, Google. Facebook, banking and especially any […]
A new Windows 11 option will let you update Windows, Microsoft Office and other Microsoft apps at the same time. Is it such a good idea? In the latest Windows 11 Insiders there’s a new choice “Receive updates for other Microsoft products” which defaults on. Find it at Settings | Windows Update | Advanced options. […]