Logo
Youtube X-twitter Facebook-f

How to Create a Frequency Distribution Table in Excel

How to Create a Frequency Distribution Table in Excel | FREQUENCY Function

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

 

We respect your privacy. Unsubscribe at any time.

Want to clear out data without ruining your entire spreadsheet? In this quick tutorial, learn how to use the Go To Special feature in Excel to instantly select and delete multiple numbers at once, while keeping your text labels and formulas completely safe. Perfect for beginners looking to speed up their workflow! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 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 1:02
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnhQQ2xsQlB3TUdV

Delete Thousands of Numbers Instantly in Excel! #excel #shorts

Andreas Exadaktylos May 23, 2026 18:09

⬇️ Download the COMPLETE TEMPLATE: https://mellontraining.com/fix-charts/ 🎓 Go deeper: Excel Charts & Data Visualisation 👉 https://mellontraining.com/go/charts Your Excel chart titles are silently lying to your audience — and you probably don't even notice it. In this video, I'll show you 2 methods to make chart titles that update AUTOMATICALLY, so your dashboards always tell the truth. ✅ What you'll learn: → How to link a chart title directly to a cell (Method 1 — beginner-friendly) → How to build a fully dynamic title using formulas that calculate growth %, year changes, and more (Method 2 — dashboard-level pro move) → The exact formula bar trick that most Excel users never discover → How to use the & operator and INT function to build clean, professional titles This is the difference between a static report and a self-maintaining dashboard that impresses every time data changes. ⏱ TIMESTAMPS: 00:00 – Why your chart titles are outdated (and why it matters) 01:05 – Method 1: Link chart title to a static cell 01:45 – Method 2: Dynamic title with live formulas ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Charts, Infographics & Data Visualisation Master 50+ dynamic charts. Turn plain data into charts people understand. 👉 https://mellontraining.com/go/charts ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 Question about this one? Drop it in the comments — I read every single one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelCharts #ExcelDashboard #MicrosoftExcel #ExcelTutorial 5:44
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjVhZDlDc1RFUEhV

Your Excel Charts Are Wrong | Here's Why & How to Fix It

Andreas Exadaktylos May 9, 2026 16:21

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

🎓 This is Lesson 1 of the full course 👉 https://mellontraining.com/go/finmodel Most people have never actually done the maths on their own finances. 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, and the accounting format for statements → Cell referencing, and why you should never retype a number → The SUM function, and FORMULATEXT for auditing your own formulas → Merge & Center and Cell Styles for headers that look deliberate → 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 start a serious Excel path. 💻 WORKS ON PC AND MAC Every formula and feature shown works identically on both. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Financial Modeling & Business Analysis Masterclass This video is Lesson 1. The full course is 155 lessons and 15.5 hours, and inside it 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 and Activity-Based Costing models Plus a free bonus PDF: 200+ Excel shortcuts for PC and Mac. 👉 https://mellontraining.com/go/finmodel ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⏱ TIMESTAMPS 0:00 The maths nobody actually does 0:33 Build the income section 2:10 Formulas: tax, cell referencing and net income 4:45 Expenses, SUM, and your net savings number 6:55 Make it presentable — then change one number 💬 Drop a comment with your net savings number — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelTutorial #PersonalBudget #PersonalFinance #ExcelForBeginners 11:10
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

⬇️ FREE AI Prompt Pack — 50 tested Excel prompts 👉 https://mellontraining.com/excel-copilot 🎓 Go deeper: Excel & Data Analysis 👉 https://mellontraining.com/go/dashboards Did you know Excel already has a built-in AI that writes formulas, analyses data and automates tasks — with no plugins at all? In this video I show you 4 powerful Copilot features hidden inside Microsoft 365 Excel that most users have never touched. Calculating ages, building complex grading logic, reorganising employee data, generating instant insights — Copilot does all of it from plain English. No formulas required. 🔑 WHAT YOU'LL LEARN ✅ Instant age calculations from dates ✅ Complex multi-condition grading formulas ✅ Organising data into department columns automatically ✅ Generating data insights and trend analysis in seconds ⚙️ REQUIREMENTS → A Microsoft 365 subscription (Copilot isn't in Excel 2021 or earlier) ⏱ TIMESTAMPS 00:00 – What Copilot in Excel is, and how it differs from ChatGPT 00:25 – Example 1: Instant age calculations 01:15 – Example 2: Complex grading with multi-table logic 02:10 – Example 3: Organising employee data into department columns 03:10 – Example 4: Generating instant data insights and a dashboard 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What would you get Copilot to do first? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #ExcelCopilot #MicrosoftCopilot #ExcelAI #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

