New Regular Expressions (REGEX) functions in Excel

Abdelrahman Abdou Instructor:
Abdelrahman Abdou 
Tuesday, August 20, 2024
11:00 AM PDT | 02:00 PM EDT
75 Minutes
Webinar ID: 502221

More Trainings by this Expert

Price Details
Live Webinar
$149 One Attendee
$299 Corporate Live
Recorded Webinar
$199 One Attendee
$399 Corporate Recorded
Combo Offers
Live + Recorded
$299 $348 Live + Recorded
Corporate (Live + Recorded)
$599 $698 Corporate
(Live + Recorded)

Live: One Dial-in One Attendee

Corporate Live: Any number of participants

Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Overview:

As the volume of data we handle continues to grow exponentially, the ability to efficiently process and analyze text data becomes increasingly crucial.

Microsoft Excel, already a cornerstone in the world of data analysis, has now been further enhanced with the introduction of powerful new regular expressions (regex) functions. These functions are designed to significantly boost your text manipulation capabilities, making complex text operations simpler, faster, and more accurate.

Regular expressions are sequences of characters that define search patterns, commonly used in programming for tasks such as string matching, extraction, and replacement. With the new regex functions in Excel, you can now bring the same level of sophistication and precision to your spreadsheets. This webinar, "New Regex Functions in Excel," will delve deeply into these newly introduced functions, providing you with the knowledge and skills to leverage them effectively in your daily work.

The webinar will kick off with an introduction to the basics of regular expressions. You’ll learn what regular expressions are, their syntax, and how they can be used to define search patterns. This foundational understanding is crucial as it sets the stage for exploring the specific regex functions available in Excel.

One of the highlights of the session will be the practical, hands-on examples that illustrate how to use these functions to solve real-world problems. For instance, you’ll see how to use the REGEX.EXTRACT function to pull specific data from text strings. Imagine having a column filled with various types of content, including emails, URLs, and hashtags, and being able to extract only the information you need with a simple formula. Whether you need to extract all email addresses from a dataset or pull out specific parts of URLs, the REGEX.EXTRACT function makes these tasks straightforward and efficient.

In addition to extraction, the webinar will cover the REGEX.REPLACE function, which allows you to replace parts of text that match a certain pattern. This function is particularly useful for tasks such as anonymizing data. For example, you might want to replace all instances of credit card numbers in a text with a generic placeholder to protect sensitive information. We will demonstrate how to craft regex patterns that can identify various formats of credit card numbers and replace them seamlessly, regardless of whether they include spaces, hyphens, or no separators at all.

Another key function that will be explored is REGEX.TEST, which lets you check if a specific pattern exists within a text. This function returns a boolean value (TRUE or FALSE) indicating whether the pattern is found, making it incredibly useful for validating data. For instance, you can use REGEX.TEST to verify if strings contain valid email addresses before processing them further. This validation step can be crucial in ensuring data integrity and accuracy.

The webinar will also highlight the use of tools like ChatGPT and Microsoft Copilot to generate regex patterns. Crafting regex patterns can be complex, but with the assistance of these AI tools, you can quickly and accurately generate the patterns you need. We will show you how to interact with these tools to get the most effective patterns for your specific needs.

Beyond the hands-on examples, participants will receive a regex cheat sheet containing commonly used patterns and tips for creating your own. This resource will be invaluable as you start to implement regex functions in your own Excel projects.

Finally, the webinar will provide insights into the availability of these new functions. Currently, they are accessible to Microsoft 365 users who are part of the Insider program and the Beta channel. We will guide you on how to join these programs to start using the functions immediately, ensuring you stay at the forefront of Excel’s evolving capabilities.

By the end of this webinar, you will be well-equipped to harness the power of regex in Excel, transforming the way you handle text data and boosting your efficiency. Whether you are a data analyst, a business professional, or an Excel enthusiast, this session will provide you with the tools and knowledge to take your data manipulation skills to the next level. Don’t miss this opportunity to explore the powerful new regex functions in Excel and revolutionize your text processing tasks.

