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.
Microsoft PowerPoint’s Cameo lets you put a live camera feed into your slides. The camera feed can be moved, resized, cropped, and styled just like any other image. Designer in PowerPoint can also be used to add flair to slides that use cameo. Cameo is already in Windows and Mac
One of the most commonly used and confusing Excel functions is much better in Excel 365 and Excel 2021. Vlookup() has a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is available in Excel 365 for
A British medical office has made a right mess of selecting trainee anesthetists by the misuse of Excel. Let’s look at what happened and some ways you can avoid similar mistakes. As told in The Register, the UK Anesthetic National Recruitment Office (ANRO) had the job of selecting candidates from
There’s a hidden part of Excel which can be used to catch ‘data cheats’ or people who tweak workbooks to get the results they want. There’s a news story about research into honesty, the academic is being accused, ironically, of dishonesty in their findings. The Professor is suspected of tampering
The alternative name for India is Bhārat and that term is now being used, somewhat controversially, by the government. How does Microsoft Word handle “Bharat” and what are your choices for either using the word or not. Even if you’re not interested in the name change, it’s a practical lesson
Microsoft is adding Dall-E to new services for Microsoft 365 (Designer), Bing and Office (starting with Word). Let’s look at what Dall-E is, what it can do for you and the fun to be had. In short, Dall-E turns text into an image with often good and sometimes funny results.
Microsoft and Project Gutenberg have joined to create thousands of audiobooks for free, using modern ‘text to speech’ technology that’s amazingly good. And we have some tips on how to create audiobooks with more variety in voice, accent and pace. Since 1971, Project Gutenberg has compiled a wide range of
Microsoft’s alternatives for the new Aptos fonts range are very poor. In some cases, the substitutions make no sense at all. We’ve looked at what happens if a document with Aptos fonts is opened Office 2016 and earlier versions of Word, Excel, PowerPoint and Outlook. Aptos fonts are the new
Microsoft has many little ‘ads’ or suggestions that Microsoft Office 365 users (Windows or Mac) join the Microsoft 365 Insiders program (formerly Office Insiders). Is it safe to become an ‘Office Insider’ and why is Microsoft pushing it so much? Office Insiders is the testing program for new Office features.
Microsoft has fixed the big hassle that comes with the otherwise excellent Lambda() feature in Excel 365 with the new Advanced Formula Environment. Office Watch has sung praises over the power that Lambda brought to Excel. It’s the ability to write custom functions within Excel but without VBA macros. Proper
Unfortunately, copying an image made in Designer isn’t as simple as it should be. Here’s how to grab images made with Designer to use in your own Office documents. Don’t wait, start using Microsoft Designer now It’s easy to paste an image into Designer. Just copy the image from your
There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are important with the Stock and Currency data type in Excel 365 but also other situations. Normally Excel will update itself when you change a cell value. These days there are situations where cells
Insert the Water Pistol or Gun emoji 🔫 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. AND how to make the ‘gun’ point to the right. Water Pistol 🔫 symbol is the only ‘gun’ style symbol in the emoji collection. It’s officially
There are at least ten ways to ‘reverse’ ‘mirror’ or ‘flip’ text or images in a Word document. Horizontal, vertical, reversed, combined or any angle you like. When people say those terms they can mean different things so we’ll look at many options and how to do them. Also along
Modern PowerPoint has made an ‘improvement’ to slide linking in PowerPoint which hides an important feature that’s been in PPT for years … linking to slides or web pages. Sometimes Microsoft gets so enthusiastic about some innovation they forget the basics that customers use on a daily basis. Insert |
Vale Dennis Austin, one of the original creators of PowerPoint has died at the age of 76. Back in 1987 Mr Austin and Robert Gaskins developed ‘Presenter’ for the Mac with some then unique features. A “direct manipulation interface”, what we now call WYSIWYG and take for granted in modern
Inspect without color is one of the more interesting and useful Accessibility tools in PowerPoint 365. It shows a slide in ‘black and white’ or ‘greyscale’ which is useful for more than helping color blind people, Inspect without Color can help improve the readability and design of any slide. Inspect
All about the “Lifetime” or “Lifetime Subscription” Microsoft Office that many web sites are selling. Is it a legitimate, legal version of Office? “Lifetime” Office is NOT a word that Microsoft uses to describe any Microsoft Office product and for good reasons we’ll explain. Lifetime Office is used by other
Microsoft 365’s mail service had troubles on Monday 4th for almost 24 hours. Or did it? Microsoft’s reporting of the incident has been inconsistent and had more than the usual self-serving blather. The Microsoft 365 email outage started on Monday 4th September about noon UTC (early morning in the US)
An undocumented surprise for Office 2021 and Office 2019 customers. The new Aptos fonts are automatically installed in Office 2021/Office 2019 even though Microsoft insists they are for Microsoft 365 only. However, there’s a crucial difference and strange anomaly between how Aptos fonts work in Office 2021/2019 vs Microsoft 365.
Type the fun Eyes 👀 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eyes 👀 symbol / emoji is a bit of fun for documents and PowerPoint slides. How Eyes 👀 looks in different fonts. Eyes is available in symbols fonts like
A few years ago, Microsoft quietly added a little Word trickery to make it easier to Insert Symbols and not get the dreaded blank box or box with question mark. Here’s what Word does and how to workaround the, sometimes unhelpful, fix. Back in the olden days of Word 2007
Insert the Ballot Box with Ballot 🗳 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ballot Box with Ballot 🗳 symbol can be used for any situation around voting or choice. For example to decorate this PowerPoint slide. How Ballot Box
Insert the Statue of Liberty 🗽 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. “Lady Liberty” has symbol/emoji plus stock images, SVG icons or 3D models. How Statue of Liberty 🗽 looks in different fonts Two standard Windows fonts have the Statue
