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’s Team collaboration service has hit some snags this week in stark contrast to the company’s shameless promotion of Teams over other useful services. We’ll explain what happened and what you can do if the Teams troubles happen again. On both Monday and Tuesday this week, many people had trouble
Microsoft has quietly announced some minor but important slow down in some of their cloud services including the way real-time edits of Office documents are handled. It’s a wise move given the increased demand for cloud services. Microsoft had an outage on their much-hyped Teams services earlier this week. Like
Skype subtitles are great if you’d prefer a text record of your call or you’re hard of hearing and like a text extra. As a bonus, the same subtitles service will translate when talking to someone who speaks another language. Try Skype’s Live subtitles option. It will convert the spoken
Instead of people looking at your face during a Skype call, they can see a computer screen instead. That includes a Word document, worksheet or PowerPoint presentation. Start a call as usual, either an audio or video call. In the call window, look for the menu ‘three dots’ button. It’s
Skype can be integrated into collaborating on Word, Excel or PowerPoint documents. It’s not officially part of Microsoft Office collaboration but is easily done. It lets you work on a document while talking to other collaborators at the same time. Like this … This works with any modern version of
Already we’ve seen signs of stress on Internet access, cloud and streaming services. Do you have alternatives ready to use? Two popular collaboration services, Slack and Microsoft Teams have already suffered slow downs or outages. Part of our Remote Life and Work coverage. Tips and help from experts in working
You can set up your own shortcuts to quickly apply any style in Word. You’re not limited to the in-built shortcuts for Normal and a few Headings. You may be familiar with using keyboard shortcuts to such has Ctrl+B or Ctrl+I to quickly change text to bold or italic but those don’t apply styles, just
Microsoft has just fixed the latest security bugs discovered in Word. They caught our eye because it’s more widespread than usual which is ‘interesting’ in the way of the old proverb*. The bugs are called CVE-2020-0850, CVE-2020-0851 and CVE-2020-0852 Microsoft gives all the deliberately bland title “Remote Code Execution Vulnerability”.
There are several free options to access one computer from another. You can see the screen, type and mouse from a remote location, just as if you were in front of the real computer. Access work computer from home computer Use desktop computer from a laptop or tablet Interact with
Working on an Office document can easily be done between many people no matter how far away they are. Most organizations will have some way to share documents remotely If not, there are clever options available. Instead of exchanging documents (we’ll get to that in a moment), save the document
There are many free tools available to make work and life continue if your movements are limited. Things you should do to prepare for a possible ‘work from home’, ‘no school’ or at worst ‘quarantine’ or ‘social isolation’ of some type. We know what we’re talking about because Office Watch
Microsoft is cunningly pushing Teams as part of its COVID-19 preparedness recommendations. But Teams isn’t the best option for everyone, far from it. Promoting Teams is good for Microsoft and their sales partners but not necessarily their customers. At Microsoft.com there are now special banner ads promoting Teams as the
Microsoft has been talking about document collaboration for a long time but now it’s available to everyone with a recent version of Office and OneDrive. So here’s a simple guide to opening the same document at the same time on multiple computers. You don’t need two people to try out
Here’s how to share a Microsoft Office document that’s saved on a compatible cloud service like OneDrive or Dropbox. All you need is Office 365/2019 or 2016 for Windows or Mac. Document collaboration works in Word, Excel and PowerPoint. Sharing a single file via cloud storage is a lot faster
Office users often want a second screen, especially when using a laptop. We’ve discovered Duet, an efficient and elegant way to use an iPad as an extension screen for a Windows or Mac machine. Mac users get the bonus of the new ‘TouchBar’ for older Macs. Duet impressed with the
Excel’s NetworkDays() and NetworkDays.Intl() need more help to cope with realistic situations with public holidays and more than one vacation. Annabelle Almer started looking at NetworkDays() & NetworkDays.Intl() and we ended up deep down a geeky rabbit hole trying to get the functions working in realistic situations. The functions work,
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.
