Home
Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)
BCTI
Apr 29, 2024
4,178 views
Power Query - Import Fixed Width (Delimited) Files
Power Query - Query Folding (The key to faster query execution)
Power Query - Dynamic Column Selection
SWITCH Function in Power Query
Return Multiple Values with Single Xlookup Statement
Power Query - Faster & Easier Parameters
I Bet You Don't Know All These Power Query Tricks
Power Query - Data from Email Attachment
Advanced Grouping Tricks In Power Query
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
Power Query - Alternate Group By Strategies
Power Query - List.Buffer to do a Million row Lookup
Microsoft Excel - 1 to Many: Dependent Dropdown List
List.Accumulate Case Study in Power Query
Microsoft PowerPoint - Slide Masters (The Greatest Time Saver)
Power Query - Parameters with Error Checking (with bonus tip)
Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid
Make Queries Unbreakable : 5 Powerful Hacks | Power Query Tricks