Excel - Direct Dates & Tangle with Text

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

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
Sep 08, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 28, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 20, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 07, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 06, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR

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