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
It was surprising and frankly disappointing to see Amazon USA post a very dubious offer for Office 2019 Professional Plus at just US$46.99. Office 2019 Professional Plus sells for around $559 but only as a volume licence. There’s no retail version of Office 2019 Professional Plus. This offer is doubly
Various ‘news’ stories going around promising a trick to getting Office 2019 for free … don’t believe it. We know a way to get Office 2019 cheap, but not free. Maybe these ‘Office 2019 for free’ stories are deliberate clickbait or horribly ill-informed, either way they’re quite wrong. As often
Microsoft has released Office 2019 for Windows or Mac to the Home Use Program. Just $15 gets qualifying employees Office 2019 Professional Plus for Windows or Office 2019 Home and Business for Mac. The Home Use Program (HUP) is part of the Software Assurance package for Volume Licence customers. Employees
Microsoft Office for Windows is gradually changing the software name to Office 365 . It’s being done slowly, almost by stealth but it’s happening. Keen eyed readers have noticed a gradual change on the Microsoft web site and software. We first mentioned it back in August 2018 but the software
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
Microsoft includes a OneNote logo in a lot of Office 2019 promotion but that’s a stretch because there’s no ‘OneNote 2019’ included. Down in the fine print: “OneNote for Windows 10”. That’s the OneNote app which is available to all. OneNote desktop has already been dropped from the Office lineup.
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
Office 2019, the new non-cloud version of Office for Windows and Mac, is now available to volume licence and commercial customers. This is the ‘cloud free’ or, as Microsoft call it the ‘on-premises’ version of Office desktop. It has no cloud related features and is ‘feature fixed’ with no future
Officially, Office 2019 will be sold to consumers ‘in a few weeks’ but a leak gives us the probable release date, bundles and prices. Two Office 2019 Bundles Office 2019 will be sold to consumers in two packages: Home and Student or Home and Business. That’s much the same as
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
The upcoming release of Office 2019 for Windows or Mac has some Office 365 customers wondering when they’ll be able to get Office 2019. That’s easy: Office 365 customers already have Office 2019 and a lot more! Office 2019 for Windows or Mac is a separate version of Office from
Microsoft has announced some truly important improvements in what you get with Office 365 Home, Personal and University plans. The Home plan will be available for six family members instead of five. How Microsoft calculates use of Office software is changing and for the better. All these changes apply from
If you get an error message when trying to activate Microsoft Office, settle in for a difficult time. Microsoft doesn’t make activation easy to understand, let alone fix activation problems. Office activation is where newly installed Office software is authorized by Microsoft’s servers. Without activation the software only has very
When you buy Microsoft Office there’s no CD or DVD with the software to install. The vital thing you’re getting is the Product Key. The Product Key is that the 25 character code which unlocks or activates the software. This applies to both Office 365 ‘subscriptions’ or single-purchase Microsoft Office packages.
After the report of buying illegal Microsoft Office via Amazon (and Amazon’s initially poor response) here’s what to do if you’ve bought an illegal, pirated or at least non-working Office Product Key. Credit Card as separate transaction Whenever possible, pay by credit card. The MS Office purchase should be a
After our recent Excel worksheet for visitors to Europe we were asked for a similar one to help people stay onside with the UK Statutory Residence Test (SRT). This is a test to decide if someone is a UK resident for tax purposes. Depending on the situation, a person can
Almost unnoticed among the August 2018 updates are some new options for linking online videos into PowerPoint 2016 and PowerPoint 2013 presentations to Vimeo and LinkedIn as well as YouTube. Until now, only YouTube videos were supported. Now it’s now possible to link to videos from Vimeo LinkedIn SlideShare YouTube
