Short Excel
Short Excel
  • 271
  • 250 546
How to Mark Only the Last Item as 'Yes' in Grouped Data with Power Query
Download Excel File : docs.google.com/spreadsheets/d/1OCCqo6bfktoCP3TTyWmyYdrhl1PhAaGe/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
Переглядів: 88

Відео

How to Capitalize the First Letter of Each Word in Excel
Переглядів 4914 годин тому
Download Excel File : docs.google.com/spreadsheets/d/1fcE_J4eHF_1vC-MuetZp-GRs8ltkfLqM/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Combine Multiple Columns into One Unique List
Переглядів 10219 годин тому
Download Excel File : docs.google.com/spreadsheets/d/1fEfYQ2BJqNlcy01sNn_3qVNe395DvQnW/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Separate Text and Numbers in Excel
Переглядів 92День тому
Download Excel File : docs.google.com/spreadsheets/d/1qdj_CHsAaysbaTngxr0Pf0Gs6VoZKmqc/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Combine Unique Values by Category in Power Query
Переглядів 31114 днів тому
Download Excel File : docs.google.com/spreadsheets/d/1x0pTbIOifOCe1D1Ee4OUe1eJz2FE0PEU/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Combine Unique Values by Category in Excel
Переглядів 15221 день тому
Download Excel File : docs.google.com/spreadsheets/d/1cBArlBv3kRsUDzSMBzusvlgbuANfNhMD/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Convert Text to Uppercase
Переглядів 7321 день тому
Download Excel File : docs.google.com/spreadsheets/d/1gLYy4oVOg2twAZNaE63I9L_wwBD9SPgf/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Convert Text to Lowercase
Переглядів 6628 днів тому
Download Excel File : docs.google.com/spreadsheets/d/1ngp0OXtuRc_muWl8032HnKLrjz2_9yZQ/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Filter Non-Fibonacci Numbers Using Excel
Переглядів 48Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/1rDQ1qcBELuPNiD9epc6l-Oef9vkJ77z9/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Pivot Sales Data by Category and Year
Переглядів 87Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/17u3KZaVfvx8-rFsS5QC4EX2CVapj5WmL/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Convert Stacked Data to Tabular Format in Power Query
Переглядів 312Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/1DgojC9qA65KFXDNdAiaUpKfnnB5UKGhX/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Use SUBSTITUTE Function in Excel
Переглядів 166Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/1S6qENRxZ-4O976wYdmw95NwjF0Djtl47/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Transform Data into a Day-of-Week Matrix in Power Query
Переглядів 147Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/1JnflE8CWpMLl7GuwIvdzW3eNPDV1YIOI/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel
Переглядів 90Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/12noJHo5xQcAD66z3Aq73q-qnWulPEOYL/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
Adding Missing Closing Brackets in Excel
Переглядів 100Місяць тому
Download Excel File : docs.google.com/spreadsheets/d/1STTs5bJdqOawdjAyOY9IWRktoD4mu7qD/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true Formula Breakdown: =IF(ISNUMBER(FIND("[",A2)),SUBSTITUTE(A2,"]","")&"]",A2) Step 1: FIND("[",A2) Searches for the opening bracket "[" in cell A2 Returns the position of "[" if found, or #VALUE! if not found Step 2: ISNUMBER(FIND("[",A2)) Checks if...
New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE
Переглядів 110Місяць тому
New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE
How to use AutoSum in Excel
Переглядів 752 місяці тому
How to use AutoSum in Excel
How to Consolidate Employee Information Using Power Query
Переглядів 2462 місяці тому
How to Consolidate Employee Information Using Power Query
How to Count People with Missing Middle Names in Excel
Переглядів 952 місяці тому
How to Count People with Missing Middle Names in Excel
How to Summarize Monthly Data by Department in Power Query
Переглядів 2162 місяці тому
How to Summarize Monthly Data by Department in Power Query
How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel
Переглядів 412 місяці тому
How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel
How to Check if a Cell Contains Numbers in Excel
Переглядів 692 місяці тому
How to Check if a Cell Contains Numbers in Excel
How to use FIND/SEARCH function in Excel
Переглядів 1242 місяці тому
How to use FIND/SEARCH function in Excel
How to Use the Power Query Null Coalescing Operator
Переглядів 1362 місяці тому
How to Use the Power Query Null Coalescing Operator
How to use LEN Function in Excel
Переглядів 852 місяці тому
How to use LEN Function in Excel
How to use RIGHT function in Excel
Переглядів 783 місяці тому
How to use RIGHT function in Excel
Text.Middle vs Text.Range
Переглядів 1313 місяці тому
Text.Middle vs Text.Range
How to use the MID function in Excel
Переглядів 723 місяці тому
How to use the MID function in Excel
How to use LEFT function in Excel
Переглядів 783 місяці тому
How to use LEFT function in Excel
How To Remove Non Numeric Characters From Cells In Excel
Переглядів 1453 місяці тому
How To Remove Non Numeric Characters From Cells In Excel

