See the amazing amount of information Microsoft is getting from Windows and Office
Both Windows and Office send an astonishing amount of data from your computer to Microsoft. Here’s how to see what’s being sent. The Diagnostic Data Viewer shows, as it happens, what your computer is sending to Microsoft. The tool does NOT give you the choice to not send your private information. It only tells you […]
Password Protected file sharing links with OneDrive
An overdue and very welcome addition to OneDrive for Office 365 customers is password protected sharing links. Until now, you could send a link to a OneDrive stored file or folder but there was no control over who used that link. If the link ‘escaped’ to other people, they could download or even edit the […]
Compulsory MS Office training for North Carolina lawyers
The North Carolina State Bar is proposing attorneys get an hour of computer training, including Microsoft Office, as part of their annual Continuing Legal Education (CLE). Only one US State, Florida, has a computer component of their current CLE. Amazing! In Florida, lawyers have to get three hours of technical training every three years. That’s […]
PERCENTRANK Excel Functions
Excel has three PercentRank() functions to give you the percent ranking of a value in a list of numbers. It’s different from the Excel rankings we’ve discussed before, because this is a percentage or percentile ranking Let’s start with a simple example. There’s a list of values from 1 to 29 on the left. Column […]
Security bug patches in Office for May 2018
Another month, another set of security bugs in Microsoft Office. It’s Microsoft’s version of Groundhog Day. The May 2018 dump of patches involves 102 updates covering: Office versions from Office 2010 to the latest Office 2016 Core Office features Word Excel Sharepoint and Project server. Most people don’t need to do anything. Windows and Office […]
Make your own Word virus for $40
In case you thought making a Word or Excel virus attack was hard, think again. The ‘Rubella Macro Builder’ will sell you a DIY kit with updates for just US$40 a month. The virus maker will take you through the steps to make a hacked Word or Excel document that can infect a computer and […]
Choose vs VLOOKUP in Excel
It’s easy to get mixed up between two seemingly similar Excel functions – Vlookup() and Choose() . Here’s how to, er, choose between the two. Choose( index_num, value1, [value2], [value3].. ) lets you select one item from a list within the function. For example: Choose(2, “High”, “Middle”, “Low”) will return the second list item; “Middle”. […]
Checking a Word mail merge for bad names or test strings
In the UK there’s been a lot of laughs and some red faces about a money raising letter ‘signed’ by the Conservative Prime Minister to a ” Mr Youmustbe F*ckingjoking ” and sent to a pensioner. It’s easy to laugh but anyone who has done large mailings knows that it’s a case of “There but […]
Warning about *.doc and other wildcards for Office documents.
Will R. an Office-Watch.com reminded us of a trap when dealing with .doc and .docx files. “I opened a command prompt and did a del *.doc. Imagine my surprise when it deleted both .doc and .docx files (I have backups). ” Firstly, a teacher’s gold star plus wise owl stamp to Will for having backups! Yes, it’s […]
Truly exciting new Excel features … we really mean it
Options to easily import live data about stocks and locations into Excel are coming. Microsoft is uncharacteristically quiet about these new features and not using their usual hype. Microsoft is soft pedaling these features by talking about ‘new data types’ which sounds very dry and complicated. It looks more interesting when you see it in […]
Why bother with bulk conversion of old Office documents to new formats
Should you even bother bulk converting old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.)? It’s tempting to look at your older documents (doc etc) and think about converting them into the newer Office formats. There’s some advantages to conversion but it’s more difficult than you might expect and probably […]
Why you should delete .doc .xls or .ppt files
If we’ve said it once, we’ve said it a thousand times … ignore or delete any .DOC .XLS .PPT files you get via email or shared. The main carrier of virus infection is Microsoft Office documents, a fact that Microsoft doesn’t like to talk about. What Microsoft doesn’t say is that the major source of […]
Should you submit to Microsoft?
What should you do when Microsoft asks to see one of your documents? Submit the files or not? There’s no easy answer when Microsoft asks to see a file from your computer for their anti-virus system, Windows Defender. Do you send the files or not? This can happen with Defender hits a file that seems […]
What is the cloud and what does it have to do with Microsoft Office
You’ve all heard about “The Cloud” as if everyone knows what it is. It’s clear from recent reader messages that not everyone knows about The Cloud. Or they think they know. Or they don’t realize how much the cloud can and will do. Office-Watch.com explains the cloud and how it applies to Microsoft Office. What […]
Sync your Office Recent Documents between devices
Timeline was a new feature in Windows 10. It was a way to see which documents and files you’ve opened across all your devices. What you won’t hear is that Office already has a similar feature. The Office team has already synchronized the Open / Recent Documents lists across Word, Excel and PowerPoint for PC, […]
Microsoft security holes at record high even in the latest Word, Excel and PowerPoint
A new report confirms what most Microsoft Office customers know; there’s more security patches in Microsoft products, despite years of promises. Not just the latest Word, Excel and Powerpoint but even new products like the Edge browser are increasingly vulnerable. An Avecto report shows 87 vulnerabilities in 2017 – a record high. A dozen of […]