⬇️ FREE Macro Pack — this trick + 27 more macros 👉 https://mellontraining.com/vba-hiding-trick 🎓 Go deeper: Excel Macros & VBA for Beginners 👉 https://mellontraining.com/go/vba 🔒 Did you know Excel has a "Very Hidden" sheet mode that even experienced users miss? In this video I'll show you the exact VBA property that hides a sheet so completely it doesn't appear in the right-click Unhide list at all. Most people use right-click → Hide. Anyone can undo that in two clicks. This method uses xlSheetVeryHidden in the VBA Editor, which is invisible from the Excel interface entirely — ideal for keeping your calculation sheets, lookup tables and helper columns out of a colleague's way in a shared workbook. ✅ WHAT YOU'LL LEARN 🔒 The real difference between "Hidden" and "Very Hidden" 🔒 How to set xlSheetVeryHidden in the VBA Editor 🔒 How to lock the VBA Project so the setting isn't obvious 🔒 Why you must save as .xlsm or lose the whole thing ⚠️ ONE HONEST NOTE This is protection from accident, not from attack. VBA project passwords can be broken by freely available tools in seconds — so use this to stop colleagues casually breaking your formulas, not to secure confidential data. For anything genuinely sensitive, use file-level encryption (File → Info → Protect Workbook → Encrypt with Password) or keep it out of the workbook altogether. ⏱ TIMESTAMPS 0:00 – The problem with normal hiding 1:12 – Opening the VBA Editor (Alt + F11) 1:45 – Setting a sheet to Very Hidden 2:30 – Locking the VBA project 3:00 – The no-code method 3:40 – Saving as .xlsm (crucial step) 4:10 – Testing that it worked ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Macros & VBA Programming for Beginners This is one small corner of the VBA Editor. The course takes you from opening it for the first time to automating jobs you currently do by hand. 👉 https://mellontraining.com/go/vba ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you hiding — helper sheets, lookup tables, something else? Tell me in the comments. I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelVBA #ExcelTips #MicrosoftExcel #ExcelTutorial 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

⬇️ FREE practice file 👉 https://mellontraining.com/15-shortcuts/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Stop clicking through menus and wasting time. In this rapid-fire masterclass I reveal the 15 essential Excel keyboard shortcuts that will instantly change how you work — saving you hours every single week. Whether you're building financial models, cleaning large datasets, or just trying to navigate spreadsheets faster, these are the keys behind professional-level efficiency. No boring setup. Straight into the shortcuts. ✅ WHAT YOU'LL LEARN → The extraction trick that replaces half your text formulas (Flash Fill) → How to filter, table and format anything without touching the ribbon → Navigation and selection shortcuts for datasets of any size → The formula-debugging key almost nobody knows about (F9) ⏱ 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 3:05 – No.4 The Ultimate Formatting Menu: Ctrl + 1 3:45 – No.5 Select Everything: Ctrl + Shift + * 4:25 – No.6 Precision Selection: Ctrl + Shift + Arrows 5:00 – No.7 Lightning Navigation: Ctrl + Arrows 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 + PgUp / PgDn 7:20 – No.11 The Copy Spreaders: Ctrl + R / Ctrl + D 8:00 – No.12 The Instant Calculator: Alt + = 8:25 – No.13 The Special Paster: Ctrl + Alt + V 9:00 – No.14 The Formula Inspector: F9 9:35 – No.15 The Cell Line Break: Alt + Enter ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks These 15 are the start. The course has 100+ more, in 8 hours. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 Which shortcut did you already know? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #ExcelShortcuts #ExcelTips #MicrosoftExcel #ExcelTutorial #Productivity 10:45
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlVBTE8wWHgtZkh3

These 15 Excel Keyboard Shortcuts Save 5+ Hours Weekly

Andreas Exadaktylos March 11, 2026 16:21

⬇️ FREE Gantt Chart workbook 👉 https://mellontraining.com/gantt-chart/ 🎓 Go deeper: Excel Dashboard & Data Analysis 👉 https://mellontraining.com/go/dashboards In this video I'll 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'll have a project timeline that updates the "Today" line by itself, changes colour based on task status, and shows progress visually. Add a task, change a date, and the whole thing redraws. ✅ WHAT WE'LL BUILD → Dynamic date headers — years and months update automatically → Status dropdowns that recolour the bars instantly (Completed, On Hold, In Progress) → The "Today" line: a red marker that moves across the chart as time passes → Progress bars showing % completion directly on the timeline ⏱ TIMESTAMPS 00:00 – What we're building 00:54 Setting up the task table 03:43 Dynamic date headers 04:35 Status dropdowns with Data Validation 05:51 Format the % Done column 06:37 Build the calendar header(Year, Quarter,Months) 11:11 Color alternating quarters and years automatically 16:35 Highlight blocked tasks directly on the bars ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Dashboard & Data Analysis Masterclass This Gantt chart uses three techniques — conditional formatting, data validation and dynamic formulas — that sit behind every professional Excel dashboard. The course builds five complete dashboards from a blank file. 👉 https://mellontraining.com/go/dashboards ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What project are you tracking? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #GanttChart #ProjectManagement #ExcelDashboard #ExcelTutorial 20:05
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmk4SzF3a19JOFZr

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

