Amazon UK is offering Microsoft 365 Personal at about £30 less than the usual price for both new and renewing customers. There are a few peculiarities about the offer, we’ll explain those below but the basics are: Microsoft 365 Personal (one user) New or renew/extend existing plan Regular price £59.99
Microsoft has released a preview anti-virus and security apps for Apple iPhone / iPad, Android plus Windows and Xbox called, confusingly, Defender. Trial apps are available for personal use now but in future you’ll need a Microsoft 365 Personal or Family plan. Defender was the name of Windows protection parts
The Outlook mobile app from Microsoft is ending its support for older versions of the Android operating system. Office Watch explains who is affected, how and when. All these changes apply to devices with Android 7.1 and previous. That’s a quite elderly version of Android (by tech standards). The current
Jon has found a clever way to show words (singular, plural or zero) with many numbers in Excel using conditional formatting. We already shown you several ways to put singular or plural words against numbers in Excel – like 1 cookie or 3 cookies. At the end we noted how
Excel 365 has a way to grab information about movies dropped directly into worksheets. Get info about films, cast, director, rating, budget, box office returns and a lot more with the Linked Data Types. Our ebook Real Time Excel goes into detail about Linked Data Types as well as more
Excel 365’s Linked Data Types have gone beyond the original Stocks and Geography feeds. Now there are more Linked Data Types to pull more public information into Excel 365 workbooks about diverse topics as Anatomy, Chemistry, Plants, Movies and more. It’s a massive extension of the existing Stock and Geography
There’s a quick way to clone or duplicate an existing file in Windows 11 so you can make a new, similar document. Quite often a new document is based on an existing one, for example a fresh invoice for the same things each month. Or a proposal to a new
Why are the numbers on the numeric keypad are different from the number keys on the top row of the keyboard? How to use either set of number buttons in Microsoft Word. “I don’t understand why pressing a number on the main keyboard is different from the number pad (assuming
“I’m confused. In Outlook there are two choices for a UK/London time zone. UTC or London. Both are zero meridian (+00:00). What’s the difference and why isn’t an entry for GMT?” Oscar R, Missouri. The quick answer is to always choose the time zone entry that matches the city or
Sensing a big opportunity to poach Google customers, Microsoft is offering a 60% discount starting deal to unhappy G Suite customers. Here’s the details and inevitable conditions. Google has angered many G Suite customers with their plan to ‘upgrade’ free plan customers to a paid account. Microsoft has moved quickly
Email Read Receipts sound great but don’t often work these days. Articles like “How to tell if someone opened and read your email” aren’t telling the whole story. Here’s the reality behind the Outlook ‘Read Receipt’ feature and how it works across the Internet. The idea is to send an email
There are limited options for entering the current date and time into PowerPoint slides, notes and handouts. PowerPoint doesn’t have field codes like in Word, so Microsoft seems to have shoehorned in some field like features. Insert Date and Time in slide On the Insert Tab, right side there’s an
The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format
There are four different ways to change an Office icon or SVG graphic in Microsoft 365, Office 2019 or Office 2021. The two official SVG edit methods in Microsoft Office with their in-built limitations or some choices before inserting into Word, Excel, PowerPoint or Outlook. Within Office Limited SVG/Icon changes are
Some simple changes to SVG graphics can bypass some of the more annoying limits of SVG support in Word, Excel and PowerPoint for Office 2019/365. Here’s a simple SVG with three parts: the circle <circle> the rectangle <path id=”bar” …> letters are defined in other <path … > and <use
What’s the difference between aligning to a page and align margin in Word documents? Quite often, there’s no practical difference between ‘Align Page’ and ‘Align Margin’ in Word. These options appear when positioning an object on a page and other places. Centering an object has to be done compared to
The latest patch for Microsoft 365 has a serious bug that’s stopping Access from opening many local database files. Here’s what’s happening and two ways to fix it. There’s been no official acknowledgement from Microsoft of the bug or workaround but there are online reports from affected users. Some of
How to show original text and a translation side by side in Word. The recent versions of Word have had an in-built translation feature that, like so many things in Microsoft Office, doesn’t quite go far enough. The basics are simple enough. On the Review tab there’s a Translate button.
How can you change the default program for .RTF documents away from Word and make it stick? We’ve talked about the virus security risk of Rich Text Format .RTF files which even Microsoft has, at times, suggested blocking. Despite that, .RTF files are associated to Word during the Office installation.
There are two ways to make a text box transparent in Office; Word, Excel or PowerPoint. There’s a quick option and other that gives you some more control. The Word, Excel or PowerPoint ‘Text Box’ feature is presented as a way to have ‘pull quotes’ or sidebar text in your
With an Microsoft 365 plan, Family or Personal, how many tablet and smartphone devices can you install Office Mobile? The rules have changed over time, so confusion is understandable. Some emails to our Feedback page plus people we’ve met shows some confusion about how many tablets/smartphones you can load up
What is an RTF document, is it safe, how to use in Microsoft Word and why is it still being used? “I’m looking for a job and many employers are asking for my resume in RTF format. How do I do that and why can’t I just use a Word
