6 тысяч подписчиков
84 видео
Power BI - NEW Visual Slicer & Visual Cards
Microsoft Excel - Absolute Structured References
Microsoft Excel - Extract Data from Picture
Microsoft Excel - Show Missing Items in a Pivot Table
Microsoft Excel - Error Checking Dependent Dropdown Lists
Microsoft Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)
Power Query - Query Folding (The key to faster query execution)
Microsoft Excel - Intersection Operator
Microsoft Excel - Image Function - Perform an Image Lookup
VBA - Personal Macro Workbook (in Excel)
Microsoft Word - Mail Merge Letters, Envelopes, and Labels
Microsoft Excel - 16 Features in 1 Project (Improving the User Experience)
Microsoft Excel - Dynamic QR Codes from a User Selection
Microsoft Excel - Password to Open Specific Sheets
Power Query - Alternate Group By Strategies
Microsoft Word - Multilevel Lists (Outlines) - Comprehensive Guide
Power Query - Split Text into Rows (the 3 Delimiter Problem)
Microsoft Excel - 1 to Many: Dependent Dropdown List
Microsoft Outlook - Automatic ("Out of Office") Replies - More Features Than You Realize
Microsoft Excel - Dynamic Structured References
Power Query - Faster & Easier Parameters
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
DAX - Implicit vs Explicit Measures
Microsoft Excel - Zero Click Search & Filter Results
Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)
Microsoft Excel - Prevent Duplicate Entries in Table Columns (plus VBA Automation)
Microsoft Excel - Change New Workbook Defaults
Microsoft Excel - Show Values As (Extra Calculations for Pivot Tables)
Microsoft Office - Quick Access Toolbar
Microsoft Excel - Email Sheet in a Single Click
Microsoft Outlook - 1 Click Email Response (Templates)
Microsoft Excel - Hide Pivot Table Filters Without Hiding Headings
Microsoft Excel - Limited Scroll List (with VBA Trick-shot)
VBA - Excel "Conditional Formatting" for Sheet Tabs
Power Query - Create Custom Function Documentation
Power BI - Edit Interactions
Power Query - Pivoting Stacked Data
Microsoft Word - Find Replace Font Replacement Trick
Power BI - Zero Filled Matrix (plus: Conditional Formatting trick)
Power BI - Hyperlinked Email Addresses
Power Query - Reorder Column(s) by Position
Power Query - Clean & Trim EVERYTHING at Once... Dynamically
Power Query - Rename Column by Position
Power Query - 7 Methods to Get Data From Excel Files
Power Query - Import Fixed Width (Delimited) Files
Microsoft Excel - Overcoming "Static" Conditional Formatting
Microsoft Excel - GROUPBY Function Automatic Color Formatting
Power BI - Custom Layouts for Data Models
Microsoft Office - 3D Models
Power Query - Dynamic Column Selection
