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

Are you creating the query in the same workbook? Do it fast and efficiently!

M - Lists Overview

Optimize Table.SelectRows for better results!

#Flashfill

Table.TransformRows or Table.TransformColumns

AGGREGATE - This Excel Function is a Real Treasure!

Easy Way To Dynamically Remove Empty Rows And Columns

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

How Table Schema can help you to select the columns to keep (or remove)

WRAPROWS & WRAPCOLS -You Will Love Them!!!

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

Improve query performance with List.Buffer - Power Query

ArrayFormula - Google Sheets

#Renaming

Dynamically Transform Data Type for All Columns with Table.TransformColumns

Solving "Formula.FireWall" - Saturday With Power Query

Duplicate vs Reference A Query -

Simple and easy transformations for a better analysis - Power Query

Adding the file name to nested tables

Replace Multiple Values With Power Query - Short Version

Several Reports - One Source Of Data -

Split and Flatten Functions - Google Sheets

Dynamically expanding specific columns & Optimizing code with nested let -

Replace Multiple Values With PQ -

How To Create A Custom Function That Updates As The Sample Query Updates

Consolidate PDF Files and Dynamically Remove Unwanted Top Lines With a Function