DOWNLOAD THE EXCEL FILE

Reference Line

Grab Your Free Workbook Now! 📥

 

Follow step-by-step and boost your learning.

It’s practical, easy, and totally free. Get started today!

🔔 SUBSCRIBE if you’d like more tips and tutorials like this

https://bit.ly/3HHWQME

We respect your privacy. Unsubscribe at any time.

Need a better way to organize your project tasks? Meet the FILTER function. 🧠 In this Short, we build a dynamic Task Priority Organizer that sorts itself. No macros, no VBA, just one simple formula. Breakdown: 1️⃣ Select your task list. 2️⃣ Lock your ranges with F4. 3️⃣ Match to your priority header. 4️⃣ Drag and done! 💥 Formula used in video: =FILTER($B$10:$B$34, $C$10:$C$34=B2, "None") Subscribe for daily tips to level up your spreadsheet game! 💻 🌐 Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #ExcelFilter #DataVisualization #OfficeHacks #Excel365 #TaskManagement 0:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmFrWXVtNGJBZkxN

Master the Excel FILTER Function in 30 Seconds 📊 #Excel

Andreas Exadaktylos April 27, 2026 16:53

🎓 READY TO GO FURTHER?👉https://bit.ly/mellonfm Most people have never actually done the math on their own finances — so in this video, I'll show you exactly how to build a personal budget in Excel from a completely blank file. No templates, no downloads, no experience required. By the end of 10 minutes, you'll have a working spreadsheet that calculates your taxes, totals your expenses, and tells you exactly where you stand — automatically. 💡 WHAT YOU'LL LEARN - How to format numbers as currency in Excel - Cell referencing (and why you should never retype numbers) - How to use the SUM function - The FORMULATEXT function for auditing formulas - Accounting format for financial statements - Merge & Center and Cell Styles for clean headers - Why Excel beats a calculator, paper, or Word every single time 🎯 WHO THIS IS FOR Total beginners, students, first-jobbers, anyone who's ever wondered where their money actually goes, and anyone about to dive into a serious Excel learning path. 💻 WORKS ON PC and Mac — every formula and feature shown works identically on both. This video is Lesson 1 of my full Excel Financial Modeling and Business Analysis Masterclass — 155 lessons, 15.5 hours of video, just $29.90. Inside the course you'll build: ✅ A full 3-statement financial model (P&L, Cash Flow, Balance Sheet) ✅ A Discounted Cash Flow (DCF) valuation model ✅ A 13-week Cash Flow Forecast (Milestone Project) ✅ An interactive Financial KPI Dashboard ✅ Project Costing & Activity-Based Costing models Plus a FREE bonus PDF: 200+ Excel Shortcuts for PC & Mac. 👉 Enroll here: https://courses.mellontraining.com/courses/excel-financial-modeling 💬 Drop a comment with your net savings number — I read every one. 🌐 Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #PersonalBudget #ExcelForBeginners #PersonalFinance #ExcelBasics #BudgetSpreadsheet 11:09
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnVkejJfN0lMYV8w

Build a Budget in Excel in 10 Minutes — and See If You're Actually Broke

Andreas Exadaktylos April 19, 2026 16:13

The fastest way to clear your data without losing your hard work. 📈 If you manage monthly reports, you need the Constants shortcut. It identifies raw numbers and ignores your formulas, so you can wipe the sheet clean and start fresh instantly. 📊 Want to go deeper? My Excel Dashboard & Data Analysis Masterclass teaches you how to THINK like a Data Analyst — not just use shortcuts: 👉 https://bit.ly/mellondash 🌐 Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #workhacks #corporate #exceltricks #dataanalyst #efficiency 0:32
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjlGc0RGaVEyd1Nr

The Excel Button You’ve NEVER Used 🤫 #exceltips

Andreas Exadaktylos April 17, 2026 14:00

Stop scrolling through endless rows of data! 🛑 In this video, I show you how to create a professional, interactive Sales Tracker using a Scroll Bar and the OFFSET formula. Perfect for dashboards! 🌐 Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltips #microsoftexcel #productivity #excelhacks #dashboard #officetips #learnexcel 1:05
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLk1zWkRFMndYX04w

STOP scrolling manually in Excel! 🛑

Andreas Exadaktylos April 3, 2026 17:04

