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.
Making a list of all the days between two Excel dates is possible in various ways, manually, an Excel 365 formula or some VBA code. We need a way to make a list of all the dates between a start and end date. Use this to make a list of
The Konami Code symbols can be used together or separately in PowerPoint slides, Word documents or elsewhere. They serve to demonstrate some tricks and failings in Office and it’s SVG support. The Konami Code graphics caught our eye because they are a useful set of icons or graphics either complete
If you’ve ever tried to enter a number starting with zero into an Excel spreadsheet, you will have had the frustrating experience of finding that as soon as you exit the cell, the zero disappears from the front of the number. Here’s how to stop Excel from ‘helping’ you when
Here’s a limited solution to the problem of excluding multiple holidays or vacation lists to use in NetworkDays() or NetworkDays_Intl() and a request to Microsoft for an improvement in the function. NetworkDays() or NetworkDays_Intl() is OK if you only have to deal with one list of public holidays or one
Here’s a step-by-step example of Networkdays.Intl() in an Excel worksheet. We suggest using that improved function over the older NetworkDays() with less options. As usual, you can select the formulas tab and Excel will guide you through the process. From Formulas | Date & Time choose NETWORKDAYS.INTL . It will
The NETWORKDAYS function in Microsoft Excel will calculate the number of working days between two dates. It will automatically exclude weekends (e.g. Saturday and Sunday) plus you can exclude public holidays and personal vacations. Most people read the function as ‘Network Days’ but it’s really ‘Net Work Days’. Figure out
PowerPoint 365 is now able to create animated GIF’s from presentations. It’s a little limited but the basics are there, and we’ll explain how to get even more from ‘Export to Animated GIF’. Animated GIF’s have long been wanted in PowerPoint. They make simple animations or mini-videos which are widely
It’s too easy to start using the Archive folder in Outlook. Most likely all the setup is done, so you can start using it. If not, the setup is just a few clicks. Archive is a way to set aside selected messages away from the main Inbox or other folders.
For many mailboxes it’s not possible to rename the Outlook Archive folder. But non-Microsoft mailboxes can rename Archive to anything maybe ‘Miscellaneous’, ‘Store’ or just ‘Old Stuff’. In modern Outlook with Microsoft hosted mailboxes (Outlook.com, Office 365 hosted or recent Exchange Server) the Archive folder is an in-built folder like
Move a message to the Archive folder with any of the usual ways to move an item between Outlook folders plus three dedicated special options only for the Archive folder. See Starting with Archive in Microsoft Outlook Archive in Outlook 365 and Outlook 2016/2019 for Windows Archive button Most obvious is
Outlook has three features called ‘Archive’ with the newer versions (Archive and Online Archive) much better than older ‘AutoArchive’. We’ll explain the difference, how to use Archive and why to avoid AutoArchive. Each form of Archive sets aside older messages or emails you’ve finished with. It does that in two
One of the more obscure settings when putting a frame around a picture in Word or PowerPoint is the Cap Type or line ends. This setting only applies when you are using one of the dashed borders with the choices Square, Flat and Round. To put a dashed border on
Join Type is what Microsoft calls the corners of the picture frames – the place where the horizontal and vertical lines join. There are three options: Round. Bevel and Mitre. We’ll show you where those choices are and what they look like. We’ve previously looked at ways to put frames
Microsoft has released some limited time, introductory offers for Office 365 subscriber. They’ll mostly interest parents or people wanting some digital learning. These aren’t permanent Office 365 benefits like OneDrive storage or Skype minutes. Microsoft calls these ‘Partner Offers’, in other words promotional, trial lures to joining (yet) another service.
One of the quiet improvements in Office is the regular updates to the Office dictionary used mostly in Word and Outlook but also other Office programs. They even handle new terms like Coronavirus or names such as Buttigieg. In olden days the main dictionary was only updated with major revisions
Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We covered these broadly in a Framing Pictures in Office and now we will look in detail at the Compound Type, or multi-line borders. Compound Type is Microsoft’s name for the
Hiding in plain sight are some useful tricks for picture formatting within a shape. It’s possible to fit or fill the image within the shape and, importantly, move the picture around with shape outline. Office Watch has already talked about various ways to change the look of an image within
Here are three options for putting a photo inside any Microsoft Office Shape or Icon (Word, Powerpoint etc.). Photographers call it cropping a photo to a shape or graphic. There are three different ways to get the same or similar result. Two are quick and easy. The third option is
Our ebook PivotTables and PivotCharts from scratch now has a bonus extra for all readers, new and existing. Our Subscriptions Manager is an Excel workbook to organize online subscriptions like Netflix, HBO, Office 365 and (too) many more. We’ve just added an enhanced version of the Subscriptions Manager to our
Find and add the New Zealand national flag and alternatives into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the New Zealand Flag Image There are many, many copies of the New Zealand flag available. We’ve opted for the Wikipedia
A new report lists the top software vulnerabilities of 2019. Little surprise that Microsoft and Office feature in the top ten but not with the latest security bugs. Recorded Future’s report is headed 2019 Vulnerability Report: Cybercriminals Continue to Target Microsoft Products and lists the top ten vulnerabilities of 2019.
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the Canadian Flag Image There are many, many copies of the Canada flag available.
Here’s some more detail about the Excel Subscriptions Manager, how it’s put together, what you can change and extras to consider. See also Starting with the Excel Subscriptions Manager about how to setup the spreadsheet. Table The whole thing is an Excel Table cunningly called Subscriptions. Formatting, especially alternating row shading
Here’s what to do once you’ve downloaded our Excel Subscriptions Manager to organize the many subscriptions now available. After opening there’s a few things to do first: Currency prefix Change the currency if $ doesn’t apply e.g. change to STG ₤, Euro € etc. We’ve made that easy with two
