On-Demand
Excel Power User Module 5: Date and Text Functions
CPE: 2
Member
$69.00
Nonmember
$89.00
Members, log in to access your discount.
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
Product Code
EPU5OD19
Credit Type
CPE: 2CPE-Technical: 2Format
Online Self-Study
Intended Audience
Accounting professionals who use Excel for Windows.
NASBA Field of Study
Computer Software & Applications
Level of Difficulty
Overview
Prerequisites
Excel Power User Modules 4 or knowledge of the topics covered.
Advance Preparation
None.
Learning Objectives
Major Subjects
- 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