Excel Power User Module 5: Date and Text Functions ON DEMAND
Available Until
Your Desk
2.0 Credits
Member Price $69.00
Non-Member Price $89.00
Overview
Explore functions that operate on-and return-date values and text strings.
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.
Prerequisites
None.
Designed For
Accounting professionals who use Excel for Windows.
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.
Preparation
None.
Notice
None.
Non-Member Price $89.00
Member Price $69.00