Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
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 […]
Insert a Compass 🧭 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Compass 🧭 uses Segoe UI Emoji In Windows, the Compass 🧭 symbol is in the font: Segoe UI Emoji. Depending on the app and use, it’ll appear in color or black. The symbol can […]
There’s a way to quickly change the language setting for a multi-lingual Microsoft Word document, by adding a language selector to the Quick Access Toolbar (QAT) like this. Use this as a pull-down list to change the language setting in parts of a document. The problem is the fixed width of the toolbar item, which […]
