Excel Power User Module 5: Date and Text Functions Webinar

Sep 28
11:00 - 1:00 p.m.

Online

2-Other
CPE Credits

  • Identify Excel functions that can be used to return the last day of the month.
  • Recall the arguments of the DATE function.
  • Determine an Excel function that returns the year of the date.

Highlights
  • Determine the last day of the month with EOMONTH.
  • Date parts: MONTH and YEAR.
  • Build your own date with DATE.
  • Concatenation basics.
  • Improve SUMIFS with CONCATENATE.

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. 4182985B

Level: Update

Prerequisites:

Excel Power User Modules 1-4 or knowledge of the topics covered.

Notes

This webinar is hosted by PICPA's partner, The California Society of CPAs. After registering, you will receive an email from the California Society with the log-in information.

Speaker(s)

Jeff Lenning

California Society of CPAs