Four simple clues that an email should be deleted. Among the bogus coronavirus emails was something new to us and apparently the anti-spam filters that should have detected it. We’ll use the dangerous email as an example of what to look for in a scam or virus-infected email. The email
We’ve added more documents and slides to our template collection, Keep Calm with Microsoft Office with extras like ‘Keep Calm and Wash Hands’. The new designs include useful graphics for coronavirus, biohazard symbol and a hand washing graphic. These and many more Word docs & PowerPoint slides in Keep Calm with Microsoft
Here’s a download of the standard but blank Warning Triangle graphic and image ready for Word and PowerPoint. We’ll look at the official warning sign specification as a starting point, then we’ll look at variations based on that. In other words, symbols that look a bit like a warning sign,
No surprise that criminals are using Coronavirus/COVID-19 as a way to trick people into opening nasty Word document that could infect your computer. All the usual suspects are trying to take advantage of Coronavirus to sell stuff. Plenty of fake ‘cures’ being touted, usually existing ‘miracles’ rebadged to take advantage
Here’s how to share a Microsoft Office document that’s saved on a compatible cloud service like OneDrive or Dropbox. All you need is Office 365/2019 or 2016 for Windows or Mac. Document collaboration works in Word, Excel and PowerPoint. Sharing a single file via cloud storage is a lot faster
Here’s another example of why older .DOC Word documents should be avoided. This time it’s a fake Norton LifeLock email and hacked document. The Word .doc document has a fake login dialog . Source: Unit 42 The document executes a known remote access tool NetSupport Manager. That tool has legitimate
Excel’s NetworkDays() and NetworkDays.Intl() need more help to cope with realistic situations with public holidays and more than one vacation. Annabelle Almer started looking at NetworkDays() & NetworkDays.Intl() and we ended up deep down a geeky rabbit hole trying to get the functions working in realistic situations. The functions work,
A new type of infected Word document is doing the rounds with the name ObliqueRAT with a few new tricks. ObliqueRAT is similar to an earlier nasty CrimsonRAT but has a range of infection capabilities and is encrypted. Password Protected The infected Word documents usually arrive via email and are
The NETWORKDAYS function in Microsoft Excel will calculate the number of working days between two dates. It will automatically exclude weekends (e.g. Saturday and Sunday) plus you can exclude public holidays and personal vacations. Most people read the function as ‘Network Days’ but it’s really ‘Net Work Days’. Figure out
Microsoft Word’s ‘Pickup where you left off’ or ‘Welcome back’ message is different from the Shift+F5 shortcut. All the recent talk about the ‘Pickup where you left off’ feature in Word had a few Office-Watch.com readers asking how it’s different from the long-standing GoBack shortcut in Word – Shift +
One of the more obscure settings when putting a frame around a picture in Word or PowerPoint is the Cap Type or line ends. This setting only applies when you are using one of the dashed borders with the choices Square, Flat and Round. To put a dashed border on
Join Type is what Microsoft calls the corners of the picture frames – the place where the horizontal and vertical lines join. There are three options: Round. Bevel and Mitre. We’ll show you where those choices are and what they look like. We’ve previously looked at ways to put frames
Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We covered these broadly in a Framing Pictures in Office and now we will look in detail at the Compound Type, or multi-line borders. Compound Type is Microsoft’s name for the
Find and add the New Zealand national flag and alternatives 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 New Zealand Flag Image There are many, many copies of the New Zealand flag available. We’ve opted for the Wikipedia
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.
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.
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
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
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
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
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
