Essential Excel
Essential Excel
  • Видео 368
  • Просмотров 2 414 020
Unlock the Power of Excel: Elevate Your Skills with New AI Formulas!
New Excel functions powered by ChatGPT.
Dive into the future of Excel with our latest tutorial featuring the revolutionary ChatGPT-powered AI.Formula! Learn how to seamlessly integrate this groundbreaking tool into your Excel experience for free. We start by guiding you through the simple installation process as an Excel add-in.
Discover the power of AI.ASK as we demonstrate how to leverage its capabilities by posing straightforward questions using the =AI.ASK feature. Watch as we unlock the potential of AI.FILL to effortlessly generate intelligent responses, followed by harnessing the enhanced functionality of AI.EXTRACT for an unparalleled version of flash fill.
Explore the innovative AI.T...
Просмотров: 411

Видео

Filter Data with the Excel FILTER Function and Wildcards | Excel Tutorial
Просмотров 1,5 тыс.Год назад
Filter Data with the Excel FILTER Function and Wildcards | Excel Tutorial
Filter Data Dynamically with the Excel FILTER Function | How to Tutorial
Просмотров 585Год назад
Filter Data Dynamically with the Excel FILTER Function | How to Tutorial
How to Generate Random List in Excel | Step by Step Excel Tutorial #exceltips #tutorial
Просмотров 733Год назад
How to Generate Random List in Excel | Step by Step Excel Tutorial #exceltips #tutorial
Power Automate Tutorial: Filter SharePoint List with OData and Export to CSV
Просмотров 3,5 тыс.Год назад
Power Automate Tutorial: Filter SharePoint List with OData and Export to CSV
Revolutionize Your File Management with Power Automate - Create Dynamic Folders in a Snap!
Просмотров 11 тыс.Год назад
Revolutionize Your File Management with Power Automate - Create Dynamic Folders in a Snap!
Save All Outlook Email Attachments to Folder | Power Automate Tutorial
Просмотров 36 тыс.Год назад
Save All Outlook Email Attachments to Folder | Power Automate Tutorial
Transform Your Excel Game: Effortlessly Import Images and Boost Productivity with this Feature
Просмотров 485Год назад
Transform Your Excel Game: Effortlessly Import Images and Boost Productivity with this Feature
How to Create Variables in Power Automate (Tutorial)
Просмотров 10 тыс.Год назад
How to Create Variables in Power Automate (Tutorial)
How to Calculate Cumulative Total with DAX in Power BI
Просмотров 51 тыс.Год назад
How to Calculate Cumulative Total with DAX in Power BI
How to Combine Multiple Excel Files with Power Automate
Просмотров 46 тыс.Год назад
How to Combine Multiple Excel Files with Power Automate
Part 2 | How to Web Scrape in Power Automate Desktop
Просмотров 2,1 тыс.Год назад
Part 2 | How to Web Scrape in Power Automate Desktop
How to Web Scrape in Power Automate Desktop
Просмотров 14 тыс.Год назад
How to Web Scrape in Power Automate Desktop
Quickly Rename All Files In Folder with Power Automate
Просмотров 11 тыс.Год назад
Quickly Rename All Files In Folder with Power Automate
Send an Outlook Email with Power Automate When a New File is Added to SharePoint Document Library
Просмотров 23 тыс.Год назад
Send an Outlook Email with Power Automate When a New File is Added to SharePoint Document Library
Combine Data from Multiple SharePoint Files with Power BI
Просмотров 12 тыс.Год назад
Combine Data from Multiple SharePoint Files with Power BI
How to Move Email to Folder with Power Automate
Просмотров 16 тыс.Год назад
How to Move Email to Folder with Power Automate
How to Use Power Automate Flow Conditions
Просмотров 14 тыс.Год назад
How to Use Power Automate Flow Conditions
How to Save Email Attachments to SharePoint with Power Automate | Learn Power Automate
Просмотров 28 тыс.Год назад
How to Save Email Attachments to SharePoint with Power Automate | Learn Power Automate
Power Automate Export to CSV | How to Export a SharePoint list to CSV and Save in Library
Просмотров 26 тыс.Год назад
Power Automate Export to CSV | How to Export a SharePoint list to CSV and Save in Library
Create an Excel Calendar with Just ONE Formula
Просмотров 20 тыс.Год назад
Create an Excel Calendar with Just ONE Formula
How to Create In-Cell Charts in Excel
Просмотров 2142 года назад
How to Create In-Cell Charts in Excel
Import ONLY The Latest File - Power Query
Просмотров 20 тыс.2 года назад
Import ONLY The Latest File - Power Query
EASY Trick to COMBINE Multiple Excel files into ONE with Power Query
Просмотров 52 тыс.2 года назад
EASY Trick to COMBINE Multiple Excel files into ONE with Power Query
How to Merge Tables with Power Query | The VLOOKUP Alternative?!
Просмотров 5 тыс.2 года назад
How to Merge Tables with Power Query | The VLOOKUP Alternative?!
How to Split Text in Power Query
Просмотров 4,9 тыс.2 года назад
How to Split Text in Power Query
Count the number of times a month appears within in a range!
Просмотров 25 тыс.2 года назад
Count the number of times a month appears within in a range!
Amazing Excel Trick: Create a Task Tracker with Conditional Formatting!
Просмотров 6 тыс.2 года назад
Amazing Excel Trick: Create a Task Tracker with Conditional Formatting!
Power BI | Extract Text Before Delimiter (Power Query)
Просмотров 6 тыс.3 года назад
Power BI | Extract Text Before Delimiter (Power Query)
Get Data From The Web (Power BI)
Просмотров 6 тыс.3 года назад
Get Data From The Web (Power BI)

