When I’m working with an Excel pivot table*, I sometimes find that even after I’ve deleted something, like a typo, from my starting data, the item I deleted will still appear in my pivot table filters and slicers (slicers are a great feature new to 2010). Specifically, this has happened when I created a pivot table based on data [...]
Tag archives for pivot tables
Summarize Data Quickly with Pivot Tables
Pivot tables are a great Excel tool that help you quickly summarize data and quickly change how your data is summarized. The pivot tables class I teach is consistently my most popular class. Here’s an introduction to pivot tables video I made for Excel 2007: Video and transcript located at: http://www.mccombs.utexas.edu/tech/training/tutorials/Excel/files/PivotTables/PivotTables.htm. Want to learn more about [...]
category: Excel, Useful Web Sites
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
