All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Add Outlook appointment in another time zone
Outlook for Windows and Mac can easily add appointments or events using times from another time zone. They’ll show up and remind you in your local time. That’s really handy for global meetings or live streams scheduled in other locations. Enter the Outlook appointment or event using the time and time zone given by the […]
Social Distancing signs in Microsoft Word
Now we’re allowed out again, social distancing signs are popping up all over the place. They are simple to make in Microsoft Word using a few lesser known tricks. Here’s five examples that use some of the latest features in Word 365 like Cutout People plus some Word tricks learnt over many years. Text Boxes […]
Pan across a still image in PowerPoint – Ken Burns effect part 2
Give a still image some interest and movement by adding a simple ‘pan’ animation across the photo. This continuing our look at making the Ken Burns or ‘pan and zoom’ effect in PowerPoint. We’ve already shown how to add a Zoom to a still photo – PowerPoint calls it ‘Grow/Shrink’. Now let’s look at the […]
Great OPEN signs in Word for any business
Businesses are reopening, which is great. Here’s some suggestions for big signs to let customers know you’re open, with some Word tips to make the letters as big as possible. What’s needed is a BIG sign that catches the eye from a distance or when passing in a bus. Getting a special oversize sign is […]
Ken Burns Effect in PowerPoint
The ‘moving picture’ or Ken Burns effect can be done in PowerPoint for Windows or Mac. It converts a still image into a slowly moving ‘pan and zoom’ over the photo.. There are several ways to apply a ‘Ken Burns effect’ which we’ll explain starting with a very simple option which only takes a few […]
PowerPoint Background Animation or Ken Burns Effect in Mac only!
PowerPoint 365 for Mac has a background animation or ‘Ken Burns effect’ feature that’s not available in other PowerPoint’s. We have hidden tricks to improve Animate as Background beyond the simple defaults. Animate as Background adds a slow ‘zoom and pan’ effect to a still image, making it a moving ‘Ken Burns’ effect. We’ll show […]
X Æ A-12 in Microsoft Word and Office
Elon Musk and partner have named their child X Æ A-12 (no kidding) how do you type Æ in Microsoft Word and Office generally. The child’s name doesn’t trigger any spelling or grammar errors in Word. No squiggly lines. What is Æ ? Æ or æ is a a-e ligature that was used in English […]
Workbook Statistics finally in Excel
A long last, Excel is getting a quick summary of the workbook statistics including the bounds of the sheet, tables, formulas and external connections. Look on Review | Proofing | Workbook Statistics in Excel 365 for Windows or Mac. There are details for the currently selected sheet and the whole workbook. It’s similar to the […]
London virtual backgrounds for all
Transport for London knows some of us are missing our bus and tube journeys so they’ve made some virtual backgrounds you can use on Zoom, Teams or anywhere else that supports it. Or use as a background on a PowerPoint slide. Go to https://londonblog.tfl.gov.uk/2020/05/01/video-conference-backgrounds/ There’s ‘Sit in collection’, pretend you’re on a bus, train or […]
Excel worksheet with global COVID-19 stats – update
We’ve updated our workbook that imports the latest COVID-19 statistics and combines with population data through Excel 365’s Stock Data Type. No technical changes in the workbook but we’ve added a few more ‘interesting’ or outlier countries. Plus some repeat help tips. Download COVID-19 Global Statistics workbook there’s also a limited Excel 365 for Mac […]
Moving Average in Excel Charts
Adding a moving average line to an Excel Chart is very easy, just a few clicks, with many options. Any chart with a series of values over time will benefit from a trendline like a moving average. What is a moving average? An average / mean is a single value representing a list of numbers. […]
Microsoft Word – the song and video
It was only a matter of time before someone became so bored in the lockdown that they made a song about Microsoft Word. Ghetts, a British ‘rapper‘ (translation: singer/songwriter in the modern styling) has ‘dropped‘ (released) a song and video entitled ‘Microsoft Word’. As a boring white man in his sixties, the song is beyond […]
Section Breaks in Microsoft Word
Section breaks are probably one of the most useful features in Word when you are formatting complicated documents. They allow you to change formatting aspects that would otherwise be the same throughout a document, such as page orientation, margins, columns, headers and footers. Column changes (2, 3 or more columns) need Section Breaks before and […]
Two ways to make Word remember your preferred font
There are two ways to make Microsoft Word open with your preferred font ready to go. Just like with Two Ways to Change Word’s Opening Paper Size there are two ways to change the default or preferred font. Change the base Normal style or open the main Word template and make the change directly. Either […]
Windows and Office are handling COVID-19 very differently
There’s big gap between the response of the Windows and Office parts of Microsoft to the coronavirus troubles. One team has understood the changed needs of customers and adapted; the other part of the same company is carrying on as normal and even taking advantage. Most people think that Windows and Office come from the […]
Single space after sentences now default in Word
Microsoft has changed sentence spacing default setting in Word 365. Now the default is set at a single space at the end of a sentence, not two spaces. You can still choose your own preference or stop the checks completely. Single sentence space vis double spacing is one of those details that people can get […]
