Excel Power User Module 5: Date and Text Functions

Overview

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 Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

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

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.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.