КОМЕНТАРІ

  • @qasimali-gu3oz
    @qasimali-gu3oz День тому

    Can you try LeetCode with Power Query, Please?

  • @qasimali-gu3oz
    @qasimali-gu3oz День тому

    Can you try LeetCode with Power Query, Please?

  • @howtolearnexcel
    @howtolearnexcel 4 дні тому

    Wow! That's outstanding. Thank you for this technique!

  • @superyngo
    @superyngo 7 днів тому

    With large data the computer die quickly

  • @Luciano_mp
    @Luciano_mp 13 днів тому

    Thanks.

  • @luigibru8677
    @luigibru8677 20 днів тому

    Based on the "Column Name" it returns one among the other 3 columns (G, H, I)... for example the first line is "Supplier" so in the "Custom Column" returns "Tokyo Traders".

  • @nabiledelbi5502
    @nabiledelbi5502 21 день тому

    I'm crying 😂 This video basically shows how to extend power query's built-in language with any javascript text processing function. Thanks for sharing!

  • @CAKimberlyLewis
    @CAKimberlyLewis 22 дні тому

    Feel sorry for me. I still don't have GROUPBY and I don't know why. 😢 I guess MS is making me pay for all the things I said about Clippy.

  • @Luciano_mp
    @Luciano_mp Місяць тому

    Great examples. Thanks! 👍

  • @Luciano_mp
    @Luciano_mp Місяць тому

    Good example. Your videos are good! Thanks.

  • @carlosrsantana6768
    @carlosrsantana6768 Місяць тому

    Excelente!

  • @JenMayB
    @JenMayB Місяць тому

    Thank you! But how do i write the code to extract the seven digit item within that starts with a 6?😊

    • @short_excel
      @short_excel Місяць тому

      Without knowing the specific format or pattern of the data, it's difficult to provide an accurate answer.

  • @Luciano_mp
    @Luciano_mp Місяць тому

    Useful, thanks!

  • @nawafaldawsari8706
    @nawafaldawsari8706 Місяць тому

    you made my day ❤ Thanks

  • @HurricaneBarker
    @HurricaneBarker Місяць тому

    Dude! Can we be friends! This short and very sweet video was perfect. Great job.

  • @ZEROSKATER19931
    @ZEROSKATER19931 2 місяці тому

    Thanks so much for the help :)

  • @rmalkar83
    @rmalkar83 2 місяці тому

    no clarity, formula not visible

    • @short_excel
      @short_excel 2 місяці тому

      Please click on the gear icon on the UA-cam player and set the ‘Quality’ to a higher resolution.

  • @DanielVazRJ
    @DanielVazRJ 2 місяці тому

    Perfect! That´s just what I needed! Thanks!

  • @Tuma25
    @Tuma25 2 місяці тому

    Perfect and simple introduction

  • @vinhwizard
    @vinhwizard 2 місяці тому

    Genius

  • @sumardjo
    @sumardjo 2 місяці тому

    Thanks very much for sample file easy to be step by step your video thanks for knowledge thanks very much

  • @victorjbm05
    @victorjbm05 2 місяці тому

    Could you explain function (x)=> ????

    • @short_excel
      @short_excel 2 місяці тому

      The anonymous function (x) => { x, each List.Sum(Table.Column(_,x)) } in this code has the following roles: (x): This part is the parameter that receives each element (column name) from the List.Transform function. { ... }: This part is the body of the anonymous function, and it returns two elements. x: The first element simply returns the input column name as is. each List.Sum(Table.Column(_,x)): The second element calculates the sum of all values in the current column. Table.Column(_,x): This retrieves all the values in the current column. List.Sum(...): This calculates the sum of the retrieved column values. As a result, this anonymous function returns a list of two elements: the column name and the sum of the values in that column. These generated lists are then added as rows to the final result table. Please refer to the following site for more information excelguru.ca/each-keyword-power-query/

    • @victorjbm05
      @victorjbm05 2 місяці тому

      @@short_excel Underscore inside Table.Column returns values in the table ChangedType?

  • @kebincui
    @kebincui 2 місяці тому

    Thanks for the video. Very good.

  • @sumardjo
    @sumardjo 2 місяці тому

    Thanks very much Always to Sample file sample file to easy to follow your video thanks very much

  • @alessandroverde1885
    @alessandroverde1885 2 місяці тому

    Thanks so much for this video !!!

  • @Luciano_mp
    @Luciano_mp 3 місяці тому

    Thank you!

  • @Galli-se-office
    @Galli-se-office 3 місяці тому

    great

  • @shivaam-lu8in
    @shivaam-lu8in 3 місяці тому

    Whats happen?

  • @alexrosen8762
    @alexrosen8762 3 місяці тому

    Smart!

  • @johanneskeller3794
    @johanneskeller3794 3 місяці тому

    this video delivers the solution of a problem I have desperately been looking for for a long time ! Thank you very much !

  • @sumardjo
    @sumardjo 3 місяці тому

    thanks tutorial and thanks for simple file.... thank you very much

  • @sumardjo
    @sumardjo 3 місяці тому

    Thanks for your share knowledge and special thanks for link simple file good luck for you... Thanks very much

  • @itgyantricks7218
    @itgyantricks7218 3 місяці тому

    What function it is?

    • @sumardjo
      @sumardjo 3 місяці тому

      function let, isnumber act

  • @victorjbm05
    @victorjbm05 3 місяці тому

    You're brilliant, you made easier learn M language. I'm your new subscriber. 👍

  • @sumardjo
    @sumardjo 3 місяці тому

    Wouii Thanks Very much your Knowledge transfer with Simple file to easy step by step video... thanks very much....

  • @sumardjo
    @sumardjo 3 місяці тому

    Thanks for Tutorial... and Sample File step by step to follow .... video

  • @carlosrsantana6768
    @carlosrsantana6768 3 місяці тому

    😲😃👋

  • @vinhwizard
    @vinhwizard 3 місяці тому

    excellent but complicated :), I can not remember

  • @sumardjo
    @sumardjo 4 місяці тому

    thanks for sample file Thanks very much for share knowledge

  • @sumardjo
    @sumardjo 4 місяці тому

    thanks for your knowledge and thanks very much for sample file easy to be learn

  • @sumardjo
    @sumardjo 4 місяці тому

    thanks for your knowledge and thanks very much for sample file easy to be learn

  • @sumardjo
    @sumardjo 4 місяці тому

    Thanks for sample file and your share knowledge

  • @sumardjo
    @sumardjo 4 місяці тому

    Thanks for sample file Thanks very much your teach ....

  • @PavanKumar-vd2bi
    @PavanKumar-vd2bi 4 місяці тому

    Best ever video with proper explanation - Hats Off!

  • @vinhwizard
    @vinhwizard 4 місяці тому

    Great, you always have many methods for one purpose.

  • @SndfOmar
    @SndfOmar 4 місяці тому

    Awesome!

  • @Luciano_mp
    @Luciano_mp 4 місяці тому

    Good, thank you. 👍

  • @clairedelune691
    @clairedelune691 4 місяці тому

    This is gold, thank you so much. I'm a bookkeeper and these free Excel tutorials are a big help. More success to your UA-cam channel.

  • @Luciano_mp
    @Luciano_mp 4 місяці тому

    Good tip, thank you Shot!

  • @Luciano_mp
    @Luciano_mp 4 місяці тому

    Thanks!