Tagg: Microsoft Excel

Make better Excel workbooks by collaborating with others It has often said that “two heads are better than one” or “many hands make light work”. From my own experience I know that I learn new ideas and concepts more effectively when I am learning with a partner. Some people are better at observing the details […]

Considering the time today’s IT professionals spend staring at Microsoft Excel spreadsheets, one might think we’d all be Excel wizards by now. The truth is that while Excel has a low barrier to entry, to become a true super user takes a lot of time, energy, and dedication. While you may think you’re an above-average […]

There are many occasions when it would be valuable to have two (or or three or possibly more) Excel pivot tables respond to changes in a single slicer filter. This is easy to do when one understands the inner workings of pivot tables. Under normal circumstances if you create several Excel pivot tables each will […]