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 6: List Comparisons and Indenting Logo cgma

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

This video opens with how to use Excel's lookup functions to perform list comparisons, and how to perform multicolumn list comparisons without first combining several columns into a single lookup column.

It discusses how a minor detail like indention can produce major efficiency gains.

The webcast concludes by comparing traditional lookup functions to Excel's multiple condition summing function.

Topics discussed:

  • The ISERROR function
  • COUNTIFS
  • SUMIFS
  • The Increase Indent command

Who should take this course?

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

Comments/Reflections