Pivotby() is a new and easy way to make PivotTables in Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. We’ll dig into the detail of what PivotBy() can do. Excel has been able to group or combine data for many years but now all you need […]
For many readers being able to edit incoming Outlook messages is just a handy feature, but for anyone in the legal or corporate world it could have ‘interesting’ consequences. In Outlook for Windows, open the email in a full window (not the Reading Pane) then go to Message | Move | Other Move Actions | […]
What’s the story behind the “Update Licence” option that’s appearing in Microsoft 365 apps? What does it mean and when to use it? In Microsoft 365 for Windows you might see a new item on the bottom of the File menu called “Update Licence”. It’s strangely prominent and misleading, based on question from our readers. […]
There’s a useful but niche Excel warning about date with two digits for the century. That’s a useful precaution but sometimes the warning is wrong! Those of us around at the turn of the century will remember the Y2K problems and possible mistakes with a date that has only two digits. For example, “15 April […]
Copilot AI makes writing Excel formulas a lot easier but you still need to check the results to make sure Copilot has understood want you want and gives the right answer. There’s a lot of hype and promises about how AI can help make work easier. That’s not as true as Microsoft and others are […]
