- Видео 275
- Просмотров 254 607
Short Excel
Южная Корея
Добавлен 12 янв 2020
How to Convert Arabic Numeral to Roman Numeral In Excel
Download Excel File : docs.google.com/spreadsheets/d/1hZBRTh-sGfLg7YuHvlyLmz885FpQ0iu6/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
Просмотров: 39
Видео
How to Use FLOOR MATH Function in Excel
Просмотров 52День назад
Download Excel File : docs.google.com/spreadsheets/d/1TCC9UpphvEBV9v5W9RBaCQm-WhZKLaxX/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
Separate Text and Numbers in Excel
Просмотров 51День назад
Download Excel File : docs.google.com/spreadsheets/d/1x32x_DLStLk2c6kY4QcRmW135YDoy-H6/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Use CLEAN Function in Excel
Просмотров 692 дня назад
Download Excel File : docs.google.com/spreadsheets/d/1jJv-u5hmAL1bw1FwJDdM8sDwTr87DRch/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Mark Only the Last Item as 'Yes' in Grouped Data with Power Query
Просмотров 12314 дней назад
Download Excel File : docs.google.com/spreadsheets/d/1OCCqo6bfktoCP3TTyWmyYdrhl1PhAaGe/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Capitalize the First Letter of Each Word in Excel
Просмотров 6221 день назад
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
Просмотров 11621 день назад
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
Просмотров 9928 дней назад
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
Просмотров 448Месяц назад
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
Просмотров 193Месяц назад
Download Excel File : docs.google.com/spreadsheets/d/1cBArlBv3kRsUDzSMBzusvlgbuANfNhMD/edit?usp=sharing&ouid=110135186698985964278&rtpof=true&sd=true
How to Convert Text to Uppercase
Просмотров 79Месяц назад
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
Просмотров 71Месяц назад
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
Просмотров 54Месяц назад
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
Просмотров 98Месяц назад
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
Просмотров 320Месяц назад
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
Просмотров 171Месяц назад
How to Use SUBSTITUTE Function in Excel
How to Transform Data into a Day-of-Week Matrix in Power Query
Просмотров 1542 месяца назад
How to Transform Data into a Day-of-Week Matrix in Power Query
How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel
Просмотров 962 месяца назад
How to Convert YYYYMMDD Text Dates to Recognizable Dates in Excel
Adding Missing Closing Brackets in Excel
Просмотров 1092 месяца назад
Adding Missing Closing Brackets in Excel
New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE
Просмотров 1162 месяца назад
New Translation Functions in Excel : TRANSLATE and DETECTLANGUAGE
How to Consolidate Employee Information Using Power Query
Просмотров 2532 месяца назад
How to Consolidate Employee Information Using Power Query
How to Count People with Missing Middle Names in Excel
Просмотров 1032 месяца назад
How to Count People with Missing Middle Names in Excel
How to Summarize Monthly Data by Department in Power Query
Просмотров 2192 месяца назад
How to Summarize Monthly Data by Department in Power Query
How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel
Просмотров 442 месяца назад
How to Convert Between Celsius (°C) and Kelvin (K) Temperatures in Excel
How to Check if a Cell Contains Numbers in Excel
Просмотров 723 месяца назад
How to Check if a Cell Contains Numbers in Excel
How to use FIND/SEARCH function in Excel
Просмотров 1333 месяца назад
How to use FIND/SEARCH function in Excel
How to Use the Power Query Null Coalescing Operator
Просмотров 1393 месяца назад
How to Use the Power Query Null Coalescing Operator
?
Greats examples! Thank you!
tks
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 RUclips 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. 👍