Kenji Explains

@UCkHdBeQ4DuvBXTahMYZVlMA - 883K subscribers

🧑‍💻 Explaining the data, business, and finance concepts I wish I had known earlier! 📚 Check out my courses if you want to learn more: careerprinciples.com ✌️Have a great day!

Home Videos Live Playlists

Create Clickable Tabs Inside an Excel Sheet

Create Clickable Tabs Inside an Excel Sheet Kenji Explains

8.4K views - 9 hours ago

Stop Copy Pasting Into Excel! Try the NEW Import Functions Instead

Stop Copy Pasting Into Excel! Try the NEW Import Functions Instead Kenji Explains

11.8K views - 1 week ago

NEW Claude in Excel: How Good Is It?

NEW Claude in Excel: How Good Is It? Kenji Explains

86.8K views - 2 weeks ago

Make the Ultimate Personal Finance Tracker in Excel (+ Free Template)

Make the Ultimate Personal Finance Tracker in Excel (+ Free Template) Kenji Explains

20K views - 3 weeks ago

Create an Employee Work Schedule Tracker in Excel

Create an Employee Work Schedule Tracker in Excel Kenji Explains

13.8K views - 4 weeks ago

Stop Selecting Cells Manually in Excel. Try This Instead!

Stop Selecting Cells Manually in Excel. Try This Instead! Kenji Explains

15.8K views - 1 month ago

Create a Dynamic Calendar From a List of Events in Excel

Create a Dynamic Calendar From a List of Events in Excel Kenji Explains

74.6K views - 2 months ago

Stop Using Long Formulas: Try '*' and '?' Instead

Stop Using Long Formulas: Try '*' and '?' Instead Kenji Explains

61K views - 2 months ago

How Modern Analysts Actually Use Excel (10 Key Skills)

How Modern Analysts Actually Use Excel (10 Key Skills) Kenji Explains

52.9K views - 2 months ago

Double Dash: The Secret to Smarter Excel Formulas

Double Dash: The Secret to Smarter Excel Formulas Kenji Explains

190.2K views - 2 months ago

Stop Making Charts Like a Beginner! Learn These Advanced Excel Visuals Instead

Stop Making Charts Like a Beginner! Learn These Advanced Excel Visuals Instead Kenji Explains

20.7K views - 2 months ago

8 Exciting NEW Excel Features for 2026 | Do you know them?

8 Exciting NEW Excel Features for 2026 | Do you know them? Kenji Explains

38.5K views - 3 months ago

Everything you can do with Excel's Magic Button

Everything you can do with Excel's Magic Button Kenji Explains

22K views - 3 months ago

Stop Ignoring REGEX: Every Analyst Should Know This Feature

Stop Ignoring REGEX: Every Analyst Should Know This Feature Kenji Explains

29.5K views - 3 months ago

SCAN Function in Excel (One of the Hardest to Learn)

SCAN Function in Excel (One of the Hardest to Learn) Kenji Explains

46.4K views - 3 months ago

I Tried Excel’s New Clean Data Button—Here’s What Happened

I Tried Excel’s New Clean Data Button—Here’s What Happened Kenji Explains

38.1K views - 4 months ago

Excel's NEW AI Agent Mode Changes Everything

Excel's NEW AI Agent Mode Changes Everything Kenji Explains

37.9K views - 4 months ago

Make a Dynamic Task Management Tracker in Excel!

Make a Dynamic Task Management Tracker in Excel! Kenji Explains

195.4K views - 4 months ago

How to Pull Data From Another Sheet Based on Criteria

How to Pull Data From Another Sheet Based on Criteria Kenji Explains

73.1K views - 4 months ago

10 MUST-KNOW Excel Interview Questions

10 MUST-KNOW Excel Interview Questions Kenji Explains

28.6K views - 5 months ago

Learn Financial Modeling Essentials in Excel (FREE Crash Course)

Learn Financial Modeling Essentials in Excel (FREE Crash Course) Kenji Explains

50.3K views - 5 months ago

This Hidden AI Tool Analyzes Financial Statements in Seconds

This Hidden AI Tool Analyzes Financial Statements in Seconds Kenji Explains

20.2K views - 5 months ago

Stop Overcomplicating Excel Formulas: Just Use the Dot

Stop Overcomplicating Excel Formulas: Just Use the Dot Kenji Explains

399.1K views - 5 months ago

Excel's New =COPILOT() Function Will Blow Your Mind!

Excel's New =COPILOT() Function Will Blow Your Mind! Kenji Explains

171.5K views - 5 months ago

Make a Risk Assessment Matrix in Excel

Make a Risk Assessment Matrix in Excel Kenji Explains

57.1K views - 6 months ago

Best AI Tools Every Data Analyst Should Know in 2026

Best AI Tools Every Data Analyst Should Know in 2026 Kenji Explains

74.8K views - 6 months ago

Make a Multi-Step User Form in Excel

Make a Multi-Step User Form in Excel Kenji Explains

51.4K views - 6 months ago

10 Advanced Pivot Table Tricks to Make you an Excel PRO

10 Advanced Pivot Table Tricks to Make you an Excel PRO Kenji Explains

116K views - 6 months ago

How to SUM & COUNT Cells By Color in Excel

