Webinar

K2's Excel PivotTables for Accountants - Part I

  • Tuesday, December 19, 2017

    1:00pm – 5:00pm
  • 4
    CREDITS
    Accounting, Computer Software and Applications

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 webinar will begin with basic PivotTables and progress to advanced PivotTable topics.

Objectives

Upon completing this course, you should be able to:

  • Identify and define the six main elements of a PivotTable report
  • Create PivotTables that summarize large volumes of data
  • Describe how to import the data from an accounting system and prepare the data to be used in the PivotTable
  • Create PivotTables from Multiple Consolidation Ranges

Highlights

  • Drag-and-drop pivoting, group and ungrouping, and drilling down to underlying details
  • Creating PivotTables from multiple ranges
  • Linking PivotTables to external database and financial accounting systems
  • Additional Information

    Designed For

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

    Vendor

    K2 Enterprises

    Advanced Preparation

    None

    Prerequisite

    Fundamental knowledge of Microsoft Excel

    Field of Study

    Accounting, Computer Software and Applications

    Course Number

    1780412

    Level of Knowledge

    Intermediate

    Add to Cart

    View All Courses