Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 11th Oct'24 to 21st Oct'24
Powerful Data Cleaning And Extraction Using ChatGPT And The New REGEX Functions In Excel
- 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.
Overview of the webinar
Unlock the full potential of your data manipulation capabilities with the new regex (regular expressions) functions in Excel. Designed for professionals across various fields, this webinar provides an in-depth look at how regex can transform the way you handle text data within your spreadsheets.
Regular expressions are sequences of characters that define search patterns, widely used for string matching, extraction, and replacement in programming. Now, these powerful capabilities are integrated into Excel, allowing you to perform complex text operations with ease. In this session, you’ll learn the fundamentals of regex and explore the new Excel functions: REGEX.EXTRACT, REGEX.REPLACE, and REGEX.TEST.
Through practical, real-world examples, we’ll demonstrate how to:
- Extract specific data patterns such as emails, URLs, and dates from text.
- Replace sensitive information, like credit card numbers, with anonymized placeholders.
- Validate text patterns to ensure data accuracy.
We’ll also show you how to use AI tools like ChatGPT and Microsoft Copilot to generate effective regex patterns, making complex tasks more manageable. Additionally, you'll learn to combine regex functions with other Excel functions like TEXTJOIN and IFERROR to handle arrays and manage errors.
Attendees will receive a comprehensive regex cheat sheet and an example workbook to practice and reinforce their learning. This webinar is ideal for data analysts, financial professionals, marketers, IT specialists, and anyone looking to enhance their Excel skills and productivity.
Join us to stay ahead in the ever-evolving world of data analysis, streamline your workflows, and master the new regex functions in Excel. Don’t miss this opportunity to revolutionize your text processing tasks and elevate your data handling proficiency.
Who should attend?
- Data Analysts
- Business Intelligence Analysts
- Financial Analysts
- Marketing Analysts
- IT and Database Professionals
- Excel Enthusiasts
- Data Scientists
- Administrative Professionals
- Educators and Trainers
Why should you attend?
The "New Regex Functions in Excel" webinar is a must-attend for anyone looking to enhance their data manipulation skills. Regular expressions (regex) are powerful tools for extracting, replacing, and validating text data, and now you can leverage these capabilities directly within Excel. This session will provide you with practical, hands-on examples, demonstrating how to efficiently manage tasks such as extracting emails, URLs, and dates, anonymizing sensitive information, and validating data patterns.
By attending, you'll gain insights from an experienced data professional, learn to use AI tools like ChatGPT to generate effective regex patterns, and receive valuable resources, including a regex cheat sheet and an example workbook. Whether you're a data analyst, marketer, financial professional, or Excel enthusiast, this webinar will equip you with the knowledge to streamline your workflows, reduce errors, and boost productivity. Don't miss this opportunity to stay ahead in the rapidly evolving world of data analysis.
Faculty - Mr.Abdelrahman Abdou
Abdelrahman 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.