A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

Most of us would use VLOOKUP() to add a column to the original data set. It’s what we know, and it works well unless you have thousands of records to analyze. But, even if it slows things down ...

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? A: The October 2011 JofA Technology Q&A column (page 76) included an item titled “Make a Difference With PivotTables,” which ...