Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation (2 hours)

Overview

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

Prerequisites

working knowledge of Excel

Objectives

• Determine the last day of the month with the EOMONTH function.
• Use the MONTH and YEAR functions.
• Build your own date with DATE function.
• Use the CONCATENATE function.
• Improve the use of SUMIFS with CONCATENATE.

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!