It was a small but long awaited addition to Excel for Windows but now it’s disappeared? Why did the Chart option “Show #N/A as an empty cell” go missing? There was a small cheer in the Excel charting community when Microsoft put this extra option in the Chart | Hidden and Empty Cell Settings: ‘Show […]
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just drag a second item down […]
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This time we’ll make a more […]
Who knows how long Outlook has been sending supposedly encrypted emails with a plain text readable version included? Microsoft isn’t telling their customers, presumably hoping we won’t notice. SEC Consult discovered a serious breach in Outlook’s email encryption system. Secure messages were being sent with a plain text readable version included! Ouch. Source: SEC Consult […]
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office color palette regardless of Crayola […]
