O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
I often encounter the term "pivot table," yet until recently I had only a vague notion as to what a pivot table is and what it does. Matthew MacDonald, author of "Excel 2010: The Missing Manual," got ...
Excel is the go-to choice for number crunching and spreadsheet creation, but those are the run-of-the-mill functions. There's a host of untapped tools and techniques within the program. In the followi...