Alejandra Horvath

How amazing the IMAGE Function Is, When You Want To Insert Images In A Cell - #DailyExcelTips

How To Add Values In Seconds -

How I use =Take( ) in Excel - You will love this function!

How To Split a Text Using Power Query vs Function FILTERXML.

How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?

How I Dynamically Transform Column Names With Power Query

How To Trim Leading Zeros With Power Query -

Select Random Names From A List Using Power Query -

=Filter( ) in Excel - Here is what I DO and HOW!

Table.Split and Table.SplitAt - Power Query

How to be the hero at work with Power Query & Power Pivot

How I Calculate Running Totals, Using Power Query

Convert Text To Date And Group By Quarters - Power Query

Convert A Value To Text, In a Specific Format -

How I Bring Specific Columns From a Table - Advanced Filter And The FILTER Function

How I use the =DROP( ) function in Excel! - MS365

How I use Modulo & Integer-Divide In Nested Tables -

You Can Filter Several Columns At Once in Power Query!

How To Work With Double Headers - Power Query

How I Replace Special Characters In a Text

How I Group Data Into Ranges - Saturday With Power Query

Filter With Wildcard

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

How To Dynamically Remove Empty Columns in Power Query

Forget the Hard-Coded Column Names - Change Data Type To All Columns In a Table

Optimize Table.SelectRows for better results!

AGGREGATE - This Excel Function is a Real Treasure!

WRAPROWS & WRAPCOLS -You Will Love Them!!!

How amazing the IMAGE Function Is, When You Want To Insert Images In A Cell -

SEQUENCE, VSTACK, INDEX, COUNTA - Split Info From 1 Column Into 2

My Approach To The Convert Range of Values to a List Challenge - Saturday With Power Query

Session 3 - How I Automate My Work With Power Query

Select or Remove Columns Based on Their Position 🤯🤯🤯

M - Lists Overview

Table.TransformRows or Table.TransformColumns

Split Text By Rows With Power Query

Filtering By A List - Saturday With Power Query

#Flashfill

How To Dynamically Remove Text In Minutes With Power Query

Simple and easy transformations for a better analysis - Power Query

Replace Multiple Values With PQ -

How I Automate My Bank Reconciliations With Power Query

You Need To Know These Excel Tips!!!

Dynamically expanding specific columns & Optimizing code with nested let -

How To Get Data From Pdf, Using Power Query

Replace Multiple Values With Power Query - Short Version

Solving "Formula.FireWall" - Saturday With Power Query

How I Take 10 Rows From The Middle Of a Range Or a Table, with =TAKE( ) In Excel

Convert a Value To Text In a Specific Number Format -

PQ - How I Used Divide-Integer & Modulo To Transform My Files This Week

How I use WRAPROWS & WRAPCOLS -You Will Love Them!!!