08:43

Power Query - Clean & Trim EVERYTHING at Once... Dynamically

19:18

Microsoft Word - Section Breaks

09:09

Microsoft Excel - Creating Distinct, Unique, and Repeated Lists

16:03

Power Query - Unlimited Formulas in 1 Step

07:40

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

08:06

Microsoft Windows - Hide / Unhide Unneeded Drives

15:59

Power Query - Sum Last N Columns

06:00

Power Query - Dynamic Range Detection

07:01

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

01:14

100 Videos - Thank You!!!

15:37

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

27:07

Microsoft Excel - Function Slicers (slice ANYTHING)

23:59

Microsoft Excel - 19 Features or Pranks (You Decide)

09:09

Power Query - Pivoting Stacked Data

13:53

Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)

04:35

Microsoft Excel - Format Stale Values (Upcoming Feature)

12:58

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

09:19

Microsoft Excel - Waterfall Charts (Better Storytelling)

06:41

Power BI - Edit Interactions

11:26

Microsoft Excel - GETPIVOTDATA Function

11:39

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

11:04

VBA - Save Selected Sheets as Separate Files

10:37

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

25:30

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

09:35

Microsoft Excel - Calculate Ratios (4 Methods)

15:33

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

10:12

Power Query - Dynamic Column Selection

12:06

Microsoft PowerPoint - Slide Masters (The Greatest Time Saver)

06:54

Power BI - Custom Layouts for Data Models

08:03

Microsoft Excel - Dynamic QR Codes from a User Selection

11:14

Power BI - 1-Click Complete Emails (with Dynamic Content)

07:52

Power BI - Hyperlinked Email Addresses

15:08

Microsoft Excel - GroupBy with Multiple Aggregations (plus, Dynamic User Selection)

19:11

Microsoft Excel - Custom Chart Label Ranges (with User Switching)

22:19

Power Query - Get Top N by Group

19:03

Power BI - Custom Fiscal Calendars (plus cool formatting tricks)

11:45

Power Query - Data from Email Attachment

05:00

Power BI - Clear File History

28:34

Microsoft Excel - 16 Features in 1 Project (Improving the User Experience)

18:00

Microsoft Excel - Overcoming "Static" Conditional Formatting

06:45

Microsoft Excel - Error Checking Dependent Dropdown Lists

07:34

Microsoft Excel - 1 to Many: Dependent Dropdown List

10:55

Microsoft Outlook - 1 Click Email Response (Templates)

08:15

VBA - Personal Macro Workbook (in Excel)

05:55

Microsoft Excel - New REGEX Functions are Amazing!

12:29

Power Query - Alternate Group By Strategies

04:17

Power Query - Import Fixed Width (Delimited) Files

10:06

Microsoft Excel - GROUPBY Function Automatic Color Formatting

10:20

Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)

04:28

Microsoft Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)

09:28

Microsoft Word - Revealing the Mystery of the "Hidden" Text Option

07:26

Microsoft Excel - Sort Sheets Alphabetically

11:49

DAX - Implicit vs Explicit Measures

05:26

Microsoft Excel - Image Function - Perform an Image Lookup

03:13

Microsoft Excel - Hide Formulas

05:48

Microsoft Excel Modes - Solve a MAJOR frustration when updating formulas

06:08

Power BI - Zero Filled Matrix (plus: Conditional Formatting trick)

06:10

Microsoft Word - Text Wrapping (Get the perfect flow)

09:47

Power Query - Rounds Differently than Excel (DANGER)

18:40

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)