Alejandra Horvath
5.86K subscribers
4:40
How I Remove Columns by Position Number With Excel Functions
Alejandra Horvath
388 views • 5 days ago
15:00
How I Calculate Running Totals, Using Power Query
Alejandra Horvath
650 views • 2 weeks ago
6:47
How Table Schema can help you to select the columns to keep (or remove)
Alejandra Horvath
970 views • 3 weeks ago
2:46
How To Dynamically Remove Empty Columns in Power Query
Alejandra Horvath
1K views • 1 month ago
3:18
How To Work With Double Headers - Power Query
Alejandra Horvath
343 views • 1 month ago
5:56
How I use the =DROP( ) function in Excel! - MS365
Alejandra Horvath
623 views • 6 months ago
6:52
AGGREGATE - This Excel Function is a Real Treasure!
Alejandra Horvath
1.5K views • 6 months ago
5:53
For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables
Alejandra Horvath
1.2K views • 6 months ago
15:12
How To Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!
Alejandra Horvath
2.4K views • 7 months ago
9:30
You Can Filter Several Columns At Once in Power Query!
Alejandra Horvath
2.5K views • 7 months ago
15:50
Are you creating the query in the same workbook? Do it fast and efficiently!
Alejandra Horvath
8.2K views • 7 months ago
1:20
How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?
Alejandra Horvath
411 views • 7 months ago
27:23
How to be the hero at work with Power Query & Power Pivot
Alejandra Horvath
1.9K views • 7 months ago
5:08
Optimize Table.SelectRows for better results! #PowerQuery
Alejandra Horvath
1.5K views • 8 months ago
7:23
Convert Text To Date And Group By Quarters - Power Query
Alejandra Horvath
974 views • 8 months ago
14:25
How To Start Working With Pivot Tables In Excel
Alejandra Horvath
311 views • 8 months ago
7:02
M - Lists Overview
Alejandra Horvath
589 views • 8 months ago
3:26
Simple and easy transformations for a better analysis - Power Query
Alejandra Horvath
497 views • 8 months ago
31:11
How I Dynamically Transform Column Names With Power Query
Alejandra Horvath
1.9K views • 8 months ago
9:23
How I Replace Special Characters In a Text
Alejandra Horvath
904 views • 8 months ago
11:11
Table.TransformRows or Table.TransformColumns
Alejandra Horvath
1.2K views • 8 months ago
14:51
Replace Multiple Values With Power Query - Short Version
Alejandra Horvath
597 views • 8 months ago
4:08
WRAPROWS & WRAPCOLS -You Will Love Them!!!
Alejandra Horvath
387 views • 8 months ago
9:25
SEQUENCE, VSTACK, INDEX, COUNTA - Split Info From 1 Column Into 2
Alejandra Horvath
395 views • 10 months ago
10:44
Split information from 1 column into 2 with List.Alternate
Alejandra Horvath
970 views • 10 months ago
7:00
Forget the Hard-Coded Column Names - Change Data Type To All Columns In a Table
Alejandra Horvath
1.3K views • 10 months ago
1:08:17
How I Automate My Bank Reconciliations With Power Query
Alejandra Horvath
3.9K views • 1 year ago
5:29
Several Reports - One Source Of Data - #PowerQuery
Alejandra Horvath
333 views • 1 year ago
14:33
Table.Split and Table.SplitAt - Power Query
Alejandra Horvath
6.6K views • 1 year ago
2:00
Split Text By Rows With Power Query
Alejandra Horvath
411 views • 1 year ago
Load More