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.
Office for Mac has keyboard shortcuts to speed up work but they are a lot hard to find than they should be. There’s no direct mapping of Office for Windows shortcuts into Office for Mac. Partly because the Mac has keys that aren’t on a regular Windows keyboard ( ⌘/Command and Option) . Conversely Windows […]
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another symbol. ¥ symbol is easy […]
There is a way to add an online calendar (aka webcal) to Outlook for Mac, even though it’s not directly possible. It’ll also add the subscribed calendar to iPhone and iPad. Subscribed calendars are really useful for adding in events like sports and club meetings. There are webcal:// links available on many web sites. Unlike […]
Recreate the Murphy Brown TV show’s look as a design inspiration for Word and PowerPoint – the fonts, colors and lines. You may not want to use the exact look of the Murphy Brown title card, but it’s a starting point for design variations of your own. We’ll show how to make a similar look […]
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the answer from the formula: =COUNTIF(Table3[Industry],G4) […]
