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 7: Date Driven Workbooks and Concatenation Logo cgma

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

A common strategy to improve efficiency is to delegate manual tasks to Excel.

This implies that accountants are seeking to convert manual input cells into formula cells.

When you realize that Excel can operate on, and return, date and text values, the opportunity for efficiency greatly expands.

This webcast covers key date and text functions and demonstrates how to improve the utility of the conditional summing function by using comparison operators.

Topics discussed:

  • The EOMONTH function
  • The MONTH and YEAR functions
  • The CONCATENATE function
  • SUMIFS

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