Here’s a list of the non-security aka bug fix updates to Office 2016 for Windows, released for July 2018. These updates should come to you automatically via Microsoft Update or you can patch individually from the links provided. Here’s Microsoft’s list with their explanation of each update. Office 2016 Excel
Part of the July 2018 updates to Office is a change to the Segoe UI emoji font but Microsoft is keeping the details a mystery. Segoe UI emoji is a Microsoft Office font which includes many standard Emoji characters though the emoji don’t look the same across different devices or
Just a few non-security or bug fix updates for Office 2013 for Windows and Office 2010 for Windows. These updates should come to you automatically via Microsoft Update or you can patch individually from the links provided. Here’s Microsoft’s list with their explanation of each update. Office 2013 Excel 2013
The latest Office for Android preview has a few additions that might be of interest. We’re talking about build 16.0.10325.20010, the July 2018 insiders preview that’ll later be available to all Office for Android users. Word Count The document word count should appear as you scroll through the document, alongside the
Excel Templates Help Small Businesses to Review Their Finances July 3, 2018 – Press Release The challenges that entrepreneurs often bear when it comes to running their businesses can be substantial. But it is through the Biz Excel Templates website by LifestyleCPA that such entrepreneurs can figure out their numbers
A clever use of Excel is at the end of a paperless class attendance system used by a Filipino teacher. Michael Angelo posted on Facebook how he’s switched to a paperless system for his classes. The same system can be used for classes, one-off events or even to track physical
How to type the degree symbol (Fahrenheit, Celsius, Kelvin, latitude, longitude) into Microsoft Word, Excel or PowerPoint. Degree Symbol codes Decimal: 176 Hex: 00B0 Web: ° ° ° Word The degree symbol ° has an inbuilt shortcut in Word. Ctrl + @ or Ctrl + Shift + 2 followed by
Think you know Excel? A 14 year old high school student from Florida has beaten 350,000 contestants and 147 finalists to be become the 2018 US National Excel Champion. Kevin Dimaculangan from Dunbar High School is now going to the World Championships in Orlando, Florida at the end of July. His win
Another long-standing hackers trick still works with Microsoft’s much hyped Office 365 email security. ZeroFont is a simple way to hide text that might trigger a security alert. Source: GIF animation from Avanan Office 365 has been an increasing target for hackers, especially as more people and organizations sign-up for
A new Office ‘Garage’ option is ‘Student Tools’ an extra ribbon featuring the tools Microsoft thinks are most appropriate for students. It’s only available to students in USA, Australia or New Zealand for Office 365 for Windows or Office 2016 ProPlus. Word Student Tool Garage is where Microsoft tries out
A source of envy for Windows users has been the quick preview feature on Mac computers. That envy has gone now that there’s two apps that add the same feature to Windows 10. Seer and QuickLook both do the same thing and while they are useful, both lack an important
Transform to Web Page is a new Word Online feature which promises more than it delivers. The deliberate implication of ‘Transform to Web Page’ is that you can save the document to web page to be hosted anywhere. It’s actually a link to Microsoft Sway, another online service. You can’t
Office Online is a slimmed down version of Word for Windows or Mac. What’s possible in a browser interface is impressive from a technical point of view but it will never compete with Word for Windows or even Word for Mac. Anyone familiar with Office for Mac or Windows should
Word, Excel, PowerPoint and OneNote are always available for you, even if the main Office for Window/Mac are broken or missing. Office Online is the alternative that you have as a standby when regular Office fails or isn’t available. As long as you have a browser and decent Internet connection,
This article describes several more variations of combo boxes, making them even more useful. Linked Combo Boxes You can use a set of linked combo boxes to filter a list, making it easier to get at the specific item you want to select. As an example, in the sample database
A regular combo box that gives you a choice of an item from a list (usually displaying items from a query or table) is very useful, but sometimes you need something more. This article describes several ways to expand the utility of a combo box. Hard-Coded List Combo Box When
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over
A private April 2018 Gartner report confirms what Office-Watch.com has been saying for years. Microsoft is forcing customers away from perpetual licence/one-off software purchases and into software rental like Office 365. As reported by Gregg Keizer at Computerworld, Microsoft will continue ‘encouraging’ customer to annual fees by limiting access to
While North Korea’s leader, Kim Jong Un, was busy in Singapore, his government hackers were busy with new malware called TypeFrame and delivered by, you guessed it, a Microsoft Word document. Typeframe has eleven different elements bundled with a Word document. As usual, the hackers send the document and try
The ASUS Zenbook Pro series comes with a snazzy touchpad which doubles as an extension toolbar for Microsoft Office. Source: ASUS Instead of a blank touchpad, it’s a small high-res touchscreen that can display icons or even full videos (play Lawrence of Arabia on a tiny, tiny screen!). For Microsoft
The news that Microsoft is adding Javascript support to Excel is important for developers and regular Excel user, but also a security concern. Javascript is a programming language that’s used on many web pages to provide the fast interaction we’re used to. Javascript is able to get data from external
Here’s how to convert the Last Trade time in Excel’s Stock data type into an Excel date/time that’s usable in other parts of Excel. UPDATE: near the end of September 2018, the Last Trade Time date format changed to an Excel serial date. No conversion or text parsing necessary. So
Microsoft has announced that the community support forums for Office 2013 and Office 2010 are ending next month, July 2018. The Community Support Forum are online forums where Microsoft staff and volunteers answer questions from Microsoft customers. From July 2018 Microsoft won’t be responding to queries in these forums: Office
Office 2011 for Mac is just one of many programs that won’t work at all on the upcoming MacOS release ‘Mojave’. That’s not a surprise for anyone who follows Apple’s policy announcements. Many years ago, Apple warned that they’d eventually stop supporting 32-bit programs with 64-bit applications becoming the required