Andreas Exadaktylos March 2, 2026 18:31

⬇️ FREE workbook 👉 https://mellontraining.com/moving-vertical-line/ 🎓 Go deeper: Excel Charts & Data Visualisation 👉 https://mellontraining.com/go/charts Stop manually drawing lines on your charts every time you present a report. In this video I'll show you how to build a line chart with a moving vertical line that updates itself to today's date. If you track project budgets or "Planned vs Actual" performance, this is the chart that makes the current position obvious at a glance. We'll set up a helper table using MAXIFS and MAX, then combine a Line Chart with a Scatter Plot to create a professional, auto-updating tracker. 📝 WHAT YOU'LL LEARN 📖 How to set up data for Planned vs Actual budgets 📖 Building a helper table that finds the current month automatically 📖 Using MAXIFS to locate the latest data point dynamically 📖 Combining chart types — adding a Scatter series to a Line chart 📖 The formatting trick that turns two points into a clean vertical line 📖 Customising markers, colours and labels so it looks deliberate ⏱ TIMESTAMPS 0:00 – Introduction to the dynamic line chart 1:07 – Creating the line chart 2:00 – Building the vertical "Today" line 2:28 – Determining the correct month (X values) 4:15 – Setting the Y values 5:16 – Adding the vertical line to the chart 5:40 – Fixing the chart type 6:20 – Formatting the lines for clarity 7:20 – Final touches ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Charts, Infographics & Data Visualisation This is one of 50+ advanced dynamic charts in the course — the ones Excel won't build for you, taught from a blank file to finished. 👉 https://mellontraining.com/go/charts ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you tracking — budgets, projects, something else? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelCharts #ExcelDashboard #BudgetTracking #ExcelTutorial 10:47
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLndiMEIzQVpJOG8w

This Excel Technique Saves Hours on Budget Reporting Every Month

Andreas Exadaktylos February 23, 2026 15:01

⬇️ FREE itinerary template 👉 https://mellontraining.com/travel-itinerary/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips In this video I'll show you how to build a travel itinerary in Excel from scratch — perfect for beginners. Clean layout, a big "Trip Day" banner, dropdown categories, automatic cost splitting, and a one-click Google Maps link for every location. By the end you'll have a reusable 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 → Setting up a travel itinerary table that won't break when you add rows → Freezing headers so they don't vanish when you scroll → Formatting dates, times and money the easy way → Calculating cost per person automatically (no #DIV/0! drama) → Turning any location into a clickable Google Maps link → Dropdown activity types with optional colour coding 📝 FORMULAS USED 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 isn't available in your Excel version: =HYPERLINK("https://www.google.com/maps/search/?api=1&query=" & SUBSTITUTE(H3," ","%20"),"Open map") ⏱ TIMESTAMPS 0:00 – What we're building 0:23 Set up the table and headers 1:55 Trip Day banner and freezing the headers 3:34 Format dates, times and currency 4:15 Split the cost per person automatically 5:54 One-click Google Maps link 8:11 Fill in a real day, then dropdowns and colour coding ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners Freeze panes, dropdowns, HYPERLINK, error-proof formulas — the techniques in this video are a handful of the 100+ in the course. 8 hours, beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 Where are you travelling next? Tell me in the comments 🌍✈️ — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelTemplate #TravelPlanner #ExcelForBeginners #ExcelTutorial 13:47
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkhEamZuM3ZtdFpJ

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

Andreas Exadaktylos February 16, 2026 18:16

⬇️ FREE calendar template 👉 https://mellontraining.com/yearlycalendar/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips If you've ever rebuilt a calendar every January — today is the day you stop. In this tutorial I'll show you how to build a dynamic yearly calendar in Excel that updates itself when you change the year. One number, and all twelve months redraw. We use date formulas and conditional formatting to grey out the days that don't belong and highlight today automatically. It's a beginner-friendly walkthrough — I explain every step in plain language. ✅ WHAT YOU'LL LEARN → Building a monthly calendar grid that calculates its own dates → The DATE and WEEKDAY functions, explained simply → Conditional formatting to grey out days from other months → Highlighting today's date automatically, every time you open the file → Print settings that fit the whole year on one page ⏱ TIMESTAMPS [00:00] Why rebuilding calendars every year is a waste [00:32] Setting up the initial spreadsheet layout and adjusting cell sizes [02:14] Creating the year input box [03:01] Building the helper table to calculate the start dates for each month [05:34] Designing and setting up the January calendar block [09:27] Using conditional formatting to gray out dates outside of the current month [10:50] Copying and adjusting formulas to quickly create the remaining 11 months [13:02] Adding a rule to automatically highlight today's date [13:33] Adjusting page settings to print the calendar cleanly on a single page ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners Date formulas, conditional formatting, print setup — the techniques here are a few of the 100+ in the course. 8 hours, taught at beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What year did you build yours for? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelCalendar #ExcelTemplate #ExcelForBeginners #ExcelTutorial 15:05
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnRTVlVxNEtLZTVn

