Table From List - Double List Numbers
Hide Objects
Ctrl + Enter
Ctrl + * / Ctrl .
Insert and Remove Rows or Columns Shortcuts
Ctrl R & Ctrl D
Chart In Seconds
Group/Ungroup Columns and Rows
Split Columns With Power Query
Drag & Fill
VSTACK Several Sheets
#PowerQuery #Table.FromList #ListOfLists #Numbers #PowerQueyGirl #AlejandraHorvath #Empowered2xl
TableFromList, or TableFromColumns( ) when working with numbers #PowerQuery
=GROUPBY( ) 💚 Easier & Faster #MSExcel #GroupBy #QuickTips #Empowered2XL #AlejandraHorvath #Shorts
#Flashfill #AlejandraHorvath #Empowered2XL #Tutorial #MSExcel
Filter With Wildcard #excel #tutorial
AutoSum - #Shorts
Convert a Value To Text In a Specific Number Format - #Shorts
Format Tables On Different Sheets In Seconds - #Shorts
Duplicate vs Reference A Query - #Shorts
Split Text To Columns With =TEXTSPLIT( ) - #Shorts
How To Get Data From Pdf, Using Power Query #Shorts
Fill Blank Cells In No Time! - #Shorts
Remove Blank Rows In Seconds!!! - Shorts
eMail Addresses In Seconds - Flash Fill #Shorts
Power Query - Functions - Allow nulls #Shorts
Power Query - Functions - Be more specific #Shorts
Power Query - Basic Function #Shorts
Add/Deduct full month(s) from a date - #Shorts
Get only the digits you need with =TRUNC( ) - #Shorts
Unique Random Numbers - #Shorts
Quick Tips - Shortcuts To Hide/Unhide Rows & Columns #Shorts
Quick Tips - Fill Series Range #Shorts
Quick Tips - Merge Center Across Section #Shorts
Quick Tips - Fill Justify #Shorts
Quick Tips - Add a pic to your notes #Shorts
Quick Tips - Power Query Split Into Rows #Shorts
Quick Tips - Copy Format #Shorts
Quick Tips - Formating #Shorts
Quick Tips - Transpose #Shorts
Quick Tips - Line Break #Shorts
Quick Tips - Dynamic Arrays #Shorts
Quick Tips - Paste as Values #Shorts
Quick Tips - Quick Analysis #Shorts
Quick Tips - Rows & Columns #Shorts
Quick Tips -Control Enter #Shorts
Quick Tips - Sparklines #Shorts
Number Currency Percentage Format #Shorts
X
About
Excel y Power Query.
My channel in Spanish: youtube.com/@alejandrahorvathenespañol
18 April 2021
Tags