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

Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check Logo cgma

  Jeff Lenning, CPA, CITP |   £79.00 - 99.00 |   2018 |   02:00 h |   CGMA Store

This video begins by discussing dynamic headers and their use in automating reporting workbooks.

It reviews how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports.

It explores how mapping tables can lead to major efficiency gains.

Finally, it covers data validation in digital reports and reviews a critical worksheet that belongs in just about every recurring-use workbook: ErrorCk.

Topics discussed:

  • Headers
  • Horizontal reports
  • Mapping tables
  • Data validation
  • ErrorCk

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