Make a Yearly Excel Calendar Once — It Updates Every Year

Andreas Exadaktylos February 11, 2026 17:01

⬇️ FREE practice file + 20 more Excel workbooks 👉 https://mellontraining.com/multiply-columns/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Need to multiply a whole column in Excel without typing formulas forever? In this beginner-friendly tutorial I'll show you the fastest method — Paste Special → Multiply. Then we'll level up and multiply values only where they match a rule: only rows marked YES, only one category, or only values above a certain number. ✅ WHAT YOU'LL LEARN → Multiply an entire column in seconds with Paste Special → Multiply only filtered rows, without touching the hidden ones → Why Go To Special is the step most people miss (and what breaks without it) → Multiply conditionally with IF, leaving your original data intact → Different multipliers per category using a lookup table ⏱ TIMESTAMPS 00:00 – The three methods 00:13 – Method 1: Paste Special, an entire column instantly 01:28 – Method 2: Filters + Paste Special for specific rows 02:23 – Go To Special: only touching the visible cells 03:07 – Method 3: An IF formula that leaves the original data alone 04:44 – Wrapping up ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks Paste Special is one trick. The course has a hundred more like it — the small techniques that quietly save you hours every week. 8 hours, beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 Which method will you use? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelTips #PasteSpecial #ExcelForBeginners #ExcelTutorial 5:03
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkZhYnI1TEhHRDlN

How to Multiply a Whole Column in Excel (No Formulas)

Andreas Exadaktylos February 2, 2026 16:00

⬇️ FREE template + 20 more Excel workbooks 👉 https://mellontraining.com/highlightrows-2/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Stop colouring rows by hand. In this Excel tutorial for beginners you'll learn how to highlight an entire row automatically based on a condition — so Excel does the work and keeps doing it as your data changes. We'll highlight full rows from text values like Overdue, Completed or In Progress, then layer multiple colours using different criteria. It works on any table size and updates itself the moment something changes. 📌 WHAT YOU'LL LEARN 🎯 Highlighting an entire row, not just one cell 🎯 Writing the conditional formatting formula that drives it 🎯 Absolute vs relative references — why the $ sign decides whether this works 🎯 Stacking multiple rules for different statuses 🎯 The faster "Text that contains" method, and where it falls down ⏱ TIMESTAMPS 00:00 – Highlighting rows automatically: the idea 00:50 – Selecting the right range first 01:06 – Creating a formula-based rule 01:42 – The formula that triggers on a text value 02:11 – Absolute vs relative references (why the $ matters) 03:17 – Adding rules for different statuses 04:52 – The quicker "Text that contains" method — and its downsides ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks Conditional formatting is one technique. The course has a hundred more like it — the small things that quietly save you hours every week. 8 hours, beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you tracking — tasks, invoices, deadlines? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ConditionalFormatting #ExcelTips #ExcelForBeginners #ExcelTutorial 6:18
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnc5YU9RbXc4d1dr

Stop Highlighting Rows Manually in Excel (Do This Instead)

Andreas Exadaktylos January 28, 2026 17:39

⬇️ FREE template + 20 more Excel workbooks 👉 https://mellontraining.com/split-a-cell/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Struggling to put two headers in one cell in Excel? In this beginner-friendly tutorial I'll show you several easy ways to visually split a cell, so you can put two labels in one corner header — the classic table layout everyone has seen and almost nobody knows how to make. No formulas. No advanced skills. Just simple tricks that work. ✅ WHAT YOU'LL LEARN 👉 How to create a diagonal split cell in Excel 👉 How to separate a cell horizontally with simple tools 👉 A clean alignment trick that needs no borders or shapes 👉 Why Excel can't actually split a cell — and what to do instead Perfect for beginners, students, office workers, and anyone building clean tables or reports. ⏱ TIMESTAMPS 00:00 – Split headers: the idea 00:22 – The problem: two labels in one corner cell 00:54 – Method 1: the cleanest way, using a diagonal border 01:08 – Alt + Enter to put two words on separate lines 01:29 – Adding the diagonal line via Format Cells → Border 02:22 – Method 2: drawing a line with Insert Shape 03:29 – Why a drawn shape causes trouble in shared files 03:52 – The truth about splitting cells (they're all visual tricks) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks This is one hack. The course has a hundred more — the small techniques that quietly save you hours every week. 8 hours, taught at beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you building — a timetable, a price grid, a tracker? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelTips #ExcelTricks #ExcelForBeginners #MicrosoftExcel 4:37
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkd2MllGVnh2RTgw

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

