25 тысяч подписчиков
230 видео
Simple Table Normalization - Power Query Challenge 34
All-New TRANSLATE Function: Excel 365 Insider Tips
Transform Columns All at Once in Power Query: Ultimate Tutorial
Power Query Hack: Add Multiple Columns with One Easy Step!
How to Calculate a Weighted Average in Excel
Merge Tables by Partial Value Matches - Power Query Challenge 33
Power Query Trick: Combine Inconsistent Files Like a Pro
Ultimate Guide to Excel Text Conversion: TEXT, VALUE, and More
Stop Using Generic Step Names! Power Query Tips for Clearer Code
List.TransformMany: Generating Combinations - Power Query Challenge 32
Excel Text Replacement: Master REPLACE & SUBSTITUTE
Create Fixed-Length IDs - Power Query Challenge 31
How to Superscript and Subscript Text in Excel
Extract Emails from Any Text: Excel Advanced Guide
How to Calculate Weighted Averages in Excel
How to Assign a VBA Macro to a Button in Excel
Sum ranges quickly using Ctrl and AutoSum - Excel Shortcut
How to Calculate Attendance Percentage: Excel Calculations
Flash Fill Example: Extract Names from Emails in Excel
Auto Refresh Pivot Table Data When the Excel File Is Opened
Excel Data Validation 101: A Comprehensive Beginner’s Guide
Excel if function | Excel if formula | Excel if formulas and functions | Excel if statements
Remove Empty Columns - Power Query Challenge 07
How Power Query Helped Me Catch a Costly Mistake
How to Remove Duplicates: Data Cleaning Excel Guide
Running Totals with a Condition - Power Query Challenge 48
REGEXEXTRACT Function in Excel: Extract Emails from Any Text
How to Parse HTML-Like Text into a Table - Power Query Challenge 79
Multiple Filters in a Pivot Table Field
How to Sum TOP N Values: SEQUENCE Excel Dynamic Array Formulas
Power Query: The Relative Path Hack You Didn't Know About
Excel Transpose Function: How to Switch Rows and Columns
How to Find and Replace Text: Data Cleaning Excel Guide
LEFT, RIGHT, MID - Text Extraction Functions: Excel Basics Tutorial
How to Filter Data with Dynamic Array Function: Excel Guide
Fix Misaligned Rows Like a PRO! - Power Query Challenge 99
Add Images to Your VBA UserForm in Excel - Quick Tutorial
Mastering Pivot Tables With Calculated Fields Made Easy
Filter by a List in Power Query: 4 Methods Every Analyst Should Know
How to Separate Values: Data Cleaning Excel Guide
Remove Duplicates Across Columns in Excel | Power Query Challenge 94
How to Sum Values Ignoring Errors: AGGREGATE Function
Paste Special - Add Values - Excel Tip
10 Excel Settings YOU NEED TO KNOW
How to Calculate Mean, Median and Mode in Excel - AWESOME Guide
Excel Charts 101: Best Practices for Clean and Effective Charts
How to Import data from a folder with multiple files - Power Query
How to Enable the Developer Tab in Excel for Windows
Reshape Rows into Columns - Power Query Challenge 51
How to Unmerge Cells: Data Cleaning Excel Guide
How to Change AutoSave Time in Microsoft Excel - Quick Guide
Excel HSTACK & VSTACK Made Simple (You’ll Never Go Back)
How to Create a Spin Button | Interactive Filter
Stack Multiple Columns into One in Power Query (2 Easy Methods!)
Need All Dates Between Two Dates Power Query Has the Answer!
How to Split Columns Like a Pro in Seconds! - Power Query Challenge 67
Zero, Blank, Null: A Comprehensive Guide for Power Query Users
Split Text by Line Break Like a Pro! - Power Query Challenge 75
How to Split Text-to-Columns: Data Cleaning Excel Guide
Multiple Header Rows: Power Query Data Transformation Guide
Excel Dates Not Grouping? Try This!
