Channel Avatar

Alejandra Horvath @UCFYQr-oZbz_90EWcvc-49XA@youtube.com

6.4K subscribers

Excel y Power Query. My channel in Spanish: youtube.com/@al


03:37
Dynamically Transform Data Type for All Columns with Table.TransformColumns
05:50
=Table.FromList( ) when working with numbers
01:31
=GROUPBY( ) 💚 Easier & Faster
04:40
How I Remove Columns by Position Number With Excel Functions
15:00
How I Calculate Running Totals, Using Power Query
06:47
How Table Schema can help you to select the columns to keep (or remove)
02:46
How To Dynamically Remove Empty Columns in Power Query
03:18
How To Work With Double Headers - Power Query
06:05
How I use the =DROP( ) function in Excel! - MS365
06:52
AGGREGATE - This Excel Function is a Real Treasure!
05:53
For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables
15:12
How To Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!
09:30
You Can Filter Several Columns At Once in Power Query!
15:50
Are you creating the query in the same workbook? Do it fast and efficiently!
01:20
How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?
27:23
How to be the hero at work with Power Query & Power Pivot
05:08
Optimize Table.SelectRows for better results! #PowerQuery
07:23
Convert Text To Date And Group By Quarters - Power Query
14:25
How To Start Working With Pivot Tables In Excel
07:02
M - Lists Overview
03:26
Simple and easy transformations for a better analysis - Power Query
31:11
How I Dynamically Transform Double Column Names With Power Query
09:23
How I Replace Special Characters In a Text
11:11
Table.TransformRows or Table.TransformColumns
14:51
Replace Multiple Values With Power Query - Short Version
04:08
WRAPROWS & WRAPCOLS -You Will Love Them!!!
09:25
SEQUENCE, VSTACK, INDEX, COUNTA - Split Info From 1 Column Into 2
10:44
Split information from 1 column into 2 with List.Alternate
07:00
Forget the Hard-Coded Column Names - Change Data Type To All Columns In a Table
01:08:17
How I Automate My Bank Reconciliations With Power Query
05:29
Several Reports - One Source Of Data - #PowerQuery
14:33
Table.Split and Table.SplitAt - Power Query
02:00
Split Text By Rows With Power Query
08:36
Dynamically Adding Leading Zeros - #SaturdayWithPowerQuery
01:52
Enter Info To A Table Though a Form - Not Everyone Knows...
12:47
How To Trim Leading Zeros With Power Query - #SaturdayWithPowerQuery
04:14
How I Take 10 Rows From The Middle Of a Range Or a Table, with =TAKE( ) In Excel
11:46
How To Transform Nested Tables & Then Combine Them - Power Query
05:25
Convert A Value To Text, In a Specific Format - #ExcelQuickTips
05:45
How I Add Values Based On 2 Criteria - You Will Love It!
02:14
Example Using Text.Repeat( ) Using Power Query - Bite-Sized Tips!
14:24
Select Random Names From A List Using Power Query - #SaturdayWithPowerQuery
32:47
Filtering By A List - Saturday With Power Query
03:24
You Need To Know These Excel Tips!!!
02:05
Top Secret In Excel - DateDif( )
13:21
=Filter( ) in Excel - Here is what I DO and HOW!
06:57
How I use =Take( ) in Excel - You will love this function!
06:53
How To Create A Custom Function That Updates As The Sample Query Updates
06:10
Adding the file name to nested tables
06:20
Transforming A Column & Filtering The Nested Tables Inside - My Favourite Tips Fr Live Sessions 2022
37:21
IMPROVED Filter #s Before Expanding Tables - Power Query
23:10
PQ - How I Used Divide-Integer & Modulo To Transform My Files This Week
19:07
Filter Item Numbers Before Expanding Tables - Power Query
02:37
Easy Way To Dynamically Remove Empty Rows And Columns
02:24
Dynamically Remove Blank Cells In No Time, With Power Query
01:22
Excel.Workbook - Promote Headers
16:19
PQ - Load Info Containing Specific Text
13:40
PQ - Filter Information By Multiple Conditions
12:17
PQ - Combining Information with List.Zip & Table.FromColumns
19:42
PQ - Obtain/Change Information In Power Query, Using Excel Cells.