Andreas Exadaktylos January 23, 2026 16:33

⬇️ FREE dashboard template + 7 more workbooks 👉 https://mellontraining.com/kpi-dashboard-2/ 🎓 Go deeper: Excel Dashboard & Data Analysis Masterclass 👉 https://mellontraining.com/go/dashboards In this step-by-step tutorial we build a complete Excel KPI dashboard from scratch — the right way, from a blank file to a finished one-page report. We use real business-style data to track Sales, Staffing and Customer metrics: Actual vs Plan, order volumes, new hires and terminations, sick days, customer wait times, satisfaction, and Net Promoter Score. You'll learn how to structure a workbook properly — Inputs → Calculations → Dashboard — and build everything with SUMIFS, COUNTIFS, SUMPRODUCT, PivotTables, charts and conditional formatting. Then we add a region slicer so the whole dashboard filters with one click. 📌 WHAT YOU'LL LEARN → SUMIFS to pull sales by month, department, type and region → COUNTIFS for order volumes → When SUMPRODUCT beats everything else (grid tables like NPS and wait times) → Clean Actual vs Plan charts that read at a glance → A PivotTable for salesperson performance → A slicer that makes the whole dashboard interactive ⏱ TIMESTAMPS 00:01 – Overview of the KPI dashboard project 01:47 – The assumption sheet and raw data inputs 03:54 – SUMIFS: summarising sales data 18:52 – COUNTIFS: counting orders 23:03 – SUMIFS for terminations and new hires 24:55 – SUMPRODUCT: pulling Net Promoter Score 27:35 – Customer and employee satisfaction metrics 29:05 – Wait times with multiple criteria 33:04 – Moving calculations to the dashboard page 35:08 – Conditional formatting with custom icon sets 38:31 – Column charts: actual vs planned sales 48:53 – A PivotTable for salesperson performance 53:08 – Stacked column charts for HR metrics 1:00:32 – Doughnut charts for satisfaction scores 1:13:51 – The slicer that filters everything at once ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Dashboard & Data Analysis Masterclass You've just built one dashboard with me. The course builds ten — 180 lessons, 21 hours, every workbook included, updated for Microsoft 365. 👉 https://mellontraining.com/go/dashboards ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 Which KPI would you add to this dashboard? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelDashboard #KPIDashboard #DataAnalysis #ExcelTutorial 1:18:38
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmtYTURrcDRrQ29R

Build a Complete Excel KPI Dashboard from Scratch | Interactive Tutorial

Andreas Exadaktylos January 19, 2026 15:31

⬇️ FREE template + 9 more dashboard workbooks 👉 https://mellontraining.com/scrollable-tables/ 🎓 Go deeper: Excel Dashboard & Data Analysis Masterclass 👉 https://mellontraining.com/go/dashboards Scroll down a long table and your charts disappear off the screen. Here's the fix. In this tutorial you'll learn how to build a scrollable table in Excel using a scroll bar form control and the OFFSET function — so you can move through hundreds of rows while your charts, KPIs and visuals stay exactly where they are. No VBA. No add-ins. I'll walk you through adding the scroll bar from the Developer tab, linking it to a cell, and writing the formula that pulls the right rows as you scroll. ✅ WHAT YOU'LL LEARN → Adding a scroll bar from the Developer tab → Linking it to a helper cell that drives everything → The OFFSET formula that pulls the visible rows → Setting minimum and maximum values correctly → Fixing the blank rows that appear when you scroll too far ⏱ TIMESTAMPS 00:00 – The problem: scrolling makes your charts vanish 00:39 – Setting up the dashboard sheet and headers 01:21 – Finding the Developer tab and inserting a scroll bar 02:16 – Linking the scroll bar to a helper cell 03:31 – Setting the minimum and maximum values 04:12 – The OFFSET formula that pulls your data 05:53 – Why you must lock the reference before copying 06:56 – Formatting currency and dates in the view table 07:39 – Troubleshooting: those blank rows at the end 09:44 – Bringing the charts in and finishing the layout ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Dashboard & Data Analysis Masterclass Scroll bars are one interactive control. The course builds ten complete dashboards — slicers, timelines, dynamic charts, KPI cards. 180 lessons, 21 hours. 👉 https://mellontraining.com/go/dashboards ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you putting in your dashboard? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelDashboard #ScrollableTable #ScrollBar #ExcelTutorial 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

