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
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.
Who Should Attend?
|
Everyone who uses or could use Excel, including:
|
|
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
CareerLearning Quality Commitment
CareerLearning wants you to be satisfied with your purchase. If this program does not meet your expectations, email us at support@careerlearning.com.