How well do you know PivotTables?


Q: I was recently asked by a large client if I considered myself an Excel PivotTable expert, and I wasn’t sure how to respond. I have used PivotTables extensively, but by definition, it is difficult for anyone to know what they don’t know—if that comment makes sense. Is there some way for me to self-assess my PivotTable skills?

A: I am not aware of any official PivotTable accreditations, but just for you, I created the questionnaire in Exhibit 1 to help assess your knowledge of Excel PivotTables.

Scoring. If you answered “Yes” to 15 or more questions, I would label you a PivotTable Expert; 10 to 14 “Yes” responses would qualify you as an Advanced PivotTable User; and five to nine “Yes” responses would position you as an Intermediate PivotTable User. Please keep in mind that this test is not official; it’s just my opinion.

J. Carlton Collins ( ) is a technology consultant, CPE instructor, and a JofA contributing editor.

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2013, 2010, and 2007 versions, unless otherwise specified.

Submit a question
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to We regret being unable to individually answer all submitted questions.


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Tips for first-year auditors

For a new auditor, the first busy season can be an exciting time and a fantastic opportunity for professional growth. Here are suggestions for new auditors and those who nurture their development.