Комментарии

  • @antonioacelim8855
    @antonioacelim8855 День назад

    Nice tutorial. How can we rename shared files in Office365

  • @Spelledwithaph
    @Spelledwithaph 2 дня назад

    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 3 дня назад

    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 3 дня назад

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

  • @imannayak5839
    @imannayak5839 5 дней назад

    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 6 дней назад

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

  • @simonefoleng627
    @simonefoleng627 8 дней назад

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

  • @toiletrolls
    @toiletrolls 8 дней назад

    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 11 дней назад

    Thank you really helpful

  • @biotechlucas4126
    @biotechlucas4126 11 дней назад

    Underrated video! Thank you!

  • @deanofrhythm2927
    @deanofrhythm2927 12 дней назад

    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 13 дней назад

    Thank you so much for the video!

  • @Masoom36
    @Masoom36 13 дней назад

    Seeing the formula like that really helped. Thanks!

  • @TheJaebeomPark
    @TheJaebeomPark 15 дней назад

    awesome

  • @aniaimichax2150
    @aniaimichax2150 16 дней назад

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

  • @so7989
    @so7989 16 дней назад

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

  • @user-bn5cs5dd1y
    @user-bn5cs5dd1y 23 дня назад

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

  • @kebincui
    @kebincui 26 дней назад

    Excellent video 👍👍, thanks

  • @allu_bechne_wala_rohit
    @allu_bechne_wala_rohit 27 дней назад

    Thanks

  • @suvigyasharma5474
    @suvigyasharma5474 Месяц назад

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

  • @kgsconsultinginc.6831
    @kgsconsultinginc.6831 Месяц назад

    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
    @Jimt4728 Месяц назад

    Excellent, just what I needed.

  • @nosyparker10
    @nosyparker10 Месяц назад

    Error 404

  • @B.BarathKumar
    @B.BarathKumar Месяц назад

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

  • @MrFxJ
    @MrFxJ Месяц назад

    you saved me, thank you very much!

  • @niravbamrotiya6981
    @niravbamrotiya6981 Месяц назад

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

  • @LupeMartinez-mt1zg
    @LupeMartinez-mt1zg Месяц назад

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

  • @natureNculture
    @natureNculture Месяц назад

  • @mayanksinghwal9587
    @mayanksinghwal9587 Месяц назад

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

  • @Ujwaluday507
    @Ujwaluday507 Месяц назад

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

  • @boston19801
    @boston19801 Месяц назад

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

  • @ivanpetersen8331
    @ivanpetersen8331 Месяц назад

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

  • @jeyameneses5175
    @jeyameneses5175 Месяц назад

    THANK YOU SO MUCH!!!

  • @mannequinomadness5961
    @mannequinomadness5961 2 месяца назад

    Thank you so much! Exactly what I needed. Officially a subscriber now! Thank you.

  • @paulgallagher2987
    @paulgallagher2987 2 месяца назад

    Thanks for this. @6:30 does the Binary.Combine function only work on csv files or would it work on .xslx files too?

  • @naomihu9399
    @naomihu9399 2 месяца назад

    Thank you ❤❤❤❤

  • @OMAKEM
    @OMAKEM 2 месяца назад

    Interesting but power query is much more easy to get the same result

  • @izzyolumese2540
    @izzyolumese2540 2 месяца назад

    Thank thank thank you ❤

  • @d0zxe
    @d0zxe 2 месяца назад

    Hi, this is amazing stuff, however my question is what if one of the files you are trying to combine is dynamic; so in my case, I have two files I would like to combine. They have same properties etc etc. One of the files is generated via an API using power automate, however it only creates 2 months worth of data when the flow runs once every month. My second file is a master file that contains historical data. at the moment, I do this manually once every month where the new data generated from the API flow to the master file. Is there a way to automate the process of appending the API generated file to the master file, master file should only have new API generated data added to it. Any help would be appreciated, thanks.

  • @KarThik-tb1pl
    @KarThik-tb1pl 2 месяца назад

    Hi the measure works for me but if I add another field for filter lets say Country then the cumulative sum stops working and it just sums up the date where there is data

  • @agatagaj1986
    @agatagaj1986 2 месяца назад

    Great! How do I overwrite a file in the folder if file with such name already exists?

  • @hindmusallam
    @hindmusallam 2 месяца назад

    Can I do the same task with word file to excel sheet instead of excel to excel?

  • @UrbyTuesday
    @UrbyTuesday 2 месяца назад

    This is a great tutorial. I got the file to copy to the sharepoint directory but the resulting file is empty. It's an excel file that says NULL in A1 when I open it.

  • @simon221196
    @simon221196 2 месяца назад

    How to save Excel files? It messes up their format

  • @vidpic8311
    @vidpic8311 2 месяца назад

    Music is tooooo loud and annoying

    • @EssentialExcel
      @EssentialExcel 2 месяца назад

      Sorry that’s the case, always trying to improve 👍

  • @trr12
    @trr12 2 месяца назад

    one cannot see your spreadsheet. fix it

  • @GPT-Print
    @GPT-Print 2 месяца назад

    Well this is awesome 😁📃🤖🖨️ That table feature👌

  • @d.Noriko
    @d.Noriko 2 месяца назад

    I got a Warning in step 6 (write in a excel) "Deferred type provided" How can I fix that?

    • @brendaloo4589
      @brendaloo4589 Месяц назад

      i am facing the same issue as well for a different flow where the steps are all the same. No idea whats happening.

  • @Random_channel_2023
    @Random_channel_2023 3 месяца назад

    I though this would be a video specifically about the condition control, its labels, and everything about it, not the if yes or if no sections that come after it. Not useful.