Excel PivotTables - Part I

  • Monday, February 11, 2019

    9:00am – 1:00pm
  • 4
    Accounting, Computer Software and Applications

PivotTables are the most powerful feature of Excel, yet few business professionals 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 your instructor, you will be ready to take advantage of PivotTables to perform routine data analysis and reporting more quickly and more effectively than ever. In this session, you will learn the nuts-and-bolts of PivotTables, setting the stage for greater productivity than perhaps you can even imagine!


*Identify and define the six main elements of a PivotTable report
*Create PivotTables that summarize large volumes of data
*Apply specific formatting techniques to PivotTables
*Create a PivotTable that links data from an external data source, such as an accounting database
*Consolidate multiple ranges of data quickly and easily using PivotTables


*Computer Software & Applications

Additional Information

Designed For

Accounting, financial, and other business professionals who want to use the power of Excel PivotTables to analyze and summarize data



Advanced Preparation



Fundamental knowledge of Microsoft Excel

Field of Study

Accounting, Computer Software and Applications

Course Number


Level of Knowledge


Add to Cart

View All Courses