⬇️ FREE template + 20 more Excel workbooks 👉 https://mellontraining.com/mask-sensitive-data/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Need to share a report that contains customer data? Here's how to mask it properly in Excel — keeping the part you still need and hiding the rest. We use credit card numbers as the example. You'll see how to keep the first four digits, or the last four, and replace everything else with asterisks. Two methods, both beginner-friendly, plus the step most people skip that decides whether your data is actually protected. 🎓 WHAT YOU'LL LEARN ▶️ Method 1: LEFT + CONCAT to show only the first 4 digits ▶️ Method 2: REPLACE + REPT for a faster masked version ▶️ How to show only the LAST 4 digits with LEN + RIGHT + REPT ▶️ Paste Special → Values, so your masked column survives deleting the original Useful for anyone handling customer data, financial reports, HR spreadsheets, or any file with confidential information in it. 📌 FORMULAS USED =LEFT(E2,4) =CONCAT(LEFT(E2,4),"**************") =REPLACE(E2,5,15,REPT("*",15)) =REPT("*",LEN(E2)-4)&RIGHT(E2,4) ⏱ TIMESTAMPS 00:00 – What data masking is, and when you need it 00:52 – Method 1: LEFT and CONCAT, showing the first 4 digits 02:32 – Method 2: a faster way with REPLACE and REPT 03:59 – The crucial step: converting formulas to values 05:01 – Bonus: masking everything except the last 4 digits ⚠️ ONE IMPORTANT WARNING A masking formula doesn't protect anything on its own — the original numbers are still sitting in your file. You must copy the masked column, Paste Special → Values, then delete the original column. Skip that and you've shared the real data with an asterisk column next to it. That's the 03:59 step, and it's the one that actually matters. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks Text functions are a handful of the 100+ techniques in the course — the small things that quietly save you hours every week. 8 hours, beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What else do you need to mask — phone numbers, emails, IDs? Tell me in the comments and I'll cover it. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #DataMasking #ExcelFormulas #ExcelForBeginners #MicrosoftExcel 6:41
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlhXeUFVanhzTHJ3

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

Andreas Exadaktylos December 27, 2025 16:00

⬇️ FREE Macro Pack — this file + 20 more macros 👉 https://mellontraining.com/tabs-inside-tabs/ 🎓 Go deeper: Excel Macros & VBA for Non-Programmers 👉 https://mellontraining.com/go/vba Turn one ordinary worksheet into something that behaves like an app — with clickable tabs that switch between views. In this tutorial I'll show you step by step how to build tabs inside a single sheet using Shapes and a small amount of VBA. You don't need to be a programmer; the code is four lines and I explain every one. ✅ WHAT YOU'LL LEARN → Setting up multiple data views on one sheet (North / Central / South) → Building tabs from shapes, with ON and OFF states → Simple macros that show and hide columns with one click → Linking each tab to its macro so the sheet behaves like a real interface → Saving as a macro-enabled workbook without losing your work Ideal for regional sales reports, management dashboards, and clean client reports that don't need twenty separate sheets. ⏱ TIMESTAMPS 00:00 – What we're building 00:16 – The initial layout with side-by-side tables 01:18 – Inserting and styling the active tab shapes 03:35 – Creating the "off" versions 04:48 – Naming shapes properly in the Name Box (the VBA depends on this) 06:10 – Aligning everything with the Selection Pane 07:38 – The Developer tab and adding the macros 09:36 – Assigning macros to shapes to make them clickable 10:25 – Locking the shapes so they don't move when cells resize ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Macros & VBA for Non-Programmers Built for people who don't think of themselves as programmers — short lessons, practical examples, plenty of hands-on exercises. 120 lessons, 12 hours. 👉 https://mellontraining.com/go/vba ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What would you put behind your tabs — regions, months, departments? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ExcelVBA #ExcelDashboard #ExcelMacros #ExcelTutorial 12:49
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnRjeEo3Wmd3Uy0w

Excel Tabs Inside One Sheet | No More Sheet Chaos

Andreas Exadaktylos December 16, 2025 18:01

