15:33

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

10:12

Power Query - Dynamic Column Selection

12:06

PowerPoint - Slide Masters (The Greatest Time Saver)

06:54

Power BI - Custom Layouts for Data Models

08:03

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 Addressses

15:08

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

19:11

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

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

18:00

Excel - Overcoming "Static" Conditional Formatting

06:45

Excel - Error Checking Dependent Dropdown Lists

07:34

Excel - 1 to Many: Dependent Dropdown List

10:55

Outlook - 1 Click Email Response (Templates)

08:15

VBA - Personal Macro Workbook (in Excel)

05:55

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

Excel - GROUPBY Function Automatic Color Formatting

10:20

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

04:28

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

09:28

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

07:26

Excel - Sort Sheets Alphabetically

11:49

DAX - Implicit vs Explicit Measures

05:26

Excel - Image Function - Perform an Image Lookup

03:13

Excel - Hide Formulas

05:48

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)

14:27

Excel - Password to Open Specific Sheets

09:27

Excel - Show Missing Items in a Pivot Table

06:23

Excel - Allow Edit Ranges

06:33

Excel - "Smart" Sheet Names (I bet you've never seen this before)

06:35

Excel - Change New Workbook Defaults

07:28

Excel - Dynamic Structured References

05:55

Word - Changing New Document Defaults

11:49

Excel - Zero Click Search & Filter Results

06:02

Excel - Email Sheet in a Single Click

07:15

Excel - Hide Pivot Table Filters Without Hiding Headings

04:51

Excel - Absolute Structured References

18:20

Microsoft Word - Mail Merge Letters, Envelopes, and Labels

09:45

Excel - Relative Named Ranges

18:38

Excel - Password Complexity Check (Super Tool)

20:42

Excel's New GROUPBY Function (w/ Bonus Features)

10:42

Power BI - NEW Visual Slicer & Visual Cards

12:23

Power Query - Parameters with Error Checking (with bonus tip)

09:24

Excel - NEW & Modern Checkboxes

03:30

Excel - Create Shorter Formulas

13:38

Power Query - Faster & Easier Parameters

07:09

Microsoft Word - Watermarks

06:35

Excel - Custom Views (with Cool Macro Trick)

07:31

Power Query - Rename Column by Position

07:41

Microsoft Office - 3D Models

05:31

Excel - Customize Formula Bar