Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
Switch from the new Aptos default font in Outlook to another font that you prefer and is has better readability in Outlook desktop (Windows or Mac) and Outlook (new). Personally I’ve tried to like Aptos fonts but after a few months they still offend my eyes, especially in emails. It’s
Here’s a combined ‘one-click’ way to force an update to both Windows and Microsoft Office at the same time. Normally Windows and Office both update themselves automatically and in the background so you don’t have to worry about it. But there are times when you need to ensure both are
You can do incredible things in Excel but here’s something truly amazing. Someone has made a 16-bit computer chip (CPU) emulation entirely in Excel. We have links to the source code and fascinating video that explains it all. @Inkbox has recreated the basic logic of a CPU to make a
GroupBy is a new and genuinely great function coming to Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. The more we use Groupby() , the more we like it. So we decided to focus on it with detail. Both Groupby() and
Outlook might label some emails as ‘Unverified’ and the photo/initials is just a question ? mark. What does ‘unverified’ mean? Is the email safe to open and how to stop some messages showing as ‘Unverified’? Unverified can appear in mailboxes hosted by Microsoft directly (Microsoft 365, Outlook.com). It’s a feature
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
Microsoft’s Word Comments feature has popped up in the news again over the break, this time to embarrass Milo Yiannopoulos, a former Brietbart commentator. Mr Yiannopoulos is in a legal battle with his publisher over a proposed book and some of the court papers are now public. What’s catching attention
