- 271
- 250 546
Short Excel
South Korea
Приєднався 12 січ 2020
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 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 Remove Non Numeric Characters From Cells In Excel
Переглядів 1453 місяці тому
How To Remove Non Numeric Characters From Cells In Excel
Can you try LeetCode with Power Query, Please?
Can you try LeetCode with Power Query, Please?
Wow! That's outstanding. Thank you for this technique!
With large data the computer die quickly
Thanks.
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".
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!
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.
Great examples. Thanks! 👍
Good example. Your videos are good! Thanks.
Excelente!
Thank you! But how do i write the code to extract the seven digit item within that starts with a 6?😊
Without knowing the specific format or pattern of the data, it's difficult to provide an accurate answer.
Useful, thanks!
you made my day ❤ Thanks
Dude! Can we be friends! This short and very sweet video was perfect. Great job.
Thanks so much for the help :)
no clarity, formula not visible
Please click on the gear icon on the UA-cam player and set the ‘Quality’ to a higher resolution.
Perfect! That´s just what I needed! Thanks!
Perfect and simple introduction
Genius
Thanks very much for sample file easy to be step by step your video thanks for knowledge thanks very much
Could you explain function (x)=> ????
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/
@@short_excel Underscore inside Table.Column returns values in the table ChangedType?
Thanks for the video. Very good.
Thanks very much Always to Sample file sample file to easy to follow your video thanks very much
Thanks so much for this video !!!
Thank you!
great
Whats happen?
Smart!
this video delivers the solution of a problem I have desperately been looking for for a long time ! Thank you very much !
thanks tutorial and thanks for simple file.... thank you very much
Thanks for your share knowledge and special thanks for link simple file good luck for you... Thanks very much
What function it is?
function let, isnumber act
You're brilliant, you made easier learn M language. I'm your new subscriber. 👍
Wouii Thanks Very much your Knowledge transfer with Simple file to easy step by step video... thanks very much....
Thanks for Tutorial... and Sample File step by step to follow .... video
😲😃👋
excellent but complicated :), I can not remember
thanks for sample file Thanks very much for share knowledge
thanks for your knowledge and thanks very much for sample file easy to be learn
thanks for your knowledge and thanks very much for sample file easy to be learn
Thanks for sample file and your share knowledge
Thanks for sample file Thanks very much your teach ....
Best ever video with proper explanation - Hats Off!
Great, you always have many methods for one purpose.
Awesome!
Good, thank you. 👍
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.
Good tip, thank you Shot!
Thanks!