Modern Microsoft Word (Office) has some picture tools which can convert an image into an outline that kids can use for coloring in. We’ll be the first to admit, the image to outline options aren’t great but they are serviceable, quick and easily done with tools you have in Microsoft
It is possible to send and receive faxes without a fax machine. At least you can send a fax from your computer without a fax machine because there are online services to do that for you. We’ve noticed some press reports were overwhelmed offices have reverted to faxes because their
Find and add the Indian 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 Indian Flag Image There are many, many copies of the Indian flag available. We’ve opted for
Word and PowerPoint allow you to not only put a colored border around a picture, instead try a pretty gradient effect for single color or multi-colored rainbow effects. Like most of the fancier border effects, you can access gradient border settings in the Format Picture pane, by going to Picture
Many café, restaurants and other businesses are closed due to the pandemic but still missing an opportunity to keep in touch with customers. Here’s a sign and tips to help recover when restrictions are lifted. There’s a lovely café near us which has closed for the duration. It would be
Excel’s Workday() function counts working days before or after the starting date. The counted workdays automatically excludes weekends (Saturday and Sunday) and can account for holidays. We previously explored the NetworkDays.Intl() function in Microsoft Excel to calculate the number of working days between two dates. Workday() is similar but returns the date (past or future) after the number of workdays. It is useful
If you have words or longer sections of text that you type frequently and don’t want to have to type in full each time, Word allows you to set your own shortcuts to automatically enter this text in a few keystrokes either AutoCorrect or AutoText. There are two ways to
The Excel function EOMONTH() returns the date of last day in a month. With a little extra, it’ll tell you the number of days in any month. EOMONTH() is the Excel equivalent of the little rhyme ‘30 Days has September, April, June and November …’ plus it handles leap years with 29th
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,
Windows 10 1709 (Fall Creators) for Enterprise ENT and Education EDU is having an extended lifecycle until 13 October 2020. No word yet on Microsoft Office policy. That’s to give those organizations some welcome stability at this time. The last thing customers need at the moment is a forced revamp
You can set up your own shortcuts to quickly apply any style in Word. You’re not limited to the in-built shortcuts for Normal and a few Headings. You may be familiar with using keyboard shortcuts to such has Ctrl+B or Ctrl+I to quickly change text to bold or italic but those don’t apply styles, just
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
Office users often want a second screen, especially when using a laptop. We’ve discovered Duet, an efficient and elegant way to use an iPad as an extension screen for a Windows or Mac machine. Mac users get the bonus of the new ‘TouchBar’ for older Macs. Duet impressed with the
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,
Making a list of all the days between two Excel dates is possible in various ways, manually, an Excel 365 formula or some VBA code. We need a way to make a list of all the dates between a start and end date. Use this to make a list of
If you’ve ever tried to enter a number starting with zero into an Excel spreadsheet, you will have had the frustrating experience of finding that as soon as you exit the cell, the zero disappears from the front of the number. Here’s how to stop Excel from ‘helping’ you when
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
Here’s a limited solution to the problem of excluding multiple holidays or vacation lists to use in NetworkDays() or NetworkDays_Intl() and a request to Microsoft for an improvement in the function. NetworkDays() or NetworkDays_Intl() is OK if you only have to deal with one list of public holidays or one
We looked at the handy NetworkDays.Intl() function in Excel and mentioned that the Holidays parameter is a lot more complicated that it appears. Let’s look at how Holidays works and how it gets messy when faced with real world applications. Quick Recap of NetworkDays.Intl() Just to recap, NetworkDays.Intl() lets Excel
Here’s a step-by-step example of Networkdays.Intl() in an Excel worksheet. We suggest using that improved function over the older NetworkDays() with less options. As usual, you can select the formulas tab and Excel will guide you through the process. From Formulas | Date & Time choose NETWORKDAYS.INTL . It will
