If you’re looking for 2019 calendar options, open up Microsoft Excel. Excel has a wide range of calendar templates to choose from. Go to File | New and type ‘calendar’ into the search box. There’s a proverbial embarrassment of riches. Pick a year All the Excel templates apply to any
Today’s story from the UK Parliament raised the interesting fact that there’s a difference between Lipreaders and Lipspeakers. Being Office nerds we wondered if Microsoft Word’s dictionary knew about the two words. Let’s start with the basics … The difference between a lipreader and a lipspeaker A lipreader is deaf
Musicians with Excel skills might like to try Excel MIDI an Excel file with a simple sequencer that plays MIDI music. Made by ruiseixas from Portugal, Excel MIDI is an Excel worksheet downloadable from SourceForge. It’s an .XLSM file so you’ll have to enable VBA content to let it work.
If you’re sending meeting requests or invitations there’s an important Outlook option to check. Normally, Outlook within a company, uses Microsoft’s own method for including meeting details. That’s OK ‘in-house’ where you can be sure everyone has Outlook. But you don’t know what people outside the organization use to manage
Pantone has announced its Color of the Year for 2019 but before you run off to grab color swatches, here’s how to get it in Microsoft Office – Word, Excel, PowerPoint etc. The color of 2019 is <drum roll> ….. Living Coral … As usual what’s more amazing than the
Dig a little into PowerPoint for some slide printing choices. They apply to printing slides only, slides with notes, outline or handouts. See also: Print part of a Word document Print selected pages or sections of a Word document in any order Print selection and other choices in Excel The choices
Microsoft has released four security patches that all Outlook for Windows need to protect from newly discovered bugs. The patches apply to Outlook 365, 2019, 2016, 2013 and 2010 for Windows and are available today. The four Outlook security bugs are related. They involved a hacked .RWZ file that could
A previously theoretical way to misuse Office documents to infect your computer is now ‘in the wild’ and Microsoft isn’t interested in stopping it. Last week we told you about a new way for Office documents to get malware onto your computer. Cymulate discovered that the Online Video feature could
A little side-trick for converting text dates to Excel dates is replacing the text separator. Excel lets you replace text within the selected cells only. If the text dates are in the correct order (e.g. m/d/y ) but use the wrong separator for your Windows regional setting (e.g. m-d-y ).
Cymulate is reporting how embedded video in Word or other Office documents are another way for criminals and hackers to infect your computer. It’s yet another example of how Word, Excel or PowerPoint documents can be used to get malware onto computers to steal data, becomes bots or other nasties.
Speed Running, a gamers pastime has come to Microsoft Word. Finding ways to type the numbers 1 to 100 in the fastest time. If you’re unfamiliar with speed running, as we were, it’s playing and recording a pass through a game aiming to complete as fast as possible. Someone came
Changing an Excel formula into the values is amazingly easy. It’s just a copy and special paste. Another way to think of it is deleting the formula but leaving the results in the cells. Select the cells. In this case from our article on converting text cells into Excel dates.
The 2018 Scrabble World Championship is over. How does the Microsoft Word spell check fare against the Scrabble champs? Microsoft Word has slightly different dictionaries for many English language variations (US, UK, Australian etc). Word’s English dictionaries different from the official Scrabble dictionary. Among the words in the final rounds
A judgement from the US Court of Appeals turned on the Word Count feature in Microsoft Word and how it differs from the rules for court submissions. Most courts have rules about the length of submission which, in this case, were accidently exceeded. The plaintiff is representing himself (‘pro se’)
Adding or subtracting months in Excel is easier with the Edate() function. As you probably know, Excel uses whole numbers to calculate dates. Add 1 to an Excel date adds a day. How to add a whole month? How to make Excel jump a whole calendar month? For example from
We’ve added more to Real Time Excel, our comprehensive guide to adding the latest information into Excel easily and automatically. Real Time Excel already has in-depth coverage of Linked Data Types, a new and truly interesting addition to Excel for Windows. On 15 October 2018 we added a bit more
A New York Times article about parents writing their kids college entrance essay reminded us of a forgotten feature in Microsoft Word. A feature of modern ‘helicopter parenting‘ is helping, if not entirely writing, essays for their children. The article How I Know You Wrote Your Kid’s College Essay by
An Australian university has developed a font that will help you remember what you read. It sounds like an April Fool’s joke, but the font is real and works in Office for Mac or Windows. Sans Forgetica was made at RMIT University in Melbourne, Australia. Unlike most fonts, Sans Forgetica
Adding email, calendar and contacts Live Tiles to the Windows Start Menu would seem like an obvious thing to do. Here’s how you can workaround to do it. On the Windows 8 and 10 large Start Menu are ‘Live Tiles’ which are updated to show the latest information. Some of
A fun new font using famous logos for letters also demonstrates where Windows 10 and Windows 11 color font features become useful with Microsoft Word. Brand New Roman is a fun mashup font made up of famous logos. It looks best in color so it’s handy that Windows 11/10 supports
The Windows clipboard is quite limited but there’s a better one hiding inside Microsoft Office for Windows. It can collect more items, paste in any order and be cleared when you like. We’ll also show how to keep the sometimes annoying pane out of the way. You’re about to hear
A new report from Sophos shows how hacking via Office documents has changed of lot in 2018 with new attacks coming much faster than in the past. Microsoft’s assurances that a security bug (sorry ‘exploit’) hasn’t been used ‘in the wild’ doesn’t mean a lot. Office document hacks made in
Outlook has only one date and time related feature in email messages. As you may know, Outlook’s email editor is really Microsoft Word with limited features. On the Insert tag there’s a Text | Date & Time option which opens the same dialog as in Word. Update Automatically inserts a
Each Word document has various hidden data fields and some are called mapped content controls. They let you set some text or date in a document which is automatically repeated any other place in the document that has the same control. Mapped Content Controls are an alternative to other ‘repeating
