December 9, 2025


Webcast Replay


2 CPE

Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation

December 9, 2025
Webcast Replay
2 CPE

Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation

Learning Objectives

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

Major Topics

  • EOMONTH
  • MONTH and YEAR
  • DATE
  • CONCAT basics
  • SUMIFS with CONCAT

CPE Credits Available

2 CPE
2
Specialized Knowledge

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

Working knowledge of Excel

Advanced Preparation

None

Intended Audience

Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel

Provider

AICPA

Register For This Event

  • MACPA Member

    $ 125 125
    Join
  • MACPA Non-Member

    $ 149 149
    Your Price

Please login to register.