Welcome to Essential Excel, your go-to resource for learning and mastering Microsoft Excel, Power Automate, and Power BI.
Our tutorials are designed to help you quickly and easily understand and apply these powerful tools to your everyday needs. With in-application examples and practical solutions, you'll be able to start using what you learn right away.
Do you need extra support with a project? we're here to help! Just visit our website at www.BAThompsonLtd.com to learn more about how we can support you. Start mastering these essential tools today with Essential Excel.
Пікірлер
I would like to capture the before and after values of a sheet name just after it is renamed and update the previous cells with the before name to the new one.
How to apply conditional formatting in this criteria sir
How to apply conditional formatting in this criteria sir.
I can't find buttons in slicer
Thank you. It works for me.
Oh my word ... Was just searching and stumbled upon this and I positively and figuratively LOVE YOU 🕺... Just this small n precise to the point video and explanation with such meaningful simplicity, you ARE a boon Mr. Essential Excel ... Subscribed to this beautiful channel... So much love and support from Madhya Pradesh, India 💯 ..
I need to do the exact same thing but with amount of projects per fiscal year instead of $ per date... How would I do that??? Thank you!
This was very helpful - very easy to understand! THank you!
What excel are you using? do you happen to know the commands in spanish?
I have searched and tired many other possibilities for hours, thank you so much for your help with this formula.
For some reason, every file that is uploaded to sharePoint does not have a file time, so I cannot open it. If in the file name, I include ".xlsx" to match the email attachment, it is corrupted when uploaded to SharePoint. Any help?
Fucking hell what a video. U're the man brother
The only issue is in Power Query, you don't need the Columns in the same order but here we would need them to be in a specific order
Hi, I’ve followed this step but the attachments I received are blank.. pls help 🥺
Ever figure this out?
@@coreyries9491 yes! Thnx btw
Hi, if I want to make flow to save email attachment, then foldering it and rename with the date when I save, then combine the excel file by copy and paste to master excel, would that be possible ? And would you interest to provide private tutor for this workflow
Vvhelp ful
i gonna try it. it's amazing! i didn't know that... thanks.
Nice tutorial. How can we rename shared files in Office365
I have been looking for this exact process…followed it the same 100%, but I create attachments for all files (ex: signatures), not just the one I want. Conditions seem to be irrelevant. Am I missing something?
Thank you so much for this video, have been struggling to do this today and you have shown me in less than 7 mins 😊
How can "create file" in someone's shared folder (with can edit permission)?
external user send email attachment and upload in sharrpoint through power automate...what should be the flow?..bcz mail sender is outside of my organisation
Perfect: Quick, Simple, No music while talking, No begging for likes, No long intro.
May I ask what you're using to record your screen please?
hi, this tutorial is great! but how can i sumproduct month and year if i've got a list that goes by month and year. i've tried adding a second array =23 for 2023 but it's not counting
Thank you really helpful
Underrated video! Thank you!
Thank you! 🙂
I'm having some trouble with a folder other than Inbox. It won't accept the path. Any help would be greatly appreciated.
Thank you so much for the video!
Seeing the formula like that really helped. Thanks!
awesome
how do you do similar but one email with a list of all files/documents uploaded or amended in SharePoint
Thank you, just used this for work. very helpful and to the point!
Amazing, worked first time. Thank you. Well explained and easy to follow.
Excellent video 👍👍, thanks
Thanks
I can get the dates but I am not getting day names of the week
your data file is outdated! can you post the most recent and updated file please. The link in all you videos point to an older version.
Excellent, just what I needed.
Error 404
This is what exactly I want. Million thanks to you.😘
you saved me, thank you very much!
Glad to help 😃
But it is only for one time run, everytime it will need a new name
Created my first power automate flow after watching this tutorial. Very helpful!
❤
File is saving but there is no data File is blank Please help on this
Why cant i fetch the DATA source by using = Folder . files
you are a genius and a great teacher, this combo is rare.
Really, really, really thanks Best regards of Ivan Petersen from Chile