All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Inside new Natural Language Search for Outlook
Microsoft is hyping natural language searches in Outlook for Windows and Mac, so we dug down to see how it works and for whom. There’s a lot of ‘gotchas’ overlooked in the boasting. According to Microsoft, Outlook now has better searches: “With Natural Language in search, you simply type the way you would ask a […]
Male ♂, Female ♁ or ⚥ symbols in Word & PowerPoint
Should automatically redirects to Male ♂ Female ♁ both ⚥ symbols in Word and Office, if not, please click the link
AutoCorrect is great for larger blocks of text & acronyms in Word
How to use AutoCorrect for more than a word or single character. It can speed up typing of large blocks of text or expanding an acronym into the full name. Paul G writes: “Autocorrect is fantastic for the numerous standard letters, or specific instructions for various computer actions (downloads, etc). 1. I prepare the fully […]
Van Gogh masterpieces right into your PowerPoint slides
The full collection of Van Gogh masterpieces are available online, ready to be used in PowerPoint slides. Here’s how to get good quality images of the great man’s work and use them wisely in slides. Not interested in Van Gogh? These tips show how to fit any image into PowerPoint as a picture or slide […]
Right Pointing Hand ☞ symbol in Word, Excel, PowerPoint and Outlook
How to insert the white right pointing hand ☞ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Officially called “WHITE Right POINTING INDEX” ☞ symbol is a different or novelty form of the right arrow as a hand. It can be used in standard text or a […]
Get more from two free professional PowerPoint Templates
Shutterstock are offering two nicely designed PowerPoint templates for free. We’ll explain how to get more from the professional templates with a few clicks. Minimalistic PowerPoint templates comes in two styles: Dawn and Midnight. Dawn Template Evokes a meadow at dawn with a muted color scheme. Midnight Template Midnight template is a stark, black look. […]
Making Excel worksheets Very Hidden
There are two different levels of hidden sheets within Excel, hidden and the less well-known very hidden worksheets. We can easily hide our worksheets by right-clicking the sheet tab and selecting hide. There’s a more extreme option available. Very Hidden means the sheet/tab doesn’t show up at all in regular Excel and ensures the sheet […]
Black ‘Not Allowed’ circle/line symbol
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with a black background and white center graphic. This isn’t part of the official ISO specification for the symbol but it’s widely used. It’s done by adding a black circle under the main circle/line & graphic (which is changed to white, naturally). An […]
Text and formatting tricks for Excel
Entering blocks of text in Excel is quite easy. What’s not obvious are all the options to make the text easier to enter and look better. Just typing in a cell will enter text. By default it will extend into any unfilled cells. If there’s something ‘in the way’ the text will just stop. Wrapping […]
Special tricks to add iCloud accounts into Outlook 365 for Mac
iCloud accounts can now be added to the new look Outlook 365 for Mac but there are limitations and it’s harder than Microsoft’s ‘help’ says. Outlook for Mac has always been able to link with iCloud using IMAP. Now Outlook 365 for Mac with the new interface can automatically setup a synchronization with iCloud account. […]
Arrived! The first Office bug fixes for 2021
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser patches from last week. At first look, it seems there’s only five Office related patches including two each for Word and Excel. It’s important to keep both Office and the underlying operating system patched. The […]
Great UK deal on Microsoft 365 Family – save £30
Amazon UK has a good deal on Microsoft 365 Family (six user). For the next week only save £30 on the regular price for new and existing customers. Pay £49.99 for (another) year of Microsoft 365 Family, instead of £79.99 which is what Microsoft charges for automatic renewals. Click here for the Amazon UK deal. […]
Using Benford’s Law magic with Excel
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical laws that seems to defy common sense but works for most naturally occurring number sets. It says that in most groups of naturally occurring numbers, the leading digit 1 will occur more than 2 as […]
Better ‘Not Allowed’ red circle/line symbol with text
Continuing our series on the ‘Not Allowed’ symbol, let’s make a versions with text instead of a graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Text in circle Instead of the usual symbol, let’s add […]
Great text & image ‘Not Allowed’ red circle/line symbols
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with text and graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Better ‘Not Allowed’ red circle/line symbol with text has the basics of […]
Excel’s CONVERT function for metric and more
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better. As usual, we decided to write about an Office […]
