Microsoft has updated their Online Services Terms to clarify some privacy issues but concerns remain. They’ve also added yet another document to the confusing mix of legalese customers are expected to understand. Back in August 2019 the Dutch Ministry of Justice released a report that recommended against using Office online
The US National Security Agency (NSA) discovered a serious security bug in Windows and, for the first time, told Microsoft so the company could fix it. That bug could also affect Microsoft Office or other programs. It’s important to update your Windows 10 asap, that’s not our opinion, it’s the
Here are two options to stop Microsoft Office for Windows from automatically updating itself and why you might want to do that. Office for Windows All versions of Office that have current support (currently Office 2010 and later) get: updates to fix bugs in the software patches to stop security
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
The second Access memory leak has finally been patched by Microsoft, almost a year after a very similar problem was discovered. These bugs have been around since 2002 and the effects are still in some Access files. Both are faults in the way Access saves data to memory locations in
PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself. Understand PivotTables by looking at expert examples,
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Time is running out before the end of support for Windows 7. Here’s what’s happening, what to do, what not to do and the way some Office 365 users can still use Win7 with Microsoft support. The end of Win7 support affects many people and businesses. Even in late 2019,
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
Criminals don’t even respect Santa and the festive season with malware infested emails pretending to be holiday schedules or the Christmas party. Is nothing sacred? Cofense Labs report that Emotet botnet is being spread via Word documents with timely emails for the end of the year. All these dangerous emails
It would be great to share draft emails between Outlook on different devices including iPhone, iPad and Android. You can start a message or reply on a smartphone and finish it later on a computer. Sharing drafts between Outlook for Windows or Mac has been possible for many years, only
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost
Microsoft has added Dynamic Array functions to Excel for iOS (iPhone and iPad) and done it in an uncharacteristically low-key way. Dynamic Arrays are now available across all Office 365 platforms; Excel 365 for Windows and Mac, Excel for Android, Excel Online (web) and now Excel for Apple devices. That’s
The Office apps on Windows 10 Mobile devices have now ended main support and will end security updates, hotfixes and support in 2021. It’s an unsurprising announcement and another death notice for the failed Windows 10 Mobile platform and phones. Source: Microsoft, from happier days when Win10 phones were ready
In a recent blog post Microsoft explained some of their thinking behind the redesigned Office mobile apps like the new ‘all in one’ Office app. The company has done a lot of research into the way people use their mobile devices, including the many people who only use a smartphone
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Outlook’s Groups support is improving with ways to filter Group emails and let you control which emails appear in the Inbox. Admins can manage the names given to new groups, enforcing prefix/suffix and stop specific words from appearing in Group names. This is new in Outlook 365 for Windows v1912
At last! The clutter of right-hand panes in Microsoft Word is ending and we’re getting tabbed panes. Very welcome news for laptop users with less screen real estate. According to Microsoft: “ Now you can switch between multiple panes using a tab UI on the right hand side of the
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options
Yet again, a bad deal for Office 365 is being offered on Amazon and it’s even worse than last time. In March there was an offer on Amazon for Office 365 Home (retail $99.99) plus an Amazon gift card $50 for a total of $149 – a ‘massive’ saving of
The Office apps for Android are getting some interesting new features. Excel for Android has better sort and filtering. Galaxy Watch can now link to the Outlook app. At first for preview ‘Insiders’ and later to the publicly available Word, Excel, PowerPoint and Outlook apps. Here’s Microsoft announcement of the
Microsoft is ending their Delve blog service starting later this month. It’s being done with little notice and in a very round-about way. Delve blogs aren’t widely used and their end has been anticipated by some network admins. Even so, Microsoft has badly handled the announcement. Instead of a Microsoft
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you