⬇️ FREE task tracker template 👉 https://mellontraining.com/task-tracker/ 🎓 Go deeper: Excel Dashboard & Data Analysis Masterclass 👉 https://mellontraining.com/go/dashboards In this video we build a Daily Activity Tracker in Excel from scratch. Type your tasks once, pick a priority from a drop-down, add 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 intimidating formulas. Clear steps you can follow even if you're completely new to Excel. 📊 WHAT YOU'LL LEARN → Data Validation for clean, foolproof drop-downs → Conditional Formatting that colour-codes priorities and statuses → COUNTIF to build live status totals → Turning those totals into a progress bar with a 100% stacked bar chart → Freezing the header row and expanding the tracker as it grows By the end you'll have a sheet you'll genuinely reuse every day. ⏱ TIMESTAMPS 00:00 – What we're building 00:59 – Setting up the layout and cell sizes 01:38 – The task table, with a clean design 04:01 – Adding the Priority drop-down 04:59 – Colour-coding priorities with Conditional Formatting 05:59 – A helper list and drop-down for Status 07:02 – COUNTIF: building the status dashboard 09:41 – Turning the numbers into a visual progress bar 12:06 – Two quick ways to auto-fill the task numbers ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Dashboard & Data Analysis Masterclass Data validation, conditional formatting and dynamic charts are the foundation of every dashboard. The course builds ten of them. 180 lessons, 21 hours. 👉 https://mellontraining.com/go/dashboards ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you tracking — work tasks, study, habits? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #TaskTracker #ExcelDashboard #ExcelTemplate #ExcelTutorial 14:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkZ2bnRuM19ZOWdN

Excel Task Tracker with Auto-Updating Progress Bar

Andreas Exadaktylos December 7, 2025 18:30

⬇️ FREE AI Prompt Pack — 50 tested Excel prompts 👉 https://mellontraining.com/excel-copilot/ 🎓 Go deeper: Excel Tips & Shortcuts — 100+ Hacks 👉 https://mellontraining.com/go/tips Stop wrestling with Excel formulas — let ChatGPT do the hard part. In this beginner-friendly tutorial I'll show you how to describe your task in plain English and get back a formula you can paste straight into your sheet. More importantly, how to spot when it's wrong, and how to fix it. ✅ WHAT YOU'LL LEARN ✔️ Writing prompts that get accurate formulas, not plausible-looking ones ✔️ Joining columns (Country Code + Phone) via ChatGPT ✔️ Calculating percentage change the easy way ✔️ Summing only unpaid customers with SUMIFS ✔️ What to do when ChatGPT's formula throws an error ✔️ Why Excel Tables make every AI prompt work better ⏱ TIMESTAMPS 00:00 – Why let ChatGPT write your formulas at all 01:24 – What makes a good prompt (name your columns and tables) 01:53 – Example 1: joining two columns with a hyphen 03:10 – Asking for alternatives, like TEXTJOIN or CONCAT 03:47 – Example 2: calculating percentage change 05:05 – Example 3: conditional sums with SUMIFS 06:20 – Recap: the habits that make prompts work 07:02 – When it hands you a broken formula ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Tips & Shortcuts: 100+ Powerful Hacks AI can write the formula. You still need to know when it's wrong — this course gives you the hundred techniques that let you check its work, and do half of it faster yourself. 8 hours, beginner pace. 👉 https://mellontraining.com/go/tips ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What formula have you been stuck on? Describe it in the comments and I'll show you how I'd prompt it. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #ChatGPT #ExcelFormulas #ExcelAI #ExcelTutorial 10:01
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmcxdlBOQWJHY0JR

Let ChatGPT Write Your Excel Formulas (Save Hours!)

Andreas Exadaktylos November 28, 2025 17:27

⬇️ FREE Kanban board + 9 more dashboard workbooks 👉 https://mellontraining.com/kanban-board-2 🎓 Go deeper: Excel Dashboard & Data Analysis Masterclass 👉 https://mellontraining.com/go/dashboards Sticky notes fall off. Project apps cost money and nobody on the team logs in. In this tutorial we build a proper Kanban board inside Excel — tasks move across the columns automatically as you change their status. No macros, no VBA, no add-ins. Just formulas and a couple of dropdowns. By the end you'll have a reusable board you can copy for every project — work sprints, client jobs, or your own to-do list. ✅ WHAT YOU'LL LEARN → Setting up a task table that won't break when you add rows → Status dropdowns with Data Validation (To Do / In Progress / Done) → Naming ranges so your formulas stay readable → The INDEX + MATCH formula that pulls each task into the right column → Conditional formatting to make empty cards disappear cleanly ⏱ TIMESTAMPS 00:00 – Formatting the Task List worksheet 03:29 – The task table and the status value table 06:53 – Adding the Status drop-down 07:25 – Naming your ranges so formulas read clearly 08:32 – VLOOKUP: generating a unique code for each task position 10:50 – Building the Kanban Board sheet and pulling the headers 13:27 – Designing the visual card template 14:40 – INDEX + MATCH: tasks land in the right column automatically 17:52 – Conditional formatting to hide empty cards 20:17 – Testing it: watching tasks move as you update them ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Dashboard & Data Analysis Masterclass INDEX/MATCH, data validation and conditional formatting are the foundation of every interactive Excel report. This board uses all three. The course builds ten complete dashboards — 180 lessons, 21 hours. 👉 https://mellontraining.com/go/dashboards ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What are you tracking on your board? Tell me in the comments — I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #KanbanBoard #ProjectManagement #ExcelDashboard #ExcelTutorial 22:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlFTQllodWdJaURv

