Office 2021 is the current ‘perpetual licence’ or non-subscription version of Microsoft Office for consumers and small businesses, here’s details of what’s new, prices, shorter support time and why Microsoft doesn’t want to sell Office 2021 at all! It’s what Microsoft calls a ‘perpetual licence’ version. A single payment for ongoing use of the software […]
Microsoft has quietly announced that features are being withdrawn from the standard Teams plans and will only be in the higher-priced ‘Teams Premium” plan. The change is controversial because it’s a late change to the features in Teams Premium by taking away existing options from other paying customers. Microsoft knows customers won’t be happy so […]
Excel 365 for Windows is getting more functions only for Data Models with PowerPivot. Data Analysis Expression (DAX) functions are useful for exploring large datasets. There are a few UTC time/date functions we’d like to see made available to all Excel users. A full list of the new DAX functions are below, two of those […]
Finding out the current UTC / GMT time in Excel is possible with a little VBA magic. We’ve included a full working example. Excel has two functions to give you the current date TODAY() or current date and time NOW() but it’s the local time as set on your computer. Often the worksheet needs either […]
Finding out the computers local time zone offset in Excel is possible with a little VBA magic. We’ve included a full working example of how to get the ‘nn hours from GMT’ setting from Windows into Excel. The need for the current UTC/GMT time and offset is becoming more important as Excel improves its external […]
