Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage. Can’t Sign-in A very common […]
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 […]
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 […]
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables but before that she’ll of […]
