Print Page   |   Contact Us   |   Sign In   |   Join
Excel Power User Module 5: Date and Text Functions (4152985A)
View Registrations Tell a Friend About This EventTell a Friend
 

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In this session, we'll explore functions that operate on and return date values and text strings. We'll continue to integrate these features as we proceed throughout the series. Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.

3/11/2016
When: 03/11/2016
12:00 PM - 2:00 PM
Where: Webcast/Webinar
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-834-6634


Online registration is closed.
« Go to Upcoming Event List  

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly.
In this session, we'll explore functions that operate on and return date values and text strings.
We'll continue to integrate these features as we proceed throughout the series.
Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.

  

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.

 

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

 

Designed For:

Accounting professionals who use Excel for Windows.
 

Prerequisite: 

Excel Power User Modules1-4 or knowledge of the topics covered.

Advanced Prep: None

  

Speaker: Jeff S. Lenning, CPA, CITP

Vendor: CalCPA

Field of Study: Info Tech

Level:  Overview

CPE Credit: 2 hours

Acronym: EPU5

 

Registration Fees:

Members: $70

Nonmembers: $94

 

Meet the Speaker:

Jeff Lenning of Click Consulting, Inc., is a CPA and published author.  He has written several articles for the Journal of Accountancy and other publications.  His firm specializes in providing computer consulting services to CPA firms and their clients.

Membership Management Software Powered by YourMembership  ::  Legal