Excel - Direct Dates & Tangle with Text

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT
Skip to Class Dates
Request More Information

In this course you will learn how to use date and text functions, ensure formulas using dates and are properly calculated and how to manipulate text. You will learn the Flash Fill feature for quick data entry and how to combine multiple text functions into one formula.

 

Upcoming Class Dates and Times

Aug 15, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Sep 08, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Sep 28, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Oct 20, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Nov 07, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Dec 06, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now

This class is also part of our LearnNow Pass. Click here for more details.

Agenda

1 - Outline
  • Know how to handle dates and date formulas.
  • Use Dates in Functions - TODAY and NOW, NETWORKDAYS, DAYS, YEARFRAC, and DATEVALUE
  • Have Excel recognize patterns to automatically fill in data with Flash Fill.
  • Work with the Change Case - UPPER, LOWER, and PROPER, and Replace function results with values.
  • Use the CONCAT, TEXTJOIN, Text to Columns Wizard, RIGHT, LEFT, MID, LEN, FIND, and TRIM functions Combine functions for more functionality
  • Work with Columns and Split text