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.
It’s the Chinese Year of the Rat, to celebrate in Word, PowerPoint or Office generally is easy with an Icon or Online Pictures search. Not interested in the Chinese New Year? These same tips apply to many other events or festivals. Rat Icon Insert | Icons has many graphics including
There are many ways to edit a logo or graphic in Microsoft Office; recolor, outline, shadow, reflection plus Shape options. All demonstrated here using the Star Trek logo ready for Word, PowerPoint or Excel. We’ve found the iconic logo in the best form to use in Office. Even if you’re
Microsoft Office, especially PowerPoint and Word, have simple and easy ways to ‘jazz up’ a simple image, flag or logo with one of the many framing options. Instead of just copying a graphic into a document or slide, try one of these variations. They retain the original image but give
One of the sillier online debates is an argument about the usefulness of algebra and other maths skills in a world where Excel is available on almost any screen. To us this is silly because it’s not a simple either/or choice. It’s about balance, a concept that’s not fashionable these
Microsoft has updated their Online Services Terms to clarify some privacy issues but concerns remain. They’ve also added yet another document to the confusing mix of legalese customers are expected to understand. Back in August 2019 the Dutch Ministry of Justice released a report that recommended against using Office online
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself. Understand PivotTables by looking at expert examples,
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
It would be great to share draft emails between Outlook on different devices including iPhone, iPad and Android. You can start a message or reply on a smartphone and finish it later on a computer. Sharing drafts between Outlook for Windows or Mac has been possible for many years, only
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost
Microsoft has added Dynamic Array functions to Excel for iOS (iPhone and iPad) and done it in an uncharacteristically low-key way. Dynamic Arrays are now available across all Office 365 platforms; Excel 365 for Windows and Mac, Excel for Android, Excel Online (web) and now Excel for Apple devices. That’s
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options
Yet again, a bad deal for Office 365 is being offered on Amazon and it’s even worse than last time. In March there was an offer on Amazon for Office 365 Home (retail $99.99) plus an Amazon gift card $50 for a total of $149 – a ‘massive’ saving of
Now rolling out to Insiders is a preview of a new look in Outlook for Mac. Here’s what’s on offer and how to get it. Limitation There’s an important limitation on the new interface that’s not given enough warning by Microsoft. It’s only available if one of the email accounts
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you
Excel is getting a clever new way to quickly analyse your worksheets and pull out useful ideas or insights to quickly make PivotTables, PivotCharts and Charts. It’s now available in Excel 365 for Windows and Mac, Insiders and will eventually make it to public releases. It’s now called ‘Ideas’, previously
‘Tis the Black Friday season for savings on Office 365 so we’ll keep an eye on price discounts on Office 365 Home and Office 365 Personal in the USA, UK and Australia. It’s a great time to save on extending or renewing an Office 365 subscription. Below is a guide
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
A wonderfully independent article in the Washington Post reveals a big problem with the sale of fake and pirated products on Amazon. Our articles on fake Microsoft Office products is just a tiny part of a bigger problem. The Washington Post is owned by Jeff Bezos, the head of Amazon
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously at hiding things in Word and Excel, and PowerPoint also allows you to hide things, although the approach is a little different. The most common reason to want to hide
