Skip to main content
SQ Taxation Committee Discussion Forum | M2030820
August 5, 2020
San Joaquin Valley
Add to Cart
Redirecting to cart, please wait...
has been added to the cart.
items(s) in your cart.
My Activities (NEW)
My CPE Tracker
My Certificate of Completion
My Communication Preferences
My Transactions / Discounts
My Membership / Open Invoices
Who We Are
CPA Career Center
Exclusive Members Savings
Committees & Sections
New! Find CPE
Core Staff Training
Contact Your Legislators
Advocating for CPAs
California CPA Magazine
Peer Review: Firm Resources
Peer Review Reports
Peer Review: Reviewer Resources
CPA Job Board
Search for Ads
Place an Ad or Résumé
Find a CPA
Ask a CPA
CPA License Lookup
Governmental Accounting White Papers
Events and Programs
Excel Power User Module 5: Date and Text Functions | EPU5OD19
Add To Cart
Product Code :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Excel Power User Modules 4
or knowledge of the topics covered.
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
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
Improve SUMIFS with CONCATENATE
Advanced Prep :
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.
Powered by Azure Servers