Microsoft® Excel How to: Date and Text Functions

Microsoft® Certified Trainer and Excel expert Jackie Kiadii will show you how to utilize these powerful non-numeric functions to wrangle your data and increase efficiency.

What You'll Learn

  • Absolute vs. relative references (continued)
  • Date functions (with commonly used examples)
  • Text functions
  • How to lock your cells to protect functions
Skip to product information
1 of 1
Live Session
Regular price $224.00
Regular price Sale price $224.00
Sale Unavailable
View full details

Friday, August 16, 2024; 1:00 PM Eastern or Friday, October 18, 2024; 11:00 AM Eastern

Scheduled for 90 minutes including question and answer period.

Training Overview

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.

Recommended Audience
Who Should Attend?

Everyone who uses or could use Excel, including:

  • Human resources professionals
  • Business owners
  • Plant managers
  • Finance professionals
  • Operations managers
  • Contract managers
  • Contract administrators
  • Commercial managers
  • Supply chain managers
  • Supplier relationship managers
  • Supply base managers
  • Strategic sourcing managers
  • Procurement managers
  • Supervisors
  • Development staff
  • Program directors
  • Hiring staff
  • Nonprofit chief executives
  • Executive directors
  • Development staff
  • Consultants
  • Marketing staff
  • Fundraising staff
  • School district administrators
  • Charter school board members
  • Principals
  • Assistant principals
  • Department chairs
  • Curriculum specialists
  • Community engagement professionals
What's included
Training includes
  • Certificate of Attendance
  • All resources and training materials
  • This session is a part of the Electronic Spreadsheet Fundamentals Certification.

Expert Presenter

Jackie Kiadii
  • Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm
  • Helping clients leverage technology to increase their productivity and profitability since 2001
  • Provides curriculum development, consulting, and training in Microsoft 365® applications
  • Microsoft® Certified Trainer and Microsoft® Certified Expert – Excel