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 this tip isn’t necessary any […]
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 in the leaked Microsoft video. […]
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 files ready to use. […]
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 the MT Extra font so […]
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 to uninstall Office from many […]
