Make Your Excel Sheets "Idiot-Proof" (Data Validation Basics)

Command Prompt vs. Power Query: Best Way to List Files in Excel?

Block Duplicates In Excel Automatically

Make Your Excel Tables Searchable (Dynamic Dropdown Trick)

Stop Making Messy Charts in Excel: The Perfect Over/Under Method

ABC Analysis Made Easy in Excel (Formulas vs. Power Query)

How to Color Code Positive vs Negative Numbers in Excel

Smarter Excel Searches: XLOOKUP Wildcard Trick

Power Query Trick: Calculate Days, Months, or Years Between Dates

Stop Dirty Data! Error Handling in Excel & Power Query M Code

Excel Fractions Made Simple: From Confusing to Clear

Did You Know XLOOKUP Can Do THIS? (The Hidden Regex Trick)

Excel Magic: How to Extract Emails, Names, and Filenames in Seconds

Never Guess Your Hours Again (Simple Excel Timesheet)

Insert Pictures into Excel Cells (Easy Excel Hacks)

Excel Language Hacks: DETECTLANGUAGE + TRANSLATE Explained

Stop Fixing Excel Data Manually! Use This Trim Function Instead

Save Time in Excel with BYROW & BYCOL

How to Break Apart Upper & Lower Case Text with Power Query

Duplicate & Customize Tables Across Worksheets in Seconds

Power Query Row Count Tricks You Should Know

How to Use REGEX in Excel (Complete Guide for Smarter Data!)

Control Multiple Pivot Tables with One Slicer in Excel

How to Delete Specific Characters in Power Query

Excel + M365 Copilot: First Impressions You NEED to See

Stop Using INDEX MATCH! Try This Two-Way XLOOKUP Trick Instead

Use This Excel Percent Trick to Save Time (PERCENTOF Guide)

How to Use NETWORKDAYS.INTL with Custom Holidays in Excel (Even the Weird Ones)

Excel Trick: Show Different Colors for Positive & Negative Values

Make Your Spreadsheets Interactive: Add Checkboxes for Users

Is the EXPAND Function Even Useful? Let’s Find Out!

How to Find Every Formula Cell in Excel – Quick & Simple

How to Use DROP & TAKE in Excel – Quick & Easy Guide

How to Parse XML Files Easily Using Power Query

How to Use a Correlation Heatmap to Uncover Powerful Data Insights

How to Restrict Text Case in Excel and Prevent Mistakes!

How to Add Comments for Cell Input Reminders: Two Practical Examples

How to Perform a Two-Way Lookup in Excel: Streamline Your Workflow + Bonus Tip

How to Rename Multiple Columns in Excel FAST | Time-Saving Spreadsheet Hacks

Excel Data Validation: Add Search Functionality with 3 Examples

Excel Pro Tip: Reveal Runner-Up Numbers in Seconds

Beyond Pivot Tables: Harness Excel's Powerful GROUPBY Function

PIVOTBY Simplified: The New Way to Create Pivot Tables

Quick and Easy Lookups with XMATCH: A Beginner’s Guide

Aggregate Multiple Values at Once: Sum, Average, and More in One Go!

How to Create Power Apps Cascading Dropdowns with Hyperlinks from SharePoint List

Power Apps Cascading Dropdown Hyperlink from Excel

Boost Your Excel Skills: CHOOSECOLS and CHOOSEROWS Functions Explained

Step-by-Step Guide to Power Apps Cascading Dropdowns and Hyperlinks

Beyond Data Entry: Image to Excel Table Conversion Techniques

Unlocking Stock Secrets: Excel's Hidden Features for Stock Research

Compound Interest Made Easy with Excel

S1E9 Dropdown List

S1E8 CONCAT

S1E7 Text Column

S1E6 Flash Fill

S1E5 Scatter Chart

S1E4 XLOOKUP

S1E3-VLOOKUP

S1E2-Table List