My goal is to help you save time at work, so you can spend it on activities that matter. My office productivity tutorials cover: - Microsoft Excel, Power BI, PowerPoint, VBA, OneNote, and other Office Products - Google Sheets - Accounting & Finance
I love to learn new tools and techniques and share these with you. I hope to inspire you to experiment and share with others.
🎓 My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP
🎬 Subscribe if you'd like to improve your skills. New video every Thursday and a #shorts on Sundays.
💡 Join 400,000+ members who've enrolled in our courses: www.xelplus.com/courses/ Our graduates are financial analysts, CFOs and business owners.
🆓 Get my free guide about the ONE critical Excel skill you need: www.xelplus.com/free-ebook/
👉 More info & updates from me: pages.xelplus.com/links
At 15:00 I personally find it a lot easier to simply multiply by 1. This deletes all the leading zero's and makes it a value. However, this is only possible if there is no other text.
Is it possible to add labels to both stacks and the total? I haven't been able to figure this out and have been manually adding a label to the second stack.
I hate when a new function eliminates the taste of analysing how to ideally approach the task in the best way , nested functions is sometimes fun to formulate .
I worry about being able to check someone's work. Having that email pattern coming from AI means that it is basically a black box unless you take the time to understand it.
We still don't have groupby and pivotby in regular version and now you're announcing yet another function in beta? Sigh. I'm saving it for when this becomes available.
I have to say, you did exceptional work on this video. Spot on. Straight to the point and covering a lot in a short time. And we get double for less time. BI and Query. It seems you also anticipated the various questions we would have. You put in much work into this. This is me saying we see it, and we appreciate it. THANK YOU.
I wrote my own "UDF" regex functions decades ago (part of my home made Tools Addin). Little by little those tools are becoming redundant. But it sure took a long time. But why replace backreferences with "$". That is not the way I've ever seen any other regex work. The usual backreference is \. I expect that is going to mess up your attempts to use AI help.
Hi Leila, Thank for making such an elaborate and informative video. Please help me address this issue, I have a folder in my inbox which contains 55k emails and when I try to export them using the method mentioned in this videos, After I click the tranform data and try to locate the folder, its not visible there. Hence I am not able to select the folder and transfer the data. Looking forward to your reply, Regards!
Ehehehe, excellent time saving useful Excel formula turned into an very useful function. Thanks. for the introduction and teaching the new function. The function does seem to have a few glitches here and there, but with a few tweaks here and there the function does seem to work quite fine! 👌🥰✨💎
This would be cool if REGEXREPLACE would have LAMBDA function for further replacement logic. The MatchEvaluator delegate in .NET does this job. The pseudo function would look like this: =REGEXREPLACE("This is regex 123 and 456", "[1-3]+", LAMBDA(match, LET(m, --match, IF(m=123, m*2, m*3)))) So, when regex finds "123" string, it passes it to lambda, which processes this matched value the way it's required. In this case, if match is equal to 123, then it's double, otherwise it's tripled.
Its great function but what i saw that the results are not consistent. Like you showed, something can get missed. if you have 20-30 rows then you can check what is missed but if you have 2k+ line items then its not possible to check each and every line item for missing things....😢
This just made my day! I lost weeks of work on new formulas because excel crashed yesterday. It also uses regex in office scripts. The rebuild can have this now and it will be way faster too.
You could conceivably set up an Excel Add-in or maybe a personal Macro workbook, where you create Named Formulas, where the REGEX code for emails, Dates, and other things can be stored. i.e. "b\[A-Za-Zo-9, yada yada]\b" is named "RegxEmail" or something like that, then when you need to use that as a function, it should just work when you type the name Alternatively, you can probably create a REGEX template you can open and copy pasted when needed, Lastly, perhaps easiest of all would be to create a custom Autocorrect setting to populate the REGEX code when "RegxEmail" is typed, etc. set up the ones you plan to use the most often.
@@LeilaGharani 😲Would that be at the global level or would those Lambdas live in specific workbooks? Also I'M SO EXICTED I GOT A REPLY FROM MY HERO!!!! YOU CANNOT IMAGINE HOW MUCH I SHARE YOUR CONTENT!
I’d like to ask you, this regex formula, how many CPU or memory consumes? Becaurse other ways are simplier and esier to do it. If regets can get you another approach without consuming that amount of resources okey, but if not I don’t see the point. I really like your videos!! I always learn from you!
I have account on hostinger and i have set up the same mail id in outlook. i tired to do the same exporting email from my hostinger email id but it didnt worked. could you please show me how to do it.
With all the tutorials, my colleagues are catching up on xlookup etc. Good to see Microsoft makes sure the wizards can still remain wizards in the workplace 😂 illegible formulas galore
I am glad to see regex in use. Eventhough i do not see that in action for a year or two. Since having unix background I have been using regexp for more than 30 years, so I welcome this. What I am a bit bored about are all ”new features” that cannot be used, as it is not part of regular distributions. Still waiting for instance to be able to start using the checkboxes. I would appreciate if early testers in their channels could remind the excel teams about taking presented features/functions into genaral releases. As said, before it is in general use, it is useless for business use.
Sweet! Thanks for the tips. I used to use it in sheets and was bummed when I went to a company that blocks sheets. Side note: The variation in REGEX pronunciation is kind of like GIF, hotly debated. Although it stands for Regular Expression, many people (myself included) pronounce it with a "J". This is due to the standard rule saying that if a g is followed by an e, i, or y, it's a soft g and says /j/ like "giraffe". But others stand firmly by "It stands for reGular expression so it's G like girl"
Love it. I only find it very frustrating that Microsoft takes for ever to roll out the new stuff. Still waiting for tick box option and even PIVOT formulas.
It was great! 👍 I was very wrong by being against the use of AI! We must adapt ourselves according to the times we are living in! I have also started using Chat GPT for work purposes and will also use other AI tools, applications and features as per requirements 🙂