PivotTables are the most powerful feature of Excel, yet few accountants use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from the instructor, you will be ready to begin using PivotTables to accomplish routine analysis and reporting. This session will begin with basic PivotTables and progress to advanced PivotTable topics.

Specific topics covered in this session will include drag-and-drop pivoting, grouping and ungrouping, creating calculated items and fields, and drilling down to underlying details. PivotTables consolidated from multiple ranges and PivotTables dynamically linked to external databases and financial accounting systems will be covered.

Comments from prior course participants:

"This was a great course. I came away with a lot of useful info to make my job easier." L.F., CPA NE

"Time well spent – very valuable & time saving information." S.M., CPA AL

For more information on this course, please visit http://www.k2e.com/pt1-4.