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
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
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
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
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,
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
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
For the first time in a decade, Microsoft is making substantial changes to the Office ribbon interface. But not to worry, the changes don’t appear to be enough to put anyone off Word, Excel, PowerPoint or Outlook. The existing ribbon is retained, that’s an important point that’s not emphasized enough
Modern Excel can grab information from multiple files in a single folder. Just open the worksheet, refresh the query and it’s up to date! This article is a condensed version of just one chapter in Real Time Excel – the new 2nd edition has a lot more detail and example
As usual, Microsoft has released non-security updates and bug fixes for Office 2016 and Office 2013 on the first Tuesday of the month. A few caught our eye: Late last year, Microsoft was caught out leaving a horribly vulnerable Equation Editor in Office for 17 years. A new patch restores
Two Indian banks clamped down use of unlicensed Microsoft Office, leaving staff to use calculators or open-source alternative spreadsheets. Mid-Day.com reported that Bank of India and Saraswat Bank had some licenses for Microsoft Office but not enough for all the computers the bank had allocated to staff. Branches were instructed
Both Windows and Office send an astonishing amount of data from your computer to Microsoft. Here’s how to see what’s being sent. The Diagnostic Data Viewer shows, as it happens, what your computer is sending to Microsoft. The tool does NOT give you the choice to not send your private
An overdue and very welcome addition to OneDrive for Office 365 customers is password protected sharing links. Until now, you could send a link to a OneDrive stored file or folder but there was no control over who used that link. If the link ‘escaped’ to other people, they could
The North Carolina State Bar is proposing attorneys get an hour of computer training, including Microsoft Office, as part of their annual Continuing Legal Education (CLE). Only one US State, Florida, has a computer component of their current CLE. Amazing! In Florida, lawyers have to get three hours of technical
Excel has three PercentRank() functions to give you the percent ranking of a value in a list of numbers. It’s different from the Excel rankings we’ve discussed before, because this is a percentage or percentile ranking Let’s start with a simple example. There’s a list of values from 1 to
Another month, another set of security bugs in Microsoft Office. It’s Microsoft’s version of Groundhog Day. The May 2018 dump of patches involves 102 updates covering: Office versions from Office 2010 to the latest Office 2016 Core Office features Word Excel Sharepoint and Project server. Most people don’t need to
In case you thought making a Word or Excel virus attack was hard, think again. The ‘Rubella Macro Builder’ will sell you a DIY kit with updates for just US$40 a month. The virus maker will take you through the steps to make a hacked Word or Excel document that
It’s easy to get mixed up between two seemingly similar Excel functions – Vlookup() and Choose() . Here’s how to, er, choose between the two. Choose( index_num, value1, [value2], [value3].. ) lets you select one item from a list within the function. For example: Choose(2, “High”, “Middle”, “Low”) will return
In the UK there’s been a lot of laughs and some red faces about a money raising letter ‘signed’ by the Conservative Prime Minister to a ” Mr Youmustbe F*ckingjoking ” and sent to a pensioner. It’s easy to laugh but anyone who has done large mailings knows that it’s
Will R. an Office-Watch.com reminded us of a trap when dealing with .doc and .docx files. “I opened a command prompt and did a del *.doc. Imagine my surprise when it deleted both .doc and .docx files (I have backups). ” Firstly, a teacher’s gold star plus wise owl stamp to Will
