Timelines are a special form of Excel Slicer for PivotTables, to make filtering dates easier. Timelines are slicers that allows you to filter date fields and only date fields in PivotTables. The feature shows you a series of events grouped by time. Here’s a Timeline filtering a PivotTable to show only results from a single […]
The Australian tax authorities have released some interesting data about the biggest corporate (non) taxpayers in an Excel format. It’s raw data ready for extra calculations, charts and PivotTables. Another example of how publicly available data can be used by anyone to dig into previously obscure areas using Excel tools. The “Corporate Tax Transparency” report […]
Microsoft has released Office apps that work on Chromebooks, the low cost laptops using Google’s Word, Excel, PowerPoint and OneNote apps are now available for most, if not all, Chrome OS users. There seems to be some teething troubles with the Office apps and the Google Play store. Redmond hasn’t exactly shouted about this extension […]
Tamil language has been added to Microsoft’s suite of translation apps and services. There’s about 70 million Tamil speakers mostly across Sri Lanka, India, Singapore and Malaysia. We checked with Office 2016 for Windows, Office 365 and sure enough there was Tamil among the many language choices. Beyond Office The language is also on “Bing […]
Rarely do you choose a single Slicer button. More likely you’ll want to select multiple filters or buttons, here’s the various ways to do that. You can press the filter icon next to Beverages and then select multiple items if you want to see both. Just like other parts of Windows, hold down the Ctrl […]
