Yet again, a bad deal for Office 365 is being offered on Amazon and it’s even worse than last time. In March there was an offer on Amazon for Office 365 Home (retail $99.99) plus an Amazon gift card $50 for a total of $149 – a ‘massive’ saving of 99 cents. It’s on again […]
There are several ways for an Excel table to be transposed (rows and columns) but none of the online suggestions work very well with tables. We’ve found a solution which transposes one table into a ‘swapped’ table i.e headers become column A and column A becomes the headers. Along the way we’ll explain a clever […]
You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on this method; two colors, […]
The Office apps for Android are getting some interesting new features. Excel for Android has better sort and filtering. Galaxy Watch can now link to the Outlook app. At first for preview ‘Insiders’ and later to the publicly available Word, Excel, PowerPoint and Outlook apps. Here’s Microsoft announcement of the new features with their images: […]
Microsoft is ending their Delve blog service starting later this month. It’s being done with little notice and in a very round-about way. Delve blogs aren’t widely used and their end has been anticipated by some network admins. Even so, Microsoft has badly handled the announcement. Instead of a Microsoft blog post or some official […]
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you can’t ‘Open Excel or any […]
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 known as ‘Insights’ (a more […]
There are two different year-round Microsoft Office 365 discount offers available to US and Canadian military in all branches. Office-Watch.com talked about these Military Appreciation offers before, going back more than a decade. There are TWO different military related discounts – the Military Appreciation Edition and the Home Use Program. Military Appreciation Edition The MAE […]
OneDrive Personal Vault is limited to 3 files for anyone with a free OneDrive account with a 100GB quota. It’s very easy to bypass that limitation and store as many files as you like. See OneDrive Personal Vault, deep inside and tricks There are several ways to store multiple files inside a single files. Use one […]
OneDrive Personal Vault is now available to Office 365 users across the globe. Here’s how to setup, use it and work with Office documents in the Vault folder. OneDrive Personal Vault is a more secure extension to standard OneDrive. It’s now available to all Office 365 customers after being gradually rolled out across the globe […]
‘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 deal or not. The retail […]
‘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 to whether a price for […]
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 NY’ logo was made to […]
Once you have the basic setup for the I ♥ or I Love … sign, the fun begins. Making your own variations for a Word document or PowerPoint presentation. Start by making your own I ♥ or I Love … sign based on the original I Love NY logo. Font variations Simply changing the font […]
It’s pretty easy to make a similar I ♥ or I Love logo, in Microsoft Word or PowerPoint. It’s even a little easier for Mac users. Check out Making the original I Love NY sign to see how the original logo is put together. The logo looks simple but it’s not. We’ll show you the […]
Here’s the design details of how the famous I ♥ NY / I Love NY logo was made. The font, colors, symbols and how they come together to make an iconic sign imitated all over the world. The logo was created by Milton Glasner in the back of a taxi but these days all you […]
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 early 2020. They’ve not said […]
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 ‘patch of a patch of […]
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 to be a forwarded message […]
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 become part of the default […]
