Essential Excel

Essential Excel

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.

Пікірлер

  • @ezequiasrocha3037
    @ezequiasrocha30377 күн бұрын

    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.

  • @user-yl5oz9lu9e
    @user-yl5oz9lu9e7 күн бұрын

    How to apply conditional formatting in this criteria sir

  • @user-yl5oz9lu9e
    @user-yl5oz9lu9e7 күн бұрын

    How to apply conditional formatting in this criteria sir.

  • @plantinpot5712
    @plantinpot57127 күн бұрын

    I can't find buttons in slicer

  • @ramonl6637
    @ramonl66379 күн бұрын

    Thank you. It works for me.

  • @applesoranges559
    @applesoranges55913 күн бұрын

    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 💯 ..

  • @GAabeee95
    @GAabeee9515 күн бұрын

    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!

  • @st4fi
    @st4fi15 күн бұрын

    This was very helpful - very easy to understand! THank you!

  • @isabeldominguezperez6596
    @isabeldominguezperez659616 күн бұрын

    What excel are you using? do you happen to know the commands in spanish?

  • @Heeragr8
    @Heeragr820 күн бұрын

    I have searched and tired many other possibilities for hours, thank you so much for your help with this formula.

  • @coreyries9491
    @coreyries949122 күн бұрын

    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?

  • @peppnose46
    @peppnose4622 күн бұрын

    Fucking hell what a video. U're the man brother

  • @shubhabratadey
    @shubhabratadey24 күн бұрын

    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

  • @kanakikuran7798
    @kanakikuran779824 күн бұрын

    Hi, I’ve followed this step but the attachments I received are blank.. pls help 🥺

  • @coreyries9491
    @coreyries949122 күн бұрын

    Ever figure this out?

  • @kanakikuran7798
    @kanakikuran779822 күн бұрын

    @@coreyries9491 yes! Thnx btw

  • @modr2944
    @modr294427 күн бұрын

    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

  • @laxmithakur1990
    @laxmithakur199028 күн бұрын

    Vvhelp ful

  • @druzicka2010
    @druzicka2010Ай бұрын

    i gonna try it. it's amazing! i didn't know that... thanks.

  • @antonioacelim8855
    @antonioacelim8855Ай бұрын

    Nice tutorial. How can we rename shared files in Office365

  • @Spelledwithaph
    @SpelledwithaphАй бұрын

    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?

  • @pbhogal80
    @pbhogal80Ай бұрын

    Thank you so much for this video, have been struggling to do this today and you have shown me in less than 7 mins 😊

  • @terminalx2174
    @terminalx2174Ай бұрын

    How can "create file" in someone's shared folder (with can edit permission)?

  • @imannayak5839
    @imannayak5839Ай бұрын

    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

  • @compscript7973
    @compscript7973Ай бұрын

    Perfect: Quick, Simple, No music while talking, No begging for likes, No long intro.

  • @simonefoleng627
    @simonefoleng627Ай бұрын

    May I ask what you're using to record your screen please?

  • @toiletrolls
    @toiletrollsАй бұрын

    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

  • @DianeLogan-hv6st
    @DianeLogan-hv6stАй бұрын

    Thank you really helpful

  • @biotechlucas4126
    @biotechlucas4126Ай бұрын

    Underrated video! Thank you!

  • @EssentialExcel
    @EssentialExcelАй бұрын

    Thank you! 🙂

  • @deanofrhythm2927
    @deanofrhythm2927Ай бұрын

    I'm having some trouble with a folder other than Inbox. It won't accept the path. Any help would be greatly appreciated.

  • @javierrodriguezgutierrez9463
    @javierrodriguezgutierrez9463Ай бұрын

    Thank you so much for the video!

  • @Masoom36
    @Masoom36Ай бұрын

    Seeing the formula like that really helped. Thanks!

  • @TheJaebeomPark
    @TheJaebeomParkАй бұрын

    awesome

  • @aniaimichax2150
    @aniaimichax2150Ай бұрын

    how do you do similar but one email with a list of all files/documents uploaded or amended in SharePoint

  • @so7989
    @so7989Ай бұрын

    Thank you, just used this for work. very helpful and to the point!

  • @user-bn5cs5dd1y
    @user-bn5cs5dd1yАй бұрын

    Amazing, worked first time. Thank you. Well explained and easy to follow.

  • @kebincui
    @kebincui2 ай бұрын

    Excellent video 👍👍, thanks

  • @allu_bechne_wala_rohit
    @allu_bechne_wala_rohit2 ай бұрын

    Thanks

  • @suvigyasharma5474
    @suvigyasharma54742 ай бұрын

    I can get the dates but I am not getting day names of the week

  • @kgsconsultinginc.6831
    @kgsconsultinginc.68312 ай бұрын

    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.

  • @Jimt4728
    @Jimt47282 ай бұрын

    Excellent, just what I needed.

  • @nosyparker10
    @nosyparker102 ай бұрын

    Error 404

  • @B.BarathKumar
    @B.BarathKumar2 ай бұрын

    This is what exactly I want. Million thanks to you.😘

  • @MrFxJ
    @MrFxJ2 ай бұрын

    you saved me, thank you very much!

  • @EssentialExcel
    @EssentialExcel2 ай бұрын

    Glad to help 😃

  • @niravbamrotiya6981
    @niravbamrotiya69812 ай бұрын

    But it is only for one time run, everytime it will need a new name

  • @LupeMartinez-mt1zg
    @LupeMartinez-mt1zg2 ай бұрын

    Created my first power automate flow after watching this tutorial. Very helpful!

  • @natureNculture
    @natureNculture2 ай бұрын

  • @mayanksinghwal9587
    @mayanksinghwal95872 ай бұрын

    File is saving but there is no data File is blank Please help on this

  • @Ujwaluday507
    @Ujwaluday5072 ай бұрын

    Why cant i fetch the DATA source by using = Folder . files

  • @boston19801
    @boston198012 ай бұрын

    you are a genius and a great teacher, this combo is rare.

  • @ivanpetersen8331
    @ivanpetersen83312 ай бұрын

    Really, really, really thanks Best regards of Ivan Petersen from Chile