Excel Power User Module 5: Date and Text Functions | EPU5OD19

Product Code :
EPU5OD19
Format :
On-demand
Level :
Overview
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Prerequisite :
Excel Power User Modules 4 or knowledge of the topics covered.
Credits :
2.00 CPE
Description :
Explore functions that operate on—and return—date values and text strings. You'll continue to integrate these features as we proceed throughout the series.

This is part 5 of a 10 part series
Objectives :
  • Identify which Excel function 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.
Major Topics :
  • 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
Advanced Prep :
None.
About the Author :
Lenning Jeff S - Jeff S Lenning is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. He specializes in providing computer consulting services to CPA firms and their clients.