Microsoft gives out less information about Office bug fixes and patches
Microsoft has never been great about documenting patches and bug fixes but this month they have sunk to a new low. Maybe it’s a delayed April Fool’s prank with Microsoft ‘taking the Mickey‘ or treating Office customers with contempt? Sustained Engineering isn’t sustained Maintaining Office software is the thankless job of the Office Sustained Engineering […]
Google Drive plug for Office ending soon
The current Google Drive plug-in for Microsoft Office will stop working near the end of June. There’s an improved update already available for some customers and an alternative for the rest. If you’re using the Google Drive plug-in, you’ll start seeing a warning about the plugins death on 26 June 2019. Source: Google There are […]
New Japanese Imperial Era changes in Excel and Office
An update for Excel users on the upcoming new Imperial Era in Japan and how to type the Reiwa era name in Office documents The Japanese government has now announced the new Era name that will coincide with new Emperor. From 1 May 2019 we’ll be in the 令和or Reiwa era. This might not seem […]
Amazing Excel uses in Japan
In Japan there are two amazing uses of Excel. Excel used for displaying train timetables and to make beautiful works of art. The Michelangelo of Excel Tatsuo Horiuchi has become the Michelangelo of Excel. On retirement he wanted to turn to art but didn’t want the expense of paint, brushes etc. He turned to his […]
Who is using which MS Office? Office Watch survey results
Thanks to everyone who tried out Microsoft Forms by filling out our example survey. Here are the results. Our form was mainly an example of what’s possible in Microsoft Forms as part of Microsoft Forms – a quick look and sample We took the opportunity to get a better idea of what Office software our […]
Make automatic Excel worksheet list or table of contents
Continuing our look at Excel tab/worksheet listing here’s a fully automated alternative with more control and filtering. See Make Excel tabs list in a worksheet Automatic worksheet/tabs list in Excel Fit more tabs across an Excel workbook There are many VBA code samples on the Internet, we’ve taken one we like and added some extras based […]
How accurate is Pi in Excel and is it enough?
Does Excel have enough significant digits for Pi in the inbuilt Pi() function? Modern computing can calculate Pi to 3.14 trillion digits which is a good trick but even extreme situations only needs Pi to 15 significant digits. What’s extreme? How about interplanetary travel? JPL/NASA calculate the paths of probes to Mercury, Mars, Jupiter and […]
Convert photo to worksheet with new Excel feature
Excel for Android has a new trick, converting photos of tables or other documents into worksheets. As usual, some conditions and limitations apply to Insert Data from Picture that are overlooked in the usual hype. The idea is simple, take a photo of a table or grid in a document then Excel will convert it […]
New Office icons start appearing … yawn
Updated Microsoft Office 365 icons have started appearing in the preview ‘fast track’ Office 365 for Windows and we could not be more excited. No … not really. When it comes to changed Office icons; if we were more apathetic, we’d be in a coma. Office 365 icons for Word, Outlook, Excel and PowerPoint on […]
Make Excel tabs list in a worksheet
Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line. See Fit more tabs across an Excel workbook for some suggestions to squeezing more across the single line available. Those suggestions work to make a bit more space available […]
Microsoft Forms – a quick look and sample
Microsoft Forms is the latest cloud service to join the Office 365 stable. It’s still a Preview service, not full formed, but it’s working and interesting. We decided to take a look and give you a sample Form to try. Forms is a way to make online questionnaires, quizzes or surveys then add the data […]
Microsoft Forms live example
Wanna jump in and see a Microsoft Forms in action? We’ve made a sample Microsoft Form one for all our Office Watch readers to try. Below is the embeded version (using an <iFrame) or click here to see it on a separate page. Our simple form serves three purposes. The first two questions are serious. […]
Color Font support in Microsoft Office – the story so far
Color fonts are coming to Microsoft Office and Windows but progress is slow and patchy. Here’s a quick summary of color fonts and the occasional, erratic support in Outlook, Word and other Office programs. What are color fonts Since the beginning of Mac and Windows we’ve had single color fonts. Usually black but can be […]
Big savings with the new Office Home Use Program – 2019 style
The Microsoft Office Home Use Program (HUP) is a great way to save on Office 365 or Office 2019 for employees of many companies, organizations, governments and even some military personnel. Here’s details on the savings possible with the recent changes to the HUP. What’s changed? The Home Use Program (HUP) is changing to the […]
Home Use Program for Microsoft Office 365 – who can get it and how?
Here’s who can qualify for cheaper Office 365 Home or Personal under the revised Home Use Program and how to get the lower prices. Employer qualification Your employer must have a Microsoft Office Volume Licence agreement with Software Assurance Maintenance (SAM). If Office is widespread in your organization it’s likely they have a volume licence, […]
You’d better hurry if you want discounted Office 2019 for $15
The current Home Use Program with Office 2019 sold for a mere $15 is about to end. If you want the perpetual licence Office 2019 for Windows or Mac, you’d better hurry. The full impact of the changed Office Home Use Program (HUP) is becoming clear. We’ve already noted that Office 365 subscriptions are becoming […]
