This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Technical

Streamlined Excel Reporting Series Session 3: PivotTable Wrap-Up and Web Data Logo cgma

  Jeff Lenning, CPA, CITP |   £79.00 - 99.00 |   2018 |   01:50 h |   CGMA Store

This video finishes the PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering filtering options, including slicers.

It also explores the lookup function designed specifically to retrieve values from PivotTables. It concludes with data acquisition techniques.

You’ll practice retrieving data from the largest external data source of all- the Internet.

Topics discussed:

  • PivotTable filters
  • Lookup functions for PivotTables
  • Data acquisition techniques

Who should take this course?

  • Accounting and finance professionals
Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • Management accounting: Technical: Accounting information systems: Information systems environment, Intermediate

Comments/Reflections