Minnesota Society of Certified Public Accountants

1650 West 82nd Street, Ste 600
Bloomington MN 55431
Ph: 952-831-2707 Fax: 952-831-7875
www.mncpa.org

Show Menu

We're upgrading our system Tuesday, April 1-Wednesday, April 2. Certain features may be unavailable or unreliable.
If you encounter issues, please try again Thursday, April 3, or contact MNCPA customer service.

Help | Pay an Invoice | My Account | CPE Log | Log in

Webinar

Excel: Working with Text, Date and Time Functions and Formulas

Tuesday, April 1, 2025
3-5 p.m. Central
2 CPE (2 non-technical)

Course code: 25WX-0003
View pricing

Online registration is not available due to server maintenance. Please call 952-831-2707 between 7:30 a.m. and 4:30 p.m. Central to register.

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Major subjects

Using Text functions to join and separate text entries
Inserting Text functions to work with imported data
Perform date and time calculations with the Date & Time functions

Learning objectives

Create complex Text functions to separate text entries
Format cells using Text functions
Perform complex data and time calculations

Who should take this program?

All Excel users who want to become Excel formula experts

Pricing

Standard Member Fee	$89.00
Standard Nonmember Fee	$89.00

Our records indicate you are a nonmember. If you register, you will be charged $89.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

Online registration is not available due to server maintenance. Please call 952-831-2707 between 7:30 a.m. and 4:30 p.m. Central to register.