Excel is getting a clever new way to quickly analyse your worksheets and pull out useful ideas or insights to quickly make PivotTables, PivotCharts and Charts. It’s now available in Excel 365 for Windows and Mac, Insiders and will eventually make it to public releases. It’s now called ‘Ideas’, previously
‘Tis the season for savings on Office 2019 so we’ll keep an eye on price discounts on Office 2019 bundles (Home and Student, Home and Business, Professional). What price to pay and what NOT to pay. Below is a guide to whether a price for Office 2019 is a good
‘Tis the Black Friday season for savings on Office 365 so we’ll keep an eye on price discounts on Office 365 Home and Office 365 Personal in the USA, UK and Australia. It’s a great time to save on extending or renewing an Office 365 subscription. Below is a guide
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love
Microsoft is touting Application Guard as a defence against Office 365 macro viruses. What is it and will it truly prevent viruses in Word, Excel or PowerPoint documents? Application Guard is already in the Edge browser and Microsoft has announced that it will be extended into Office 365 sometime in
Oh what a tangled web Microsoft weaves …. a patch for Office has caused another bug in all versions of Access (365, 2019 back to 2010). The bug is the latest in a series of blunders for Office updates. It’ll take until next month for all customers to get a
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
The future of OneNote involves more connections to other services like Teams, Tasks and Todo. New features made possible by a big effort to bring OneNote code back to a single base. OneNote default installed OneNote 2016 for Windows will rejoin the Office 365 suite from early 2020. It will
A wonderfully independent article in the Washington Post reveals a big problem with the sale of fake and pirated products on Amazon. Our articles on fake Microsoft Office products is just a tiny part of a bigger problem. The Washington Post is owned by Jeff Bezos, the head of Amazon
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously at hiding things in Word and Excel, and PowerPoint also allows you to hide things, although the approach is a little different. The most common reason to want to hide
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You
OneNote for Windows has a better future after some reverse-course announcements from Microsoft. OneNote desktop program gets extended life and a promotion. The desktop and app versions merging into a single codebase. We’ll also explain the strange case of two OneNote for Windows. The announcements amount to a 180° reversal
The first sign that OneNote 2016 is back from a slow death is the announcement of the first new feature in well over a year. OneNote 2016 is getting a Dark Mode just like the Mac and Apple apps. OneNote dark mode will be an option in OneNote 2016 for
Buying and using a computer keyboard from Microsoft is very annoying, based on what we’ve heard from Office Watch readers. Choosing a Microsoft keyboard is harder than necessary and finding help, even harder. Microsoft’s keyboard range is especially bad for not properly explaining all the features of the products, apparently
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for
In Wales, all teachers and their students can get Office 365 free, instead of about ₤60, thanks to an initiative of the Welsh government. It’s worth checking what access to the full Office suite your school, college or university kids might have. The Welsh government has arranged this as part
A security vulnerability has been discovered in Excel for Mac. It’s been there for many years and affects Office 365, Office 2019, Office 2016 and Office 2011 for Mac. We have details and suggest a protection you can do yourself. It’s another problem with legacy support for an older Microsoft
It was inevitable that phone scammers should try fooling Office 365 users into giving up their login details. Update: after this scam was publicized, the phishing email turned up in our Office 365 mailbox! Microsoft’s mail filtering let their customers down. Microsoft’s lapse let us show you a real example
The Microsoft Bluetooth Keyboard is one of two new models with dedicated Office key and Emoji key. What’s this new keyboard like … aside from those innovations? We bought a Microsoft Bluetooth Keyboard with our own money and gave it a long hard look. Source: Microsoft Note: this is the
While we were looking for Publisher 2019 on Amazon, we found more obviously illegal sales of Microsoft Office products. We’ve mentioned this before. Blatantly illegal Office licences sold on Amazon by third-parties. Why is this MS Office is illegal? Office 2019 Professional Plus is not sold retail. It’s only sold
There are three little ‘gotchas’ with the Rewrite feature in Word 365 for Windows. One is unprecedented in the history of Microsoft Office. The ‘public’ feature isn’t available to everyone. Rewrite is the new cloud service that suggests alternatives to phrases in a document. The way it’s been released
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control
Two new Microsoft keyboards have an Emoji key. Office-Watch.com has now tried one of these keyboards to see how the new key really works and hardware details. There are various layouts available including US layout. We bought a UK layout keyboard with the Alt Gr key. Firstly, it’s not an
Two new Microsoft keyboards have a dedicated Office key. Office-Watch.com has tested one of these keyboards to see how the new Office key really works. We have a full list of Office key shortcuts plus how it works inside Word, Excel and PowerPoint and geeky hardware info. Hard information about
