Excel How To: Date And Text Functions

with
Jackie Kiadii
Live Session
From $149.00
  • October 8, 2021, 2:30 pm   EST
Training Includes:
  • Certificate of Attendance
  • All resources and training materials
  • An on-demand recording will be available after the live presentation.

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
When:
Friday, October 8, 2021; 2:30 PM 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

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

 

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