In this presentation author and Excel expert David H. Ringstrom, CPA, introduces you to the world of pattern-based lookups using powerful tools like XLOOKUP and regular expressions. You’ll discover how to perform exact, approximate, and partial matches with XLOOKUP, as well as how to go further with advanced techniques such as either/or logic and pattern-based matching. David demystifies regular expressions by breaking down token structures and core components, and he demonstrates practical Excel functions like REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. Along the way, you’ll see how sites like RegEx101.com can assist your pattern-building efforts and learn when to use fuzzy matching instead of regular expressions.

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.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Upon course completion a course evaluation form is provided for your feedback.

You have 1 year from the time of purchase/enrollment to complete the course.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/