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.
The Dictation controls in Word 365 for Windows are moving to another place and getting a lot smaller. The new Dictation toolbar appears on top-right of the document, often just below the Dictate button. That’s the same location as the Read Aloud toolbar. Dictate – when dictation is ‘listening’ the button is a solid blue […]
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s trap when typing in dates […]
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to an Excel value. It’s a […]
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve left out and how to […]
It’s now possible to make an Excel PivotTable directly from PowerBI data in Excel 365 for Windows and Excel on the web. Microsoft PowerBI is a cloud-based data accumulation then reporting and visualization (dashboards etc). BI stands for “Business Intelligence”. PowerBI is a separately licensed product for businesses so it’s only available if your organization […]