How to SUM & COUNT Cells By Color in Excel Kenji Explains

94.7K views - 7 months ago

8 NEW Excel Features That Will Blow Your Mind!

8 NEW Excel Features That Will Blow Your Mind! Kenji Explains

150.1K views - 7 months ago

10 Excel Functions You Need to Know (According to Harvard)

10 Excel Functions You Need to Know (According to Harvard) Kenji Explains

43.6K views - 7 months ago

How to Extract Any Part of Cell in Excel

How to Extract Any Part of Cell in Excel Kenji Explains

36.1K views - 7 months ago

Make a Custom Sidebar in Excel

Make a Custom Sidebar in Excel Kenji Explains

467.4K views - 7 months ago

Is Copilot in Excel Actually Useful? My Honest Thoughts

Is Copilot in Excel Actually Useful? My Honest Thoughts Kenji Explains

34.1K views - 8 months ago

Can You Pass This REAL Finance Interview Test?

Can You Pass This REAL Finance Interview Test? Kenji Explains

36.1K views - 8 months ago

Make Excel Formulas Flexible with the "&" Sign

Make Excel Formulas Flexible with the "&" Sign Kenji Explains

84.7K views - 8 months ago

Still Using Excel for Visuals? Try This New Tool Instead

Still Using Excel for Visuals? Try This New Tool Instead Kenji Explains

83.4K views - 8 months ago

What's your Excel Level? Find Our With This Test

What's your Excel Level? Find Our With This Test Kenji Explains

20.1K views - 8 months ago

Database Normalization: The One Skill Analysts Often Overlook

Database Normalization: The One Skill Analysts Often Overlook Kenji Explains

18.8K views - 9 months ago

5 Excel Formatting Mistakes You Need to Avoid (And How to Fix Them)

5 Excel Formatting Mistakes You Need to Avoid (And How to Fix Them) Kenji Explains

42.3K views - 9 months ago

Create Dashboards in Seconds With AI (It's Mind-Blowing 🤩)

Create Dashboards in Seconds With AI (It's Mind-Blowing 🤩) Kenji Explains

156.1K views - 9 months ago

Use Power Pivot to 10x Your Pivot Tables

Use Power Pivot to 10x Your Pivot Tables Kenji Explains

29.9K views - 9 months ago

How to Pick the Perfect Excel Formula Every Time

How to Pick the Perfect Excel Formula Every Time Kenji Explains

28.2K views - 10 months ago

Master the New GROUPBY & PIVOTBY Functions in Excel

Master the New GROUPBY & PIVOTBY Functions in Excel Kenji Explains

41K views - 10 months ago

SUBTOTAL: The Excel Function You Didn’t Know You Needed!

SUBTOTAL: The Excel Function You Didn’t Know You Needed! Kenji Explains

24.7K views - 10 months ago

Learn Python Basics in Just 20 Minutes!

Learn Python Basics in Just 20 Minutes! Kenji Explains

26K views - 10 months ago

Use Excel Tables to EASILY Save Hours of Time

Use Excel Tables to EASILY Save Hours of Time Kenji Explains

68.3K views - 11 months ago

Return Multiple Matching Results in Excel –What XLOOKUP Can't Do!

Return Multiple Matching Results in Excel –What XLOOKUP Can't Do! Kenji Explains

59K views - 11 months ago

Try DSUM Instead of Filtering in Excel

Try DSUM Instead of Filtering in Excel Kenji Explains

87.3K views - 11 months ago

Make an Advanced Data Entry Form in Excel (Fully Automated)

Make an Advanced Data Entry Form in Excel (Fully Automated) Kenji Explains

99.4K views - 11 months ago

Automate Copy-Pasting in Excel With This Simple Trick

Automate Copy-Pasting in Excel With This Simple Trick Kenji Explains

83.8K views - 1 year ago

Make Awesome Wall Street Journal Charts in Excel

Make Awesome Wall Street Journal Charts in Excel Kenji Explains

24.1K views - 1 year ago

Learn 80% of Data Analysis in Excel in Just 12 Minutes

Learn 80% of Data Analysis in Excel in Just 12 Minutes Kenji Explains

160.9K views - 1 year ago

Data Cleaning With Power Query (Better than Excel)

Data Cleaning With Power Query (Better than Excel) Kenji Explains

62.7K views - 1 year ago

Set Up Automatic Deadline Alerts & Popups in Excel

Set Up Automatic Deadline Alerts & Popups in Excel Kenji Explains

77.4K views - 1 year ago

Get Ahead in 2026 With These Underrated Excel Functions

Get Ahead in 2026 With These Underrated Excel Functions Kenji Explains

69.7K views - 1 year ago

How to Get FREE Real-World Datasets for Practice

How to Get FREE Real-World Datasets for Practice Kenji Explains

23.8K views - 1 year ago

Simplify ANY Excel Formula With LAMBDA

Simplify ANY Excel Formula With LAMBDA Kenji Explains

84.8K views - 1 year ago

Try The SWITCH Function Instead of IF Statements

Try The SWITCH Function Instead of IF Statements Kenji Explains

149.4K views - 1 year ago

Change These 10 Settings Before You Use Excel Again

Change These 10 Settings Before You Use Excel Again Kenji Explains

236K views - 1 year ago