Posted on 20 November 2009
Slicer
What is a Slicer? One can think of a slicer as an extension of a
pivot table which makes the job of filtering the pivot table data easier. One shortcoming that pivot tables earlier had was that you could not control them remotely. Short of VBA, you could do things with pivot tables only when you had one in front of you. A slicer on the other hand acts as a 'remote control' for the pivot table. You can ...
Continue Reading
Posted on 18 November 2009
Excel 2010 beta is out today. For those who read my review of Excel 2007, I mentioned that the chances of my being able to try out
Excel 2010 anytime soon weren’t very high. Excel 2010, I thought at that time, and considering how Excel 2007 turned out, would simply be too big a resource hog to work with the hardware that my pc runs on. In that case I would have to give my faithful old pc ...
Continue Reading