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

21WX-0212: Excel: Working with Text, Date & Time Functions & Formulas (Webinar)

If you have questions about this event, please call us at 952-831-2707.

Wednesday, April 28, 2021
11:00am - 1:00pm Central Time
2 CPE (2 non-technical)

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 objective(s)

  • 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

Fees

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

More program information

Instructor Bryan Smith, CPA, CITP, CISA
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Intermediate
Format Group Internet Based
Sponsor CPA Crossings, LLC
NASBA ID#: 108744
Prerequisites Prereq. None
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date. Learn more

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog

If you have questions about this event, please call us at 952-831-2707.