Intro to Regular Expressions in Excel
SKU: 06-557-01-CPE
Credit Hours: 2
Category: Computer software and applications
Level: Intermediate
Program Prerequisites: Prior experience with Microsoft Excel is recommended.
Delivery Method: Online Video
Instructor: David H. Ringstrom, CPA
Course Description:
This course will introduce you to the world of pattern-based lookups using powerful tools like XLOOKUP and regular expressions.
This course has the following learning objectives:
- Identify and understand the key components of regular expressions, such as character classes, quantifiers, anchors, and groups, which are used to define search patterns in text.
- Identify the correct method or token for enabling case-insensitive behavior in a regular expression pattern.
- Recall the correct function arguments for the REGEXTEST function in Excel.