Microsoft has announced that Office desktop apps (Windows and Mac) can now co-author encrypted documents. Until now, encrypted docs could only have shared editing using Office on the web. What’s in the fine print is often overlooked, this feature isn’t for everyone. The announcement in bold from Microsoft has got all the media attention, as […]
There are many API’s available on the Internet that can provide great and timely data in ways that Excel can understand, here’s how you can do it. We’ve recently received emails asking how to use Excel to import data from specific API’s. Always we have the same answers because most API’s work in similar ways […]
Here’s what you need to know about the two official international document formats, Microsoft’s OpenXML (.docx .xlsx etc) and Open Document Format (.odt .ods etc) both supported in Microsoft Office and most other office suite software. Each format has been recognized by international bodies so there are two ‘official’ document standards for Planet Earth. Both […]
Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field List. All these options mean […]
The September 2021 release preview has a lot more than usual new and updated features in Office 365 for Windows. Almost as if Microsoft has been saving them up for a bumper surprise! It’s all in the ‘Current Channel (Preview)’ release v2109 build 14430.20088 that’s out now. This is the last stage before the updates […]
