Все публикации

Power Query - The Excel Connector 'Corrupts' Numbers (v2)

Microsoft Windows - Hide / Unhide Unneeded Drives

Power Query - Sum Last N Columns

Power Query - Dynamic Range Detection

Microsoft Excel - Select All Checkbox (Creating a Missing Feature)

100 Videos - Thank You!!!

Power Query - Extract PDF Tables by the Table's Content

Microsoft Excel - Function Slicers (slice ANYTHING)

Microsoft Excel - 19 Features or Pranks (You Decide)

Power Query - Pivoting Stacked Data

Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)

Microsoft Excel - Format Stale Values (Upcoming Feature)

Power BI - Q&A Visual (the key to faster, easier visual building)

Microsoft Excel - Waterfall Charts (Better Storytelling)

Power BI - Edit Interactions

Microsoft Excel - GETPIVOTDATA Function

Power Query - Exact Match Lookups (1 Goal; 3 Methods)

VBA - Save Selected Sheets as Separate Files

Power BI - Faster Slicer Refresh Using the 'Apply All Slicers' Feature

Microsoft Excel - Limited Scroll List (with VBA Trick-shot)

Microsoft Excel - Calculate Ratios (4 Methods)

Power Query - Query Folding (The key to faster query execution)

Microsoft PowerPoint - Slide Masters (The Greatest Time Saver)

Power BI - Custom Layouts for Data Models