Alejandra Horvath
Excel y Power Query.
My channel in Spanish: youtube.com/@alejandrahorvathenespañol
Как динамически извлекать текст из столбца с помощью Power Query
Разделение столбцов во вложенных таблицах
От «Ух!» до «Ага!» с Power Query и Power Pivot 😊
Group and Then Extract The First Value From Nested Lists
List.Mode( ) или List.Modes( ), какой из них использовать?
How To Connect Data From Different Tables/Files ❤️Very Easy & Quick
Dynamically Transform Data Type for All Columns with Table.TransformColumns
=Table.FromList( ) when working with numbers
Stop Using SUMIF - How To Use GROUPBY( ) Instead 💚 Easier, Faster, Life Changer!
Excel Functions Version - How To Remove Columns by Position Number 🤯🤯🤯
How I Calculate Running Totals, Using Power Query
Select or Remove Columns Based on Their Position 🤯🤯🤯
How To Dynamically Remove Empty Columns in Power Query
How To Work With Double Headers - Power Query
How I use the =DROP( ) function in Excel! - MS365
AGGREGATE - This Excel Function is a Real Treasure!
How To Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!
В Power Query можно фильтровать несколько столбцов одновременно!
Are you creating the query in the same workbook? Do it fast and efficiently!
How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?
Optimize Table.SelectRows for better results! #PowerQuery
Convert Text To Date And Group By Quarters - Power Query
How To Start Working With Pivot Tables In Excel
M - Lists Overview
Simple and easy transformations for a better analysis - Power Query
How I Dynamically Transform Double Column Names With Power Query
How I Replace Special Characters In a Text
Table.TransformRows or Table.TransformColumns
Replace Multiple Values With Power Query - Short Version
WRAPROWS & WRAPCOLS -You Will Love Them!!!