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.
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
Our annual Microsoft Word vs the Spelling Bee Champions contest is on again for 2022. Word has done better than in the past but was still beaten by another extraordinary 14 year-old. 2022’s Spelling Bee Champ is Harini Logan, 14, from San Antonio TX who narrowly beat Vikram Raju a
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used
A first look at the new “New Outlook” which Microsoft (deliberately?) leaked ahead of an official announcement. It’s interesting but with one major and very disappointing omission. This article has been updated now “New Outlook” (as it’s now called) has been released to Office 365 Insider users. As you can
There are two different ways to access a Microsoft Office document that’s saved on OneDrive. We’ll explain both and why it’s sometimes important. Microsoft’s OneDrive stores documents on servers. Programs (like Office) can open those files directly from the cloud service. Or the OneDrive app can copy (synchronize) files from
Add the Duck 🦆 emoji into Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Duck 🦆 emoji represents the quacky bird with webbed feet. The emoji is usually depicted as a Mallard. Sometimes used as a substitute for the f-word, because of iPhone’s tendency
A simple question – what characters can you put in an email address? Like many things to do with the Internet the answer isn’t as simple or direct as you might think. We’ll look at what makes a valid email address, both in theory and in practice. A simple question
What are the real words for really big numbers, waaay over a trillion? Does Microsoft Word’s dictionary recognize them? (Answer: most but not all and there’s even a spelling mistake in Word!). How many is a billion anyway? We’ve looked at the informal words for vague large numbers such as
Like Word, PowerPoint and Excel also have options to add borders to pictures to add that extra oomph to your work. Users can choose between fairly simple borders or add some further complex, fancy styles to their images. If all this seems very familiar, it’s because the same picture tools
Type the Grinning Cat with Smiling Eyes 😸 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Grinning Cat with Smiling Eyes 😸 emoji is a variant of the grinning face emoji or the cat face emoji, which is yellow on most
We’ve seen many cheap Microsoft Office 365 Family, Personal and other plans sold as ‘lifetime’, ‘perpetual’ or ‘never-ending’. It’s all lies. Some deals are obviously scams, like this one for just US$3 but others have more plausible prices. They are priced just under the regular street price to seem like
Microsoft has changed the way they rollout new features in Microsoft Office 365 which can lead to confusion and frustration, especially among the Insiders who try out new stuff before it reaches the public. In olden days (say 2018) getting new or changed features was simply a question of having
There’s a small but important point about Microsoft Word with Footnotes and Endnotes. It’s so important we’ve made this separate little article about copying or moving. The footnote or endnote is stored in that little superscript character in the document text. Copy, move or delete that superscript character and the
At long last, Excel v4 macros are being blocked from running in Excel 365 by default. A move that greatly reduces the security risk from infected attachments in Excel 365 and Excel 2021. Excel v4 macros are a very old form of programming, literally 30 years old. It allowed macros
In Microsoft Word, circling around text can place emphasis or enhance the text appearance. There are a few methods you can choose in Word documents and you’re not limited to circles. We’ll show how to add a simple circle like this, plus a lot more. Add shape to document Go
Not only has Microsoft just added 25 more languages to the Dictation feature of Microsoft Office 365, they’ve also promoted six languages from ‘Preview’ to full dictation status. Microsoft has been unusually quiet about all the improvements in Dictation, focusing on the new languages while not even mentioning that six
Organizations which choose the Semi-annual update for their staff have been told by Microsoft that they are being forced to the monthly update schedule. Here are the details and a look at the nonsense that Microsoft is sprouting to explain the switch. Until now, organization administrators had two choices for
Here’s how to start page numbering at any point in a Word document. There’s no rule which says that visible page numbering has to start with Page 1, there are many situations where the first page in Word isn’t ‘Page 1’ as labelled in the header or footer. Some opening
Type the OK Hand sign 👌 into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. OK Hand sign 👌 emoji is mostly used to symbolize approval, agreement, all that is well but there are other meanings. Scuba Divers use 👌 hand sign to
It’s not necessary to convert MP3 audio to the better MP4 format for PowerPoint but, if you want to, there are various ways to do it. MPEG-4 audio (.mp4 .m4a ) is recommended by Microsoft for PowerPoint 2016 (Windows and Mac), PowerPoint 2013 and Powerpoint for mobile devices. MP4 audio
