Microsoft® Excel How to: Date and Text Functions

Excel does more than numbers. Discover date and text functions.

As the pandemic persists and staffing shortages abound, you need to do more work and get it done faster. Excel is the ideal tool to save you time. It can help with far more than calculating numbers. You can use a spreadsheet to manipulate, parse, and analyze dates and text.

You often have questions that Excel can answer much faster than you can if you know how to ask, like:

• How many days until the end of the year?
• Who is the sales representative responsible for order “2021-RP-19812X”?
• How many characters are in this sentence?
• What is the first name of “Sanchez, Adriana”?
• How long did it take your team to complete each action item?

Mastering date and text functions will allow you to make Excel do all the difficult work for you. Your days of counting days and retyping text are over.

In only 90 minutes, you can learn the useful date and text features, including the following:

• Absolute vs. relative references (continued)
• Date functions (with commonly used examples)
• Text functions
• How to lock your cells to protect functions

We are offering the Electronic Spreadsheet Fundamentals Certification here.