Why should you Attend: In the ever-evolving landscape of data analysis and business intelligence, staying ahead of the curve with the latest tools and techniques is essential. The "New Regex Functions in Excel" webinar offers a unique opportunity to deepen your understanding of one of the most powerful and versatile additions to Excel: regular expressions (regex). Here’s why you should not miss this event.

First and foremost, regex functions in Excel significantly enhance your ability to manage and manipulate text data. Whether you are a seasoned data analyst, a business professional, or an Excel enthusiast, mastering these functions will streamline your workflow, saving you countless hours. Imagine effortlessly extracting emails, URLs, or dates from large datasets with just a few keystrokes. These new functions allow you to automate repetitive tasks, reducing manual errors and increasing your productivity.

Our webinar is designed to provide you with practical, hands-on experience. We will walk you through real-world examples, demonstrating how to use regex functions to solve common text manipulation challenges. From extracting specific patterns like emails and URLs to replacing sensitive information such as credit card numbers, you will see firsthand how regex can transform your data processing tasks. We’ll also explore advanced techniques, such as using capture groups and working with logical functions, to give you a comprehensive understanding of regex capabilities in Excel.

Furthermore, attending this webinar gives you access to expert insights and tips that you won’t find in standard tutorials. Our experienced speaker, who has extensive knowledge and experience with Excel and data analytics, will guide you through each step, providing clear explanations and answering your questions in real-time. This interactive format ensures that you can immediately apply what you learn to your own projects.

In addition to the live demonstration, attendees will receive valuable resources, including a detailed regex cheat sheet and an example workbook, to reinforce your learning. These resources will serve as handy references as you begin to implement regex functions in your daily tasks.

Lastly, staying updated with the latest Excel features ensures you remain competitive in your field. As these new regex functions are currently available only to Microsoft 365 users in the Insider program, this webinar provides an exclusive look at cutting-edge capabilities that will soon become essential tools for all Excel users. By attending, you will be ahead of the curve, ready to leverage these functions as soon as they become widely available.

In summary, the "New Regex Functions in Excel" webinar is an invaluable opportunity to enhance your data manipulation skills, boost your productivity, and stay at the forefront of Excel innovations. Don’t miss out on this chance to learn from an expert and transform the way you work with text data in Excel

Areas Covered in the Session:

  • Introduction to Regular Expressions (Regex)
  • Understanding the basics of regex and its syntax
  • Explanation of common regex patterns and their use cases
  • Overview of newly introduced regex functions in Excel
  • Detailed explanation of REGEX.EXTRACT, REGEX.REPLACE, and REGEX.TEST
  • Practical Applications and Examples:
  • Extracting emails, URLs, and hashtags from text using REGEX.EXTRACT
  • Replacing sensitive information, such as credit card numbers, with REGEX.REPLACE
  • Validating text patterns, such as verifying email addresses, with REGEX.TEST
  • Demonstration of how to use AI tools such as ChatGPT and Microsoft Copilot to create effective regex patterns
  • Practical examples of prompts and pattern generation
  • Handling Complex Text Operations
  • Combining regex functions with other Excel functions like TEXTJOIN and IFERROR
  • Managing arrays and handling errors in regex operations
  • Utilizing capture groups in regex patterns for more granular data extraction
  • Q&A and Interactive Learning

Who Will Benefit:
  • Data Analysts
  • Business Intelligence Analysts
  • Financial Analysts
  • Marketing Analysts
  • IT and Database Professionals
  • Excel Enthusiasts
  • Data Scientists
  • Administrative Professionals
  • Educators
  • Trainers


Speaker Profile
Abdelrahman Abdou is an experienced Excel and Power BI Trainer and Consultant based in the Greater Vancouver Area, Canada. With a decade of experience in reporting, business intelligence, and data analytics across leading telecom companies in Egypt and Canada, Abdelrahman brings a wealth of knowledge to his field. Over the past 8 years, he has dedicated himself to teaching Excel and Power BI, helping professionals leverage the power of data to drive decision-making.


You Recently Viewed

Subscribe to our Newsletter

Subscribe for Compliance Alerts Research Reports Absolutely Free