NATURAL LANGUAGE FILTERS: EARLY ACCESS & DOWNLOADS [Silver Members] (Patreon)
Downloads
Content
Hello, my friends, great to have you here as a Silver Member. This week's training is on the Natural Language Filters.
In this training, I’ll show you how to build a powerful Natural Language (NL) filtering system in Excel where you simply type plain-English requests like “sales over 2000” or “Desktop PC sales this year” and let AI handle the rest. You’ll create a VBA macro connected to the Groq API that converts natural language into precise Advanced Filter criteria—including dates, ranges, and wildcards—then runs the filter automatically. I’ll walk you through the entire process, from sending prompts, headers, and sample data to the AI, to parsing the JSON response and applying the results in Excel, so you can fully automate complex data filtering using a free template and complete VBA code.
▶️ Feel free to watch the full training video when it goes live on YouTube here.
As a Silver Member, you can also participate in our Feature, Fix or Focus Program, in which each week I will add a feature, fix an issue, or focus on a specific part of the current week’s training. This Feature, Fix, or Focus will be entirely based on your requests and ideas in the comments below. Based on those suggestions, I will then create another short video, along with an updated workbook and make them available exclusively to you, right here on Patreon. I look forward to reading your comments below.
👉 Make sure you download the workbook, PDF codebook, and the training resources in the files below.
I would love to hear your feedback, ideas, and suggestions on any upcoming videos as well, so make sure to comment below as I read every comment.
I look forward to hearing from you and I hope you enjoy the training. Thank you.