Focusing on tips, tricks, new, and lesser-known (yet powerful) features of Microsoft Office applications (Excel, Word, Outlook, PowerPoint) as well as data cleansing using Power Query and data visualization using Power BI.

Microsoft Excel - Building a Multi-Language Image Query
15:44
Microsoft Excel - Building a Multi-Language Image Query
Microsoft Outlook - Recover Twice Deleted Emails (and other Outlook items)
3:25
Microsoft Outlook - Recover Twice Deleted Emails (and other Outlook items)
Microsoft Excel - Fill Across Worksheets (plus cool paste tricks)
10:30
Microsoft Excel - Fill Across Worksheets (plus cool paste tricks)
Power Query - Split Text into Rows (the 3 Delimiter Problem)
6:31
Power Query - Split Text into Rows (the 3 Delimiter Problem)
Power BI - Custom Tooltips (Complete Guide)
12:08
Power BI - Custom Tooltips (Complete Guide)
Microsoft PowerPoint - Sections (3 Features in 1 Tool to Manage Slides)
9:19
Microsoft PowerPoint - Sections (3 Features in 1 Tool to Manage Slides)
Microsoft Word - The Amazing Ruler That Microsoft Hid Away
12:59
Microsoft Word - The Amazing Ruler That Microsoft Hid Away
Microsoft Excel - Reduce File Size by 99% When Working With Pivot Tables
7:14
Microsoft Excel - Reduce File Size by 99% When Working With Pivot Tables
Power Query - Get Data (PREVIEW Feature)
1:55
Power Query - Get Data (PREVIEW Feature)
Power Query - Create Custom Function Documentation
10:58
Power Query - Create Custom Function Documentation
Microsoft Excel - Paste Without Conditional Formatting Rules
3:32
Microsoft Excel - Paste Without Conditional Formatting Rules
Power Query - Create a Super TRIM Function (plus cool trick)
17:22
Power Query - Create a Super TRIM Function (plus cool trick)
Microsoft Excel - Return Entire Record
9:38
Microsoft Excel - Return Entire Record
Power Query - Reorder Column(s) by Position
7:35
Power Query - Reorder Column(s) by Position
Power Query - Clean & Trim EVERYTHING at Once... Dynamically
8:43
Power Query - Clean & Trim EVERYTHING at Once... Dynamically
Microsoft Word - Section Breaks
19:18
Microsoft Word - Section Breaks
Microsoft Excel - Creating Distinct, Unique, and Repeated Lists
9:09
Microsoft Excel - Creating Distinct, Unique, and Repeated Lists
Power Query - Unlimited Formulas in 1 Step
16:03
Power Query - Unlimited Formulas in 1 Step
Power Query - The Excel Connector Corrupts Numbers (v2)
7:40
Power Query - The Excel Connector Corrupts Numbers (v2)
Microsoft Windows - Hide / Unhide Unneeded Drives
8:06
Microsoft Windows - Hide / Unhide Unneeded Drives
Power Query - Sum Last N Columns
15:59
Power Query - Sum Last N Columns
Power Query - Dynamic Range Detection
6:00
Power Query - Dynamic Range Detection
Microsoft Excel - Select All Checkbox (Creating a Missing Feature)
7:01
Microsoft Excel - Select All Checkbox (Creating a Missing Feature)
100 Videos - Thank You!!!
1:14
100 Videos - Thank You!!!
Power Query - Extract PDF Tables by the Table's Content
15:37
Power Query - Extract PDF Tables by the Table's Content
Microsoft Excel - Function Slicers (slice ANYTHING)
27:07
Microsoft Excel - Function Slicers (slice ANYTHING)
Microsoft Excel - 19 Features or Pranks (You Decide)
23:59
Microsoft Excel - 19 Features or Pranks (You Decide)
Power Query - Pivoting Stacked Data
9:09
Power Query - Pivoting Stacked Data
Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)
13:53
Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)
Microsoft Excel - Format Stale Values (Upcoming Feature)
4:35
Microsoft Excel - Format Stale Values (Upcoming Feature)