One of the many Olympic traditions is how the medal table is sorted. Here’s how to handle Olympic sorting in Excel, as an example of its special sorting features plus some other related tricks because we can’t help ourselves. Olympic Medal Table sorting Traditional Olympic medal tables prioritise the number
Type the Om or Devanagari Om ॐ symbol in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. The Om symbol is a divine sign that denotes the essence of absolute truth, Atman or consciousness. In Hinduism, Buddhism, and Jainism. The syllable is chanted either separately or before a spiritual recitation.
Microsoft has a new Outlook that appears as a pull-down list in the Edge browser. A mini-Outlook that shows email, calendar, contacts and To Do without taking up a whole web page. We’re calling it ‘mini-Outlook’ but Microsoft insists on just calling it ‘Microsoft Outlook’ because apparently there aren’t enough
TrimMean() function is a slightly different and useful measure than the regular Excel Average(). It’s still an average/mean but without the high and low, extreme or outlier values in the list. Average() (and its partners AverageA() and AverageIFS() use all the values in the array or list provided. TrimMean() excludes
Office 365 for Windows is getting a ‘visual refresh’ a changed look to the ribbon and overall appearance of Word, Excel, PowerPoint and Outlook (the other Office apps will change later). This new look is currently in beta testing and may change a little before public release. It’s only fair
Type the Weary / Distraught face 😩 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Weary / Distraught face 😩 emoji is also called Wailing, Frustrated or Sadness. How Weary / Distraught face 😩 looks in different fonts. Here’s some examples of
The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch
Office 2007 and later to Office 365 not only has keyboard shortcuts but in many ways they are better than previous versions of Microsoft Office. For the most part the shortcuts used in Office XP and Office 2003 still work in Office 2007 through 365 also – despite the very
We place all of the “Shortcut of the Week” tips from 2004 in the one convenient place. Tip 1 – Undo The Undo function has become especially important over the years as Microsoft puts more ‘intelligence’ into their products. Sometimes it ‘corrects’ your spelling or re-formats something you were quite
Here’s new suggested backgrounds for Teams, Zoom or other calls, dug out of Microsoft’s not always illustrious past. In other words, they are trying to rewrite the history of Clippy, again. Clippy The new Clippy image is part of Microsoft’s ongoing revisionist history. This campaign seeks to convince people that
Any major Windows or Office update focuses on the new and changed stuff. Inevitably, there are also items removed or ‘deprecated’ (meaning they won’t be improved and will eventually be removed). See all the Office-Watch.com coverage of Windows 11 Windows 11 removes or moves quite a few features, some are
Microsoft has now announced Windows 365, their ‘Cloud PC’ service for businesses. What is a Cloud PC is and why you might use one. A Cloud PC is a whole computer running ‘in the cloud’. You can access this computer from any device and operate it just like a normal
Another round of bug fixes for both Window and Office including an update to the PrintNightmare fix. PrintNightmare is a serious security breach found in all versions of Windows and Windows Server back to Windows 7. The original ‘out of band’ patch was flawed, stopping some USB printers completely. A
Type the Fire 🔥 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Fire 🔥 emoji has many names like Hot, Lit, Flame and Snapstreak How Fire 🔥 looks in different fonts. Here’s some examples of how Fire 🔥 looks
Let’s look at some of the new (or new-ish) stuff in Windows 11. Widgets (again), Voice typing (Speech to text), Meet Now, Teams and putting Android apps on the Windows desktop. See all the Office-Watch.com coverage of Windows 11 Widgets Widgets are returning or to put it another way, Microsoft
We start our look at Windows 11 for Office users with a look at the on-screen changes to the Start menu, taskbar, Explorer, app corners, window positions and grouping, virtual desktops, dark mode and better screen accessibility. Plus which versions of Microsoft Office will work and look on Win11. See
Windows 11 will work on low-power ARM chip computers, as well as the usual Intel systems. What does that mean for Microsoft Office? ARM based devices use less power than Intel chips, so they are more suitable for smaller devices. Microsoft needs to get Windows onto more portable devices and
Criminals try using Microsoft Office to get money from you using various phone scams impersonating Microsoft. Here’s how to protect yourself. Scammers are clever, sophisticated and look very sincere. Often there are stark warnings about dire consequences. In the end they want your money, infect your computer, steal your personal
Microsoft Office 365 is getting a new look for Windows 10 and the upcoming Windows 11. We have a video of the changes coming soon. On Windows 10 and 11, the Office apps get a ‘visual refresh’ to a more neutral, color scheme. Windows 11 apps get what Microsoft calls
Amazon UK was offering Microsoft 365 Family at more than £25 less than the usual price for both new and renewing customers as part of their 2021 Prime Day deals. It’s still available more than a week later! There are a few peculiarities about the offer, we’ll explain those below
It was predicable that the Bezos divorce would lead to scam emails pretending to come from the former Mrs Bezos, now Mackenzie Scott. Mackenzie Scott is now the fourth richest woman in the world, following the divorce settlement with the Amazon founder. Though show might not hold that position for
Tim Harford has an interesting long read on spreadsheets from its origins in the late 14th Century Italy to modern Excel with diversions into smallpox, Enron, Covid and even teasing Bill Gates. The Tyranny of Spreadsheets is on the Financial Times web site. It’s usually firewalled but the link should,
At long last, a more efficient 64-bit version of OneDrive for Windows is available. OneDrive for Windows is the software that synchronizes your local computer with the cloud storage. There are also nifty features to save a lot of disk space (‘Free up Space) or ensure that a file is
OneDrive is getting photo editing options directly in the apps and web site, saving you the trouble of switching to another picture edit app for simple changes. It’s a good move to handle many of the basic, quick edits that are needed. Perhaps before sending by email or instant messaging.
