In this course, students will learn how to use date and text functions. This will allow users to manipulate text and ensure that formulas using dates are properly calculated.


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course aims to help students become more comfortable working with dates and text. Students will learn about many useful Excel date and text functions and when to use them for maximum effect.

  • Accuracy In Working With Date And Text Functions

  • Work with Dates - Learn how to use the TODAY and NOW functions, the NETWORKDAYS function, the DAYS function, the YEARFRAC Function, and the DATEVALUE function.
    Working with Text - Learn how to use the CONCAT function, the TEXTJOIN function, the Text to Columns Wizard, the RIGHT function, the LEFT function, the MID function, the LEN function, and the TRIM function.
    Working with Change Case Functions - Learn how to use the UPPER, LOWER, and PROPER functions.


This course is intended for users who have some experience using Excel functions. It assumes the user is already comfortable with navigating and selecting data in Excel. Anyone who works with dates, text, or data entry in Excel will benefit from this course.




There are no stated prerequisites for this course. Please check with your representative for details.


Length: 0.0 days (2 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.