Build a Kanban Board in Excel (No VBA Required!)

Andreas Exadaktylos November 19, 2025 21:39

⬇️ FREE Chart Pack — this heatmap + 21 more 👉 https://mellontraining.com/heatmap-excel/ 🎓 Go deeper: Excel Charts & Data Visualisation 👉 https://mellontraining.com/go/charts Turn a messy table into a clear visual — no formulas, no VBA, no add-ins. In this beginner-friendly tutorial I build a clean Excel heatmap from a sample coffee shop orders dataset. Conditional formatting does the heavy lifting; the rest is formatting tricks that make it look like something from a report rather than a spreadsheet. ✅ WHAT YOU'LL LEARN → Reorienting your data grid with Paste Special → Transpose → Adding row and column totals around the grid → The 3-colour scale that creates the heatmap itself → Thin white borders that turn cells into clean tiles → Hiding the numbers with a custom format (the three-semicolon trick) → Data bars beside the row totals → A mini chart and a simple colour legend to finish it ⏱ TIMESTAMPS 00:00 – What we're building 01:18 – The starting data and selecting the totals 02:03 – Paste Special → Transpose to orient the grid 02:46 – Adding row and column totals 03:45 – The 3-colour conditional formatting scale 04:32 – White borders for a clean tile look 05:01 – Hiding the digits with a custom number format 07:00 – Data bars next to the row totals 07:42 – A mini chart below the day columns 09:19 – Building a simple 3-colour legend ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Excel Charts, Infographics & Data Visualisation Heatmaps are one of 50+ advanced visuals in the course — the charts Excel won't build for you, taught from a blank file to finished. 90 lessons, 11 hours. 👉 https://mellontraining.com/go/charts ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎓 Free Excel course 👉 https://mellontraining.com/go/free 💬 What would you map — sales by day, staff shifts, website traffic? Tell me in the comments, I read every one. 👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've helped people go from "what is Excel?" to real-world mastery — 70,000+ students and counting. 🔔 Subscribe: https://mellontraining.com/go/subscribe 🌐 Website: https://mellontraining.com 💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos 📘 Facebook: https://www.facebook.com/mellontraining #Excel #Heatmap #ConditionalFormatting #DataVisualization #ExcelTutorial 12:41
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkprenpQalN4WWtF

Turn Messy Data Into a Beautiful Excel Heatmap (No Formulas)

Andreas Exadaktylos November 10, 2025 17:30

Load More... Subscribe

Watch: frequency tables in 10 minutes

Prefer reading? The same steps are written out below the video.

Step-by-step

A frequency table puts your data into buckets, for example how many students scored 90–100, how many 80–89, and so on. It’s a quick way to get to know a data set and the basis for a histogram. The example has 221 exam scores in column C, all whole numbers.

Method 1: the FREQUENCY function

Set up the bins. Each bin is the top of its bucket: 100 for the A range (90–100), 89 for B (80–89), 79, 69 and 59. Put them in L4:L8.

Enter the formula. In M4, type:

=FREQUENCY(C2:C222,L4:L8)

Adjust C2:C222 to your data. FREQUENCY asks for the data array and the bin array. In older versions of Excel, confirm with Ctrl+Shift+Enter because it’s an array formula. Newer versions spill the results automatically.

Read the results. You get one count per bin, plus one extra value at the end. That extra cell counts anything above your highest bin (here, any score over 100), so a zero confirms nothing fell outside your ranges. To double-check, sum the results: they should add up to 221.

Method 2: COUNTIFS (cleaner to read)

FREQUENCY works, but the bins can look confusing. COUNTIFS lets you state each range’s lower and upper limit directly. Note it’s COUNTIFS, because you’re checking two conditions.

For the 90–100 range:

=COUNTIFS(C2:C222,">=90",C2:C222,"<=100")

Copy it down and change the limits for each grade: 80 to 89, 70 to 79, 60 to 69, and 0 to 59. The counts match the FREQUENCY results, and summing them again gives 221.

Finish it as a table

Click inside your frequency table and press Ctrl+T to turn it into an Excel table, then rename the headers to something like Grade range and Number of exams.

Go further

My Excel Statistics & Data Analysis: Zero to Analyst course teaches real statistics in Excel without the maths degree.

View the course on Udemy