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
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
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
Office Watch has been ‘banging on’ about privacy and security for many years so we’ve been asked about the new or upcoming COVID-19 contact tracing apps. Singapore and now Australia have these apps and its likely other countries will release their own apps. We’ll use the Aussie app as an
Nirsoft’s SearchMyFiles has received a major boost. It can now search inside Office documents and PDF’s. SearchMyFiles is the Windows search tool that should be included with Windows. It’s interface might be old-fashioned but all the options are visible, including some not available in Windows. Some of the highlights in
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
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
Word numbered lists can do a lot more than simple 1, 2, 3 so here we’ll show you some better (1st, 2nd) and maybe unusual options (First Level, Second Place etc). All these and more are possible with Microsoft Word’s numbering plus a little knowledge and cunning. Numbering controls are
Format Painter in Office will work to copy formatting between shapes which is very useful for complex Gradients. But they don’t always format copy in the way you’d expect. We’re obliged to Office-Watch.com reader, Lorelei, for pointing out that Format Painter can copy gradient fills in most but not all
A pop-up message to Office 365 / Microsoft 365 says there are ‘more benefits’. Are there extra benefits in Microsoft 365 or is it more Microsoft hype? This dialog appears after an update to Office 365 …. Office 365 is now Microsoft 365 New Name. More benefits. Same price. Microsoft
Word has six shortcuts to make horizontal lines, here’s how they work, change them, color the lines and how to stop lines when they get out of control. All six line shortcuts There are six horizontal line shortcuts. For each one type the same character three times at the start
Microsoft is pushing video backgrounds to PowerPoint slides, but they really are a bad idea and should be banned from slide decks. Designer’s Design Ideas will start with a background video. Microsoft loves showing off these moving backgrounds because they impress people at demonstrations. Moving backgrounds are not a good idea because they distract the
Today (21 April 2020) is that day Office 365 becomes Microsoft 365. What does that mean to you and using Word 365, Excel 365, PowerPoint 365, Outlook 365 etc. A few weeks ago, Microsoft announced that ‘Office 365’ was becoming ‘Microsoft 365’ from today. There’s NO change in the software
Inserting live video into a PowerPoint presentation is possible in different ways. With online meetings and presentations all the rage, it’s natural that people would like to show themselves and their presentation at the same time. Either half and half screen (left) or some variation of video in box (right).
We’ve made a few changes to our COVID-19 tracking workbook for Excel 365. The kind comments from readers are much appreciated. For those of you who asked, it was made by our Editor-in-Chief, Peter Deegan, who is safely locked-down in London. Peter refreshed the COVID-19 statistics (which any Excel 365
Microsoft tries to rewrite history on Clippy. It wasn’t their fault, it was us customers! According to this fiction, there was nothing wrong with Clippy but it was ‘ahead of it’s time’ and customers didn’t understand. That’s complete nonsense. Anyone who used Office 97 knows that. Business Insider reports on
Microsoft has released about 113 security bug fixes for Windows and Office in their April 2020 dump of patches on ‘Patch Tuesday’. The main change is a block on external references in VBA code, a change that hasn’t been fully documented. These security fixes will be pushed out via Windows
Microsoft is being stubborn about the ‘end of life’ deadlines for Office 2010 and Office 2016 for Mac, insisting that both will stop support in six months as planned. That’s in contrast to Windows which has delayed the end of support dates for some versions of Windows 10 to help
Over Easter there was a three day serious breakdown in Outlook.com for Australian users among many. The problems were first acknowledged by Microsoft about 1pm Sydney time on Saturday 11 April and continued for around three days! Mostly Aussies were affected with pockets of trouble in Europe and USA. A
The April 2020 security fixes for Microsoft Office come with a warning that some VBA code will stop working. There are workarounds to let some references through. The KB4557055 security fix blocks VBA references that link to Internet or intranet sources or have been downloaded from the Internet. That will
We’ve made a new version of our COVID-19 statistics workbook that’s compatible with Excel 365 for Mac. Keep track of COVID-19 statistics using this Excel spreadsheet that shows the latest cases and deaths for countries you choose and populations also added for you. Excel 365 for Windows has a separate
Some of the features and tricks in our COVID-19 worksheet for Excel 365. We’ve made this workbook as a practical and timely example of some important recent Excel features and how they can be used. Open up the workbook in Excel 365 for Windows and add some countries to see
Keep track of COVID-19 statistics using this automatically updating Excel spreadsheet that shows the latest cases and deaths for selected countries with populations also added for you. We’ve been a little annoyed at media coverage that deals with raw numbers without adjusting for population. We opened up Excel 365 and
Microsoft is adding what it’s calling ‘Private Annotations’ to Word 365 with OneDrive or Sharepoint, We’re not sure what all the fuss is about because anyone with any version of Word can do the same thing now. Microsoft is trying a ‘quick fix’ for a common user request. Private Annotations
