Wisdom by Data

2.55K subscribers

139 videos

Hello there 👋! I'm Mehran — a data and Excel professional dedicated to helping you build real-world skills in Excel, Power BI, SQL, and data storytelling. Wh...

Latest Videos

How to Use Fuzzy Lookup in Excel – Fix Messy Data & Match Similar Names (Real Example)

How to Install FUZZY LOOKUP in Excel

Copy Folder Names to Excel (Windows CMD Trick)

Paste Into Visible Cells ONLY in Excel (Using VLOOKUP + SUBTOTAL)

Assign RANDOM Groups in Excel (WRAPROWS + RAND Formula Trick)

How to Mask SENSITIVE DATA in EXCEL in Seconds (Simple Formula Trick)

Extract QUARTER from a DATE in Excel (No Nested IFs!)

Excel Formula to Auto-Mark Completed Months

How to HIGHLIGHT the ACTIVE ROW in Microsoft Excel

Extract TEXT Before or After NUMBERS in Excel REGEX Formula

Everything’s a Pyramid — The MLM Argument That Falls Apart

How to Create BARCODES in Excel (Scannable & FREE)

Excel VBA AutoFill Formula LEFT to RIGHT Fill Formulas Horizontally

How to AUTOFIT Column Width in Excel Using VBA

REAL SQL Interview Question Data Analyst, Data Engineer & BI Roles

Excel Change Text Case Upper, Lower & Title Case (With or Without Formula)

Count WORKING DAYS Between TWO Dates in Excel EXCLUDING Weekends & Holidays

Build a PROGRESS BAR in Excel - Using a Simple FORMULA

If an MLM Has to Say “WE’RE NOT A SCAM,” Something’s WRONG!

EXCEL Auto-BORDERS Cells Add BORDERS Automatically (NO VBA)

Simulate Your Home’s FUTURE Value in Excel - Run 10,000 SIMULATIONS in Seconds

Why You CAN’T Delete BLANK Rows in Excel — And How to FIX It

MLM (Network Marketing) Will Saturate— Here’s Why You Can’t Disprove It!

HOW to COUNT UNIQUE Products Sold the Previous Day in Excel (ROWS • UNIQUE • FILTER)

How to Combine SUMIF and VLOOKUP in Excel Without Getting NIL or 0

How To SPOT A PYRAMID SCHEME Why 99% LOSE MONEY

How to Show ZEROS But Hide BLANKS in Excel Chart Labels

My $100K EXCEL Freelancer Journey - 3 Life Lessons + 3 Tips For You

CREATE a Scrollable EXCEL CHART with AUTOMATIC Data Updates

How to PASTE ONLY Into VISIBLE CELLS Using INDEX MATCH When You Have HIDDEN Rows In Excel