A new report lists the top software vulnerabilities of 2019. Little surprise that Microsoft and Office feature in the top ten but not with the latest security bugs. Recorded Future’s report is headed 2019 Vulnerability Report: Cybercriminals Continue to Target Microsoft Products and lists the top ten vulnerabilities of 2019.
It’s nice to see a small but important tweak to the Ink editing ‘Lasso’ feature in Word 365. Lasso now selects only inked elements when embedded with text. Lasso is a way to use a digital pen to select objects in Word, either to move or delete. However it’s been
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the Canadian Flag Image There are many, many copies of the Canada flag available.
Here’s some more detail about the Excel Subscriptions Manager, how it’s put together, what you can change and extras to consider. See also Starting with the Excel Subscriptions Manager about how to setup the spreadsheet. Table The whole thing is an Excel Table cunningly called Subscriptions. Formatting, especially alternating row shading
Here’s what to do once you’ve downloaded our Excel Subscriptions Manager to organize the many subscriptions now available. After opening there’s a few things to do first: Currency prefix Change the currency if $ doesn’t apply e.g. change to STG ₤, Euro € etc. We’ve made that easy with two
Maybe there will be ads in a future release of WordPad. Microsoft is testing the waters with some Office 365 ads in some test versions of Windows. There’s been a lot of hyperventilating coverage about WordPad ads as if it’s a done deal to appear in Windows soon. The idea
Microsoft has an Office extension for the Google Chrome browser which adds links to the online versions of Word, Excel, PowerPoint, OneNote and OneDrive. This free Office extension has been available for some time. Not to be confused with ‘Microsoft Search in Bing quick access’ that’s being forcibly added to
Word styles can be tweaked to insert fixed characters before the text. Prefix anything in a certain style with your choice of characters or words. Suffixing, or adding after some text, is a lot harder. Word’s prefix and suffix support is poor and very limited. This article shows what’s possible
Courtesy of the good folks at Popbitch comes this groaner; To the person who stole my copy of Microsoft Office, I will find you. You have my Word. Joker from Office 365/2019 Icons with some extra formatting Boom, boom. We’re here all week. Try the chicken. Don’t forget to
It’s the Chinese Year of the Rat, to celebrate in Word, PowerPoint or Office generally is easy with an Icon or Online Pictures search. Not interested in the Chinese New Year? These same tips apply to many other events or festivals. Rat Icon Insert | Icons has many graphics including
Microsoft is planning to force Office 365 ProPlus users to use Bing Search with their Chrome browser. A heavy-handed move that’s annoying IT admins but is also misunderstood, so here’s what definitely happening and NOT happening. This applies to the volume licence version of Office 365, called Office 365 ProPlus.
A ‘new’ Office 365 feature is ‘Save As Picture’ to save Office objects like shapes, icons, images and charts as a picture. It also comes with a mystery because this ‘new’ feature isn’t new at all in Office 365 and Office 2019. It’s a useful little trick, right-click on any
There are many ways to edit a logo or graphic in Microsoft Office; recolor, outline, shadow, reflection plus Shape options. All demonstrated here using the Star Trek logo ready for Word, PowerPoint or Excel. We’ve found the iconic logo in the best form to use in Office. Even if you’re
Microsoft Office, especially PowerPoint and Word, have simple and easy ways to ‘jazz up’ a simple image, flag or logo with one of the many framing options. Instead of just copying a graphic into a document or slide, try one of these variations. They retain the original image but give
If Office for Windows shows Unlicensed Product errors, there’s a bewildering range of errors and prompts appearing. Here’s what to do, and in what order, to solve the problem. Starting Office for Windows and you’re greeted with various warnings like this. Subscription Expired may or may not be true. This
One of the sillier online debates is an argument about the usefulness of algebra and other maths skills in a world where Excel is available on almost any screen. To us this is silly because it’s not a simple either/or choice. It’s about balance, a concept that’s not fashionable these
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
Here’s the bug fixes and changes in Office 2016 just released by Microsoft with a summary of what caught our eye. Outlook 2016 – secure email changes KB 4484212 The default hash algorithm for S/MIME changes. The default is SHA1 except when a new registry key is present. Details in
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
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
