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 […]
What can you do when Outlook won’t connect to a new mailbox no matter what you try? Long time Office Watch reader, Phil, found himself with an especially stubborn Outlook which would not connect to his new mailbox. He’s changed Office 365 mail servers so had to reconnect Outlook to the new mailboxes for him […]
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 […]
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 […]
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 […]
