Create Clickable Tabs Inside an Excel Sheet
How to create clickable tabs inside a single Excel sheet. Take our Data Analyst Program here: https://www.careerprinciples.com/care... š DOWNLOAD the Free Excel file and VBA code for this video: https://careerprinciples.myflodesk.co... in this video, I'll show you how to create tabs inside an Excel sheet that are fully clickable, change colors when selected, and the corresponding data updates automatically. This way you don't need to have dozens of worksheets; instead, have everything in one sheet with multiple tabs. For this, we'll be using shapes, named ranges, and the filter function to dynamically change the results when we click on a certain month. To tie this all together, we'll be using VBA code to create macros for each of the tabs. I'll also show you a no-code alternative using hyperlinks in Excel. LEARN: š Excel for Business & Finance Course: https://www.careerprinciples.com/cour... š The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour... š„ Power BI for Business Analytics: https://www.careerprinciples.com/cour... š All our courses: https://www.careerprinciples.com/all-... ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ā¬ Chapters: 0:00ā -ā Page Setup 2:52ā - Dynamic Formula 4:25ā - VBA Code Solution 7:30ā - Changing the Number of Tabs 9:30ā - Page Formatting 11:27ā - No-Code Alternative

Excel's Game-Changing 5 New Functions!

Make a Custom Sidebar in Excel

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

A Suitable Suitor | Excel Case Walkthrough | UK 026 Battle 4 (By Elliot Paterson)

Power BI Fuzzy Matching Explained: Automatically Fix Data Errors in Power Query

The Best Lookup Function Nobody Talks About... FILTER

Instant Focus Mode ā 40Hz Gamma Brainwave Music for Deep Focus & Productivity

Beautiful Relaxing Music - Stop Overthinking, Stress Relief Music, Sleep Music, Calming Music #177

Create a Dynamic Search Bar in Excel | Find Anything Instantly (No VBA!)

Learn To See What God Sees When He Looks At You

How to Start Coding | Programming for Beginners | Learn Coding | Intellipaat

I don't use Pivot Tables in Excel anymore, I do this instead

7 Hidden Excel Buttons Make Your Spreadsheets 10X EASIER

The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)

Beautiful Relaxing Music - Stop Overthinking, Stress Relief Music, Sleep Music, Calming Music #242

Free Event: Power BI Beginner to Pro 2026 Edition - Full Hands-On Tutorial

Trump Booed & Embarrassed at World Cup Final, Election Speech Flops, Iran War Spirals: A Closer Look

How to Create Pivot Table in Excel

Create a Dynamic Calendar From a List of Events in Excel