Did you know Excel already has a built-in AI that writes formulas, analyzes data, and automates tasks — without any plugins? In this video, I show you 4 powerful Copilot features hidden inside Microsoft 365 Excel that most users have never touched. Whether you're calculating ages, building complex grading logic, organizing employee data, or generating instant data insights — Copilot does it all through simple natural language prompts. No formulas required. 🔑 What You'll Learn: ✅ Instant age calculations from dates ✅ Complex multi-condition grading formulas ✅ Organizing data into department columns automatically ✅ Generating data insights and trend analysis in seconds ⚙️ Requirements: → Microsoft 365 subscription ⏱️ Timestamps: What is Copilot in Excel (and how it's different from ChatGPT) Example 1: Instant Age Calculations Example 2: Complex Grading with Multi-Table Logic Example 3: Organizing Employee Data into Department Columns Example 4: Generating Instant Data Insights & Dashboard 📊 Want to go deeper? My Excel Dashboard & Data Analysis Masterclass teaches you how to THINK like a Data Analyst — not just use shortcuts: 👉 https://bit.ly/mellondash 🌐 Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #ExcelCopilot #MicrosoftCopilot #ExcelTips #ExcelTutorial #ExcelAutomation 5:09
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkFVOTM4WGJValg4

Excel Copilot: Create an Excel Dashboard in 5 Minutes!

Andreas Exadaktylos April 1, 2026 18:06

Still dragging your Excel columns to fit your text? Stop! 🤯 This 10-second VBA trick makes your columns auto-adjust perfectly every time you hit "Enter." Whether you're building a Project Tracker or a Budget Sheet, this is the ultimate Excel productivity hack for 2026. 👇 COPY THIS CODE: Private Sub Worksheet_Change(ByVal Target As Range) Cells.EntireColumn.AutoFit End Sub 💡How to use it: ✨Right-click your Sheet Tab. ✨Select "View Code." ✨Change "(General)" to "Worksheet." ✨Paste the code above. ✨Close the window and start typing! 🚀 Subscribe for daily Excel tips to save you hours of work! 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #ExcelTips #VBA #ProductivityHacks #ExcelShorts #DataCleanUp #MicrosoftExcel 0:41
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmZxRHdmV0REd1lr

STOP Resizing Excel Columns Manually! 🛑 (Auto-Fit VBA Hack)

Andreas Exadaktylos March 26, 2026 15:01

Copying and pasting data from a PDF usually breaks everything. 📉 Use the "Get Data" tool in Excel to import tables perfectly every time. Save hours of manual work! 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excelhacks #productivitytips #exceltips #officehacks #worksmart #dataanalytics #microsoftexcel #tipsandtricks 0:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLm9ZTG1DeC1tZGVR

Stop Copy-Pasting from PDF to Excel! 🛑

Andreas Exadaktylos March 24, 2026 20:02

🔒 Did you know Excel has a "Super Hidden" sheet mode that even experienced users miss? In this video, I'll show you the exact VBA trick to hide sheets so completely that no one can even find them — and how to lock it with a password so only YOU can access it. Most people use right-click → Hide. That's amateur level. This method uses the xlSheetVeryHidden property in the VBA Editor — invisible from the Excel interface and protected behind a password. Perfect for protecting sensitive data in shared workbooks. ✅ What you'll learn: 🔒The difference between "Hidden" and "Very Hidden" in Excel 🔒How to use the VBA Editor to set xlSheetVeryHidden 🔒How to lock your VBA Project with a password 🔒How to save as a Macro-Enabled Workbook (.xlsm) to keep it secure If you want to master Excel and truly automate your job, check out my full Excel & VBA courses here: (50% OFF using Coupon Code: SCROLL50) https://courses.mellontraining.com/courses/excel-vba ⏱️ Timestamps: 0:00 - The Problem with Normal Hiding 1:12 - Enter the Secret Portal (Alt+F11) 1:45 - Activating "Super-Hide" Mode (Very Hidden) 2:30 - The Lockdown: Adding the Password 3:00 - The "No-Code" Code Trick 3:40 - Saving your Fortress (Crucial Step!) 4:10 - Testing the Security 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #vba 4:56
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjREbzczOURPYzNF

The Excel Sheet Hiding Trick Nobody Shows You (VBA Secret)

Andreas Exadaktylos March 21, 2026 15:30

Learn how to use Data Validation and Conditional Formatting to create color-coded dropdown lists in Excel. This quick Excel hack will make your spreadsheets look professional and easy to read! 🎓 READY TO BECOME AN EXCEL EXPERT? Take your skills to the next level with my best-selling courses: 1️⃣ Excel Dashboard and Data Analysis Masterclass: https://bit.ly/mellondash 2️⃣ Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX: https://bit.ly/mellondax 💻 Visit the Official Website: http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTips #MicrosoftExcel #OfficeHacks #ProductivityTips #YouTubeShorts 1:06
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjdJM2RKN3FOaXVZ

How to Color-Code Excel Dropdowns in 60s ⏱️

Andreas Exadaktylos March 17, 2026 17:35

Stop playing "calendar detective" every time you see a list of dates! 🕵️‍♂️ This 10-second Excel hack is a literal game-changer for your spreadsheets. In this video, I’ll show you how to instantly convert any date into the day of the week using the =TEXT function. It works for one cell or ten thousand—perfect for cleaning up your data in seconds. The Formula: =TEXT(Cell_Address, "dddd") 💡 Quick Pro-Tip: Use "dddd" for the full name (e.g., Monday). Use "ddd" for the short version (e.g., Mon). If this saved you a headache, hit that Subscribe button for more Excel magic! ✨ 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #microsoftexcel #exceltips #tipsandtricks #productivity #officehacks #shorts 0:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkxnQ2JXNzNCTjVJ

Stop Typing Days Manually! ❌

Andreas Exadaktylos March 14, 2026 21:25

Stop wasting your lunch break clicking individual cells! 🛑 If you’re still manually highlighting Stuck tasks or Absent employees, you’re doing it the hard way. In this video, I show you the ultimate Conditional Formatting shortcut to find every blocker in your project tracker in seconds. Your boss will think you're a wizard; I'll know you just used these 5 keys. 🤫 The Magic Shortcut: 1️⃣ Select your data range. 2️⃣ Press ALT → H → L → H → E 3️⃣ Type your keyword (like Stuck or Late). 4️⃣ Hit Enter and watch the magic happen! ✨ Why this works: This opens the Highlight Cells Rules --- Equal To menu without ever touching your mouse. It’s perfect for project managers, teachers, or anyone drowning in data. Download the practice file here: [Link to your Google Drive/File Host] Want more Excel secrets? ✅ Subscribe for daily productivity hacks! ✅ Drop a "STUCK" in the comments if this saved you time today. #ExcelTips #ProductivityHacks #ExcelShorts #WorkSmarter #SpreadsheetMagic #ProjectManagement #ExcelTutorial #OfficeHacks 0:30
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlpGb3VKb0hic3NR

Stop Highlighting Cells Manually (Do THIS instead!) 🛑

Andreas Exadaktylos March 12, 2026 16:16

Stop clicking through menus and wasting time! ⏱️ In this rapid-fire masterclass, I reveal the 15 essential Excel keyboard shortcuts that will instantly transform how you work, saving you hours every single week. Whether you are building financial models, cleaning large datasets, or just trying to navigate spreadsheets faster, these shortcuts are the secret to professional-level efficiency. We skip the boring setup and dive straight into the exact keys you need to press to automate your daily workflow. 📥 Download the Practice File: https://bit.ly/4sG9elP 🎓 READY TO BECOME AN EXCEL EXPERT? Take your skills to the next level with my best-selling courses: 1️⃣ Excel Dashboard and Data Analysis Masterclass: https://bit.ly/mellondash 2️⃣ Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX: https://bit.ly/mellondax 💻 Visit the Official Website: http://www.mellontraining.com ⏳ VIDEO TIMESTAMPS: ====================== 0:00 - The Biggest Mistake Excel Users Make 0:50 - No:1. The Magic Extractor: Flash Fill (Ctrl + E) 1:35 - No:2. The Instant Filter: Ctrl + Shift + L 2:25 - No:3. The Automatic Table: Ctrl + T (or Ctrl + L) 3:05 - No:4. The Ultimate Formatting Menu: Ctrl + 1 3:45 - No:5. The 'Select Everything' Command: Ctrl + Shift + Asterisk (*) 4:25 - No:6. Precision Selection: Ctrl + Shift + Arrow Keys 5:00 - No:7. Lightning Fast Navigation: Ctrl + Arrow Keys 5:35 - No:8. The Cell Locker (Absolute Reference): F4 6:15 - No:9. Safe Cell Editing: F2 6:50 - No:10. Flipping Pages: Ctrl + Page Up / Page Down 7:20 - No:11. The Copy Spreaders: Ctrl + R / Ctrl + D 8:00 - No:12. The Instant Calculator: Alt + Equals (=) 8:25 - No:13. The Special Paster: Ctrl + Alt + V 9:00 - No:14. The Formula Inspector: Evaluate Part of a Formula (F9) 9:35 - No:15. The Cell Line Break: Alt + Enter 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #ExcelShortcuts #ExcelTips #MellonTraining #ExcelTutorial #DataAnalysis 10:45
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlVBTE8wWHgtZkh3

These 15 Excel Keyboard Shortcuts Save 5+ Hours Weekly

Andreas Exadaktylos March 11, 2026 16:21

🎁50% OFF COUPON CODE: FEB50 ▶️https://bit.ly/mellondash In this video, I will show you how to build a fully Dynamic Monthly Gantt Chart from scratch. No macros, no VBA, just smart Conditional Formatting and logic. By the end, you will have a dashboard that automatically updates the "Today" line, changes colors based on task status, and tracks your milestones visually. Key Features We Will Build: ✅ Dynamic Date Headers: Years and months update automatically. ✅ Status Dropdowns: Watch the bars change color instantly (Completed, On Hold, In Progress). ✅ The "Today" Line: A visual red line that moves across your chart as time passes. ✅ Progress Bars: Visualize % completion directly on the timeline. 📥 Download the Practice File: https://mellontraining.com/gantt-chart/ 🎓 Master Excel Dashboards: If you want to go deeper, check out my Excel Dashboard and Data Analysis Masterclass: https://bit.ly/mellondash 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTips #DataAnalysis #ProjectManagement #ExcelDashboard #Charts #Productivity 20:05
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmk4SzF3a19JOFZr

Excel Gantt Chart That Updates Automatically | Step-by-Step

Andreas Exadaktylos March 2, 2026 18:31

📥 Download the Practice File: https://bit.ly/46iqDZc 🎁50% OFF COUPON CODE: FEB50 ▶️https://courses.mellontraining.com/ In this video, I will show you how to create a line chart in Excel with a moving vertical line that automatically updates to today's date. If you manage project budgets or track "Planned vs. Actual" performance, this dynamic chart is essential for your dashboards. Stop manually drawing lines on your charts every time you present a report! I'll walk you through setting up a helper table using simple formulas like MAXIFS and MAX, and then combining a Line Chart with a Scatter Plot to create a professional, auto-updating tracker. 📝 What You'll Learn in This Tutorial: 📖How to set up data for "Planned" vs. "Actual" budgets. 📖Creating a helper table to identify the current month/date automatically. 📖Using MAXIFS to find the latest data point dynamically. 📖Combining Chart Types: Adding a Scatter Plot series to a Line Chart. 📖Formatting tricks to create a clean, vertical "Today" line. 📖Dashboard design tips: Customizing markers, colors, and data labels for a professional look. ⏱️ Timestamps: 0:00 - Introduction to Dynamic Line Chart 1:07 - Create the line chart 2:00 - Create the vertical “Today” line 2:28 - Determine the correct month (X values) 4:15 - Set the Y values 5:16 - Add the vertical line to the chart 5:40 - Fix the chart type 6:20 - Format the lines for clarity 7:20 - Add final touches 🔥 Master Excel Dashboards & Data Analysis: Ready to take your skills to the next level? Check out my best-selling course: Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 🚀 More Excel Tutorials You Might Like: 🎓https://www.youtube.com/watch?v=JkzzPjSxYkE 🎓https://www.youtube.com/watch?v=kXB3vLN_svo 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTips #DataAnalysis #ProjectManagement #ExcelDashboard #Charts #Productivity 10:46
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLndiMEIzQVpJOG8w

This Excel Technique Saves Hours on Budget Reporting Every Month

Andreas Exadaktylos February 23, 2026 15:01

🎁50% OFF COUPON CODE: FEB50 ▶️https://courses.mellontraining.com/ ⬇️ Download the COMPLETE TEMPLATE: https://bit.ly/4aBiHDx In this video, I’ll show you how to build a super simple Travel Itinerary in Excel from scratch — perfect for beginners. We’ll create a clean layout, add a big “Trip Day” banner, use dropdown categories, split costs automatically, and generate a one-click Google Maps “Open map” link for every location. By the end, you’ll have a reusable itinerary template you can copy for every trip — Bali, New York, or your cousin’s “quick weekend getaway” that somehow lasts 9 days. What you’ll learn: ✈️How to set up a travel itinerary table in Excel ✈️How to freeze headers so they don’t disappear when you scroll ✈️How to format dates, times, and money the easy way ✈️How to calculate cost per person automatically (no #DIV/0! drama) ✈️How to create a clickable Google Maps link from your location text ✈️How to add dropdown activity types + optional color coding Formulas used in this video: Cost per person (avoids divide-by-zero errors): =IF(OR($F3="",$F3=0,$E3=""),"", $E3/$F3) Map link (clickable “Open map”): =HYPERLINK("https://www.google.com/maps/search/?api=1&query=" & ENCODEURL(H3),"Open map") If ENCODEURL doesn’t work in your Excel version: =HYPERLINK("https://www.google.com/maps/search/?api=1&query=" & SUBSTITUTE(H3," ","%20"),"Open map") If this helped, hit Like, Subscribe for more beginner-friendly Excel tutorials, and comment where you’re traveling next 🌍✈️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorial #microsoftexcel 13:47
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkhEamZuM3ZtdFpJ

Travel Itinerary in Excel | Automatic Cost Splitting + Google Maps Links

Andreas Exadaktylos February 16, 2026 18:16

🎁50% OFF COUPON CODE: FEB50 ▶️https://courses.mellontraining.com/ ⬇️ Download the COMPLETE CALENDAR: https://bit.ly/46I1yXs In this Excel tutorial, I'll show you how to build a dynamic calendar in Excel that updates automatically when you change the year. We'll use excel date formulas and conditional formatting to highlight today's date, creating a clean, printable calendar. This is perfect for excel for beginners looking to create an auto-updating yearly calendar. This is a beginner-friendly walkthrough, so I explain each step in simple words: setting up the layout, using the DATE function, creating the monthly calendar grid, using conditional formatting to gray out extra days, and making it printable. If you’ve ever rebuilt calendars every year… today is the day you stop doing that. ⏱ Chapters are included so you can jump to any part of the build. ✅ What you’ll learn: • How to make a yearly calendar in Excel • Auto-updating calendar using formulas • Conditional formatting (gray out days + highlight today) • Print settings to fit on one page ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorial #calendar #microsoftexcel 15:05
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnRTVlVxNEtLZTVn

Stop Wasting Time on Yearly Calendars—Make This Once

Andreas Exadaktylos February 11, 2026 17:01

🎁50% OFF COUPON CODE: FEB50 ▶️https://courses.mellontraining.com/ ⬇️ Download the FREE Template: https://bit.ly/4q8dR6p Need to multiply a whole column in Excel without typing formulas forever? In this beginner-friendly tutorial, I’ll show the fastest method: Paste Special → Multiply. Then we’ll level up and multiply values only when they match a rule — like only rows marked YES, only a specific category, or only values above a certain number. You’ll learn: Multiply an entire column in seconds (Paste Special trick) Multiply only filtered rows (criteria-based) Multiply only when a condition is true (IF formula) Use different multipliers by category (lookup table method) 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #MicrosoftExcel #BeginnerExcel #ExcelTips #exceltricks 5:03
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkZhYnI1TEhHRDlN

Multiply Entire Columns Instantly — Excel Paste Special Hack

Andreas Exadaktylos February 2, 2026 16:00

⬇️ Download the COMPLETE FREE Template: https://bit.ly/3Z5i9QY 🎓 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips In this Excel tutorial for beginners, you’ll learn how to highlight an entire row in Excel automatically based on a condition. Instead of manually coloring rows, we’ll use conditional formatting to make Excel do the work for you. You’ll see how to highlight full rows based on text values like Overdue, Completed, or In Progress, and how to apply multiple colors using different criteria. This method works on any table size and updates automatically when your data changes. We’ll also explore other ways to highlight rows in Excel, including text-based rules and date-based conditions — perfect for task trackers and real-world spreadsheets. If you want to save time and make your Excel sheets easier to read, this video is for you. 👉 Want more Excel tips like this? Check out my Excel course here: https://courses.mellontraining.com/courses/excel-tips 📌 Topics covered: 🎯Highlight entire rows in Excel 🎯Conditional formatting formulas 🎯Highlight rows based on text 🎯Highlight overdue tasks automatically ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #MicrosoftExcel #BeginnerExcel #ExcelTips #exceltricks 6:18
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnc5YU9RbXc4d1dr

Stop Highlighting Rows Manually in Excel (Do This Instead)

Andreas Exadaktylos January 28, 2026 17:39

⬇️ Download the COMPLETE FREE Template: https://bit.ly/3O0UKOb 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 Struggling to put two headers in one cell in Excel? In this beginner-friendly Excel tutorial, I’ll show you multiple easy ways to visually split a cell so you can add two labels in one header cell. You’ll learn: 👉How to create a diagonal split cell in Excel 👉How to separate a cell horizontally using simple tools 👉A clean alignment trick that works without borders or shapes 👉Why Excel can’t actually split cells (and what to do instead) This video is perfect for Excel beginners, students, office workers, and anyone building clean tables or reports. No formulas. No advanced skills. Just simple Excel tricks that work. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #ExcelDashboard #ScrollableTable #ScrollBar #MicrosoftExcel #BeginnerExcel #DashboardDesign #ExcelTips #exceltricks 4:37
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkd2MllGVnh2RTgw

Two Headers, One Cell: The Excel Hack Everyone's Missing

Andreas Exadaktylos January 23, 2026 16:33

⬇️ Download the COMPLETE FREE Template: https://bit.ly/49KmpKD 🎓 (50% OFF) Excel DASHBOARD Course ▶️ https://bit.ly/mellondash In this step-by-step Excel KPI Dashboard tutorial, I’ll show you how to build a complete dashboard from scratch — perfect for beginners who want to learn dashboards the right way. We’ll use real business-style data and create a one-page report that tracks Sales, Staffing, and Customer Metrics, including Actual vs Plan, order volumes, new hires & terminations, sick days, customer wait times, customer satisfaction, and Net Promoter Score (NPS). You’ll learn how to structure your workbook properly (Inputs → Calculations → Dashboard), and we’ll build the dashboard using simple, powerful tools like SUMIFS, COUNTIFS, SUMPRODUCT, Pivot Tables, charts, and conditional formatting. We’ll also add an interactive region slicer so you can toggle the entire dashboard by state with one click. 🎓 Want to learn Excel dashboards faster with guided projects and templates? Check out my Excel Dashboard Course and get 50% OFF with coupon code: SCROLL50 Course link: https://courses.mellontraining.com/courses/excel-dashboard ⏱️ Timestamps 00:00 Intro + Dashboard preview 01:45 File + Dataset tour 04:00 Calculations (SUMIFS, COUNTIFS, SUMPRODUCT etc) 33:00 Dashboard Design (Charts, Conditional Formatting, Pivot table etc) 1:14:00 Region slicer toggle + final Dashboard 📌 In this video you’ll learn: How to use SUMIFS to pull sales by month, department, type, and region How to use COUNTIFS to count orders (volumes) When to use SUMPRODUCT for grid-style tables (like NPS and wait times) How to create clean Actual vs Plan charts How to build a Pivot Table for salesperson performance How to add a Slicer to make the dashboard interactive ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #ExcelDashboard #ScrollableTable #ScrollBar #MicrosoftExcel #BeginnerExcel #DashboardDesign #ExcelTips #exceltricks 1:18:38
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmtYTURrcDRrQ29R

Full KPI Dashboard in Excel with Interactive Region Slicer | Tutorial

Andreas Exadaktylos January 19, 2026 15:31

Learn how to save screen space and build professional dashboards by creating scrollable tables in Excel using the OFFSET function. ⬇️ Download the COMPLETE FREE Template: https://bit.ly/4bA3d4C 🎓 (50% OFF) Excel DASHBOARD Course ▶️ https://bit.ly/mellondash In this Excel tutorial for beginners, you’ll learn how to create a scrollable table in Excel using a scroll bar (Form Control)—so you can scroll through rows without moving your entire worksheet. This is perfect for Excel dashboards because your charts, KPIs, and visuals stay in place while your table updates smoothly. I’ll walk you step by step through adding the scroll bar from the Developer tab, linking it to a cell, and using a simple formula to display the correct rows as you scroll. By the end, you’ll have an interactive “dashboard-style” table that looks clean, professional, and easy to use. 🎓 Want to build full interactive dashboards? 📊 Check out my Excel Dashboard Course and get 50% OFF with coupon code SCROLL50 ▶️ https://bit.ly/mellondash ✅ What you’ll learn in this video: How to add a scroll bar in Excel How to make a table scroll inside a dashboard How to keep charts fixed while scrolling data How to set min/max values correctly Beginner-friendly Excel dashboard technique 📌 Coupon Code: SCROLL50 (50% OFF) ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #ExcelDashboard #ScrollableTable #ScrollBar #MicrosoftExcel #BeginnerExcel #DashboardDesign #ExcelTips #exceltricks 11:27
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLktkd1R1dTB1QU1N

Excel Tables That Scroll | Keep Charts Fixed | No VBA Required

Andreas Exadaktylos January 12, 2026 16:15

Stop writing messy nested IF formulas in Excel. In this quick YouTube Short, I’ll show you how to use the SWITCH function to automatically convert a Shipping Method into Shipping Days—clean, fast, and easy to read. ✅ Formula used: =SWITCH(D5,"Standard",5,"Expedited",3,"Express",2,"Overnight",1,"International",10,"N/A") Use this for shipping times, discounts, commission rates, grades, status labels, and more. 🎓 Want to go deeper with Macros & VBA? Check out my full course “Excel Macros & Excel VBA for Non-Programmers”: https://bit.ly/mellonvba It’s designed for people who don’t see themselves as programmers: short lessons, practical examples, and lots of hands-on exercises. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #shorts #excel #exceltips #excelformulas #switch #youtubeshorts #productivity #spreadsheet 0:40
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmZwanVYV0VKam5j

SWITCH Function Replaces 50 IF Statements #excel #tutorial

Andreas Exadaktylos January 10, 2026 14:58

⬇️ Download the FREE Template: https://bit.ly/49hUuCG 🎓 Excel DASHBOARD Course ▶️ https://bit.ly/mellondash In this Excel beginner tutorial, you’ll learn how to mask sensitive data in Excel using simple formulas—so you can protect private information in reports and dashboards without losing the parts you still need. We’ll use a real example: credit card numbers. You’ll see how to keep the first 4 digits (or the last 4 digits) and replace the rest with asterisks (*). I’ll walk you through two easy methods using popular Excel functions like LEFT, CONCAT, REPLACE, REPT, LEN, and RIGHT, plus a key beginner tip: how to Paste Special → Values so your masked results don’t break when you delete the original data. 🎓 What you’ll learn in this video: ▶️How to mask credit card numbers in Excel (privacy-friendly reporting) ▶️Method 1: Use LEFT + CONCAT to show the first 4 digits and hide the rest ▶️Method 2: Use REPLACE + REPT to create a faster masked version ▶️How to show only the last 4 digits using LEN + RIGHT + REPT ▶️How to convert formulas to values so you can remove the original sensitive column safely ✅This is perfect for anyone working with customer data, financial reports, dashboards, HR spreadsheets, or any file that includes confidential information. 📌 Formulas used: =LEFT(E2,4) =CONCAT(LEFT(E2,4),"**************") =REPLACE(E2,5,15,REPT("",15)) =REPT("*",LEN(E2)-4)&RIGHT(E2,4) If this helped, please like, subscribe, and comment what you want to mask next (phone numbers, emails, IDs, names, and more). ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #Excel #ExcelTutorial #DataMasking #Privacy #ExcelFormulas #BeginnerExcel #MicrosoftExcel 6:41
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlhXeUFVanhzTHJ3

Hide Credit Card Numbers in Excel (Keep Only Last 4 Digits)

Andreas Exadaktylos December 27, 2025 16:00

⬇️ Download the COMPLETE FREE Template: https://bit.ly/4oTboMJ 🎓 Excel VBA Course ▶️ https://bit.ly/mellonvba Turn one boring Excel sheet into an interactive dashboard with clickable tabs! In this tutorial I show you step-by-step how to create tabs inside a single worksheet using Shapes + a tiny bit of VBA. Perfect for Excel beginners and non-programmers. You’ll learn how to: Set up multiple data views on one sheet (North / Central / South regions) Create fake “tabs” with shapes and make them look ON / OFF Use simple VBA macros to show and hide columns with one click Link each tab to its macro so your sheet behaves like a real app Save your file as a macro-enabled workbook and avoid common errors This is great for: Sales reports by region or year Management dashboards Clean client reports (without 20+ sheets) Anyone who wants to make Excel feel more like a real UI 🔽 Download the practice workbook: https://bit.ly/4oTboMJ 🎓 Want to go deeper with Macros & VBA? Check out my full course “Excel Macros & Excel VBA for Non-Programmers”: https://bit.ly/mellonvba It’s designed for people who don’t see themselves as programmers: short lessons, practical examples, and lots of hands-on exercises. ⏱ Timestamps Intro & what we’re building Data setup for three regions Creating the tab shapes Naming shapes correctly Writing the VBA code Assigning macros to tabs Testing & fixing common issues Ideas to extend this technique ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 12:49
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnRjeEo3Wmd3Uy0w

Excel Tabs Inside One Sheet | No More Sheet Chaos

Andreas Exadaktylos December 16, 2025 18:01

🎓 Excel Dashboard Course ▶️ https://bit.ly/mellondash In this video, we build a super simple Daily Activity Tracker in Excel. You’ll type your tasks once, choose a priority from a drop-down, add quick notes, and flip each task to Planned, In Work, or Done. Your totals update automatically, and a smooth progress bar shows how close you are to finishing. No macros. No scary formulas. Just clear steps you can follow even if you’re brand new to Excel. By the end you’ll know how to set up a neat table, add user-friendly drop-downs with Data Validation, color priorities and statuses with Conditional Formatting, count tasks with COUNTIF, and turn those numbers into a 100% stacked bar that acts like a progress bar. It’s the kind of sheet you’ll reuse every day. 📊 What you’ll learn • Data Validation for clean drop-downs • Conditional Formatting that highlights what matters • COUNTIF to create live status totals • A quick progress bar using a stacked bar chart • Everyday tips for tables, freezing the header row, and expanding your tracker ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 14:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkZ2bnRuM19ZOWdN

Excel Task Tracker with Auto-Updating Progress Bar

Andreas Exadaktylos December 7, 2025 18:30

⬇️ Download the workbook👉https://bit.ly/49G6Ipt 🎓 Excel DAX Course ▶️ https://bit.ly/mellondax Stop wrestling with Excel formulas — let ChatGPT do the hard part for you! In this beginner-friendly tutorial, I’ll show you how to describe your Excel task in simple, everyday language… and get clear, correct formulas you can paste straight into your sheet. I’m Andreas, a full-time Excel teacher for 20+ years and best-selling Udemy instructor. If you want Excel explained clearly (with occasional dad jokes), you’re in the right place. 😄 In this video you’ll learn: ✔️ How to write prompts that get accurate formulas ✔️ How to join columns (like Country Code + Phone) using ChatGPT ✔️ How to calculate percentage change the easy way ✔️ How to sum only unpaid customers using SUMIFS ✔️ How to fix ChatGPT formulas when something isn’t quite right ✔️ Why using Excel Tables makes everything simpler and cleaner ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials #chatgpt 10:01
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmcxdlBOQWJHY0JR

Stop Writing Complex Excel Formulas (Use ChatGPT Instead)

Andreas Exadaktylos November 28, 2025 17:27

⬇️ Download the COMPLETE Kanban Board👉 https://bit.ly/4o39Wqs 🎓 Excel VBA Course ▶️ https://bit.ly/mellonvba Build a simple Kanban board in Microsoft Excel—no VBA, just easy formulas. We set up a task list, status dropdowns, and an auto-updating board that moves tasks across columns. Great for tracking projects, sprints, or personal to-dos in Excel. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 22:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlFTQllodWdJaURv

Excel Kanban Board with Formulas Only | Auto-Updating Tasks

Andreas Exadaktylos November 19, 2025 21:39

⬇️ Download the workbook👉https://bit.ly/43leKQH 🎓 Excel Charts Course ▶️ https://bit.ly/melloncharts Turn messy tables into clear visuals in minutes. In this beginner-friendly tutorial, I show how to build a clean Excel heatmap using a sample coffee shop orders dataset. You’ll learn simple conditional formatting, quick formatting tricks, row/column totals, and a tiny summary chart—no formulas or VBA needed. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 12:41
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkprenpQalN4WWtF

Turn Messy Data Into Beautiful Heatmaps in 5 Minutes

Andreas Exadaktylos November 10, 2025 17:30

⬇️ Download the workbook👉https://bit.ly/49RmrCh 🎓 Excel Hacks Course ▶️ https://bit.ly/mellontips Got messy names in Excel? In this video I show you how to make them look consistent with three simple functions: UPPER, LOWER, and PROPER. You’ll learn how to apply the formula to the whole list and how to paste as values so your changes don’t revert later. I also share quick tips like the fill handle, double-click to fill, and Flash Fill to save time. You’ll learn step-by-step: ✅ Problem and plan ✅ UPPER (all caps) ✅ Paste as Values (lock it in) ✅ LOWER (all lowercase) ✅ PROPER (John Doe style) ✅ Time-savers Formulas used: =UPPER(A2) =LOWER(A2) =PROPER(A2) ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 5:11
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkJPUU9ETnlXd2pn

Convert Small Letters to Capital Letters in Excel FAST!

Andreas Exadaktylos October 29, 2025 17:30

⬇️ Download the workbook👉https://bit.ly/42Mg9PZ 🎓 Excel Charts Course ▶️ https://bit.ly/melloncharts Have you ever made a bar chart in Excel where the bars covered the year labels? This often happens when data shifts between positive and negative values. This excel tutorial shows a clean trick to stagger the data labels so positive years appear below the axis and negative years above it, making your charts much clearer. It's a simple way to improve your data visualization and create a professional-looking how to make a bar graph in excel that updates automatically. You’ll learn step-by-step: ✅ How to build a clear profit/loss chart in Excel ✅ The problem with overlapping labels when data crosses zero ✅ How to use helper series with smart IF formulas ✅ How to add “value from cells” labels that move automatically ✅ Tips to polish, format, and style your chart like a pro By the end, you’ll have a dynamic Excel chart that looks professional and updates on its own. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 💻 OFFICIAL WEBSITE http://www.mellontraining.com 🎓 BEST-SELLING COURSES (Join 70,000+ Professionals): 📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/ 👨‍🏫 About Me: Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator. For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery. On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs. 📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace. 📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies. 📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place. SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl #excel #exceltutorials 9:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmtYQjN2TE5fc3Zv

Excel Charts That Auto-Adjust Labels? Here's How

Andreas Exadaktylos October 18, 2025 15:35

Load More... Subscribe
Mellon Training
Facebook-f Youtube

No matter your profession, stop wasting precious hours crunching numbers.

Get the Excel training that builds an unbeatable resume and warp drives your career.

QUICK LINKS