All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
The wildcard is an advanced finding feature that has some powerful options beyond the standard * and ? options for Word. What Word calls ‘wildcard’ is really Regular Expressions, or at least a version of RegEx. Beginning or end of a word The beginning of a word can be represented
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
How does Microsoft Word’s spell check go with the 2021 Words of the Champions list from the US annual spelling bee? Each year the Scripps National Spelling Bee releases a Words of the Champions study list to educators, featuring up to 800 new words. We grabbed a selection of the
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
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab.
Our annual Microsoft Word vs the Spelling Bee Champions contest has returned for 2021. Word has done better than in the past but was still beaten by an extraordinary 14 year-old. Here’s the list of words used in the final rounds, (rounds 10-18) of the Scripps Spelling Bee as they
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
Excel isn’t just for budgets and number crunching, you can use it for making lists and even organizing your love life! Lisa used Excel to find her True Love. She listed all her dates in Excel with details somewhat like this… Excel, combined with some personal rules. eventually led her
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
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
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,
PowerPoint can show slides on a screen as a high-tech signboard, using a self-running presentation known as Kiosk display. Here’s how to do it plus all the settings and tricks available. We’ve all seen screens displaying information on a series of slides – maybe in a shop or conference. Maybe
Microsoft has added more stock images to Office 365 apps to help people celebrate Mental Health month (May). Also some extra app themes and pictures for Pride Month (June). Mental Health images May was Mental Health Awareness Month so Microsoft added some appropriate Stock Images for documents and slides. They
A little known but useful Teams feature is synchronizing Teams files folders to your Windows or Mac computer. Files are available quickly, more easily and offline via Explorer or Finder. But there’s a trick to getting it working. The official way to access documents and files in Teams is via
Microsoft has announced their plans for later this year with additions to Teams, Whiteboard and an expansion of their Fluid components concept. None of these things are available now. It’s all future promises, nothing substantial customers can use today. Let’s strip away all the hype about ‘hybrid’ workplaces that are
OneDrive has quietly boosted one of its most important features, the ability to synchronize more than one account on the same computer or portable device. Here’s how for Windows, Mac, iPhone, iPad and Android. It’s possible to sync almost all the OneDrive accounts you have access to. A personal OneDrive
How to type Ghana Cedi currency character in Windows or Office, especially Word. After our article about inserting Numero and other symbols into Office – trust an Office Watch reader to find a character not available in a supplied Windows / Office font: ” The currency in Ghana is the
Microsoft Word has footnotes and endnotes features but it’s surprisingly clumsy when it come to the common need for footnotes immediately after a table. Normally, Word puts Footnotes at the bottom of the page but for tables (and occasionally pictures or diagrams) you want them immediately after the table like
Here’s how to stop Microsoft Office for Mac from automatically updating itself and why you might want to do refresh the Office apps. Office 2019 / 2016 for Mac All versions of Office for Mac that have current support (currently Office 2016 and later) get: updates to fix bugs in
Microsoft changes what’s displayed in Excel Map Charts depending on your location and Microsoft’s policies in certain countries like China. We’ve had reports from people in China and Hong Kong that they can’t ‘see’ Taiwan on their Excel Map Charts. In most of the world, China and Taiwan show up
Paying less for Microsoft 365 Family or Personal isn’t easy these days. Why is that and what discount options are still available? There was a time, not so long ago, when getting a discounted price for a Microsoft 365 consumer plan wasn’t hard. All the major retailers sold Microsoft 365
How to type the ‘Numero’ symbol and other special characters – there’s many ways to do it in Word and Office. It all started with a single, seemingly simple, question from a reader. As often happens, the question opens up a whole range of options in Office Entering the Numero sign
Microsoft Outlook is in the final stages of a major improvement in the ‘plumbing’ behind synchronizing calendars across an organization. Leaving aside a particularly outrageous Redmond boast, the changes are welcome enhancements. Outlook and Exchange Server can have difficulties coping with fast changing appointment and meeting arrangements. When several people
Review mode is a very useful sharing choice in OneDrive and Sharepoint for Microsoft Word documents only. It lets people look over and comment on a Word document without changing the text. Only Microsoft 365 Enterprise or Education customers can get Review Mode. Look for it at the bottom of
