Mellon Training - Online Training and Video Tutorials

Mellon Training - Online Training and Video Tutorials Welcome to Mellon Training. We are an online learning company. Our purpose is to help anyone learn s I really love learning and teaching whenever i can.

Information about the CEO of Mellon Training
Hi, I am Andreas and I'm a teacher. I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school. I have a Masters Degree in Computer Science and a Degree in Electronic Engineering. I always wan

ted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well. I have a passion for software products that make people's lives easier. I love to create websites and optimizing them with Search Engine optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife. I live in Rodos, a beautiful Greek island. When i am not working, i love being with my family and my two kids. Travel, forex trading and reading books are my favorite hobbies

23/05/2026

Stop wasting your time deleting Excel numbers cell by cell! If you are still clearing out old data manually, you are losing precious time and risking breaking your formulas.
There is a much faster, completely safe way to clean up your spreadsheets instantly.

In this quick video, we show you how to use a hidden Excel feature that highlights and deletes thousands of raw numbers at the exact same time. By using a quick keyboard shortcut to access the Go To Special menu, you can tell Excel to look only for raw digits while completely ignoring your text labels and calculations. With one press of the Delete key, your workspace is cleared out for next month's data, while every single formula stays perfectly intact.

Drop a comment below if this trick is going to save you some serious time on your next project, and make sure to follow the page for daily, simple spreadsheet hacks that make your workday easier!

09/05/2026

I reviewed dozens of Excel dashboards built by professionals. And almost every single one had the same silent mistake.
The chart titles were outdated. 📊
The data had changed. The charts had updated. But the titles? Still showing last year's numbers. Last quarter's growth. Wrong percentages.
It's a credibility killer — especially when you're presenting to management.
In my latest YouTube tutorial, I show you 2 methods to fix this permanently:
✅ Method 1 → Link your chart title directly to a cell (takes 30 seconds, beginner-friendly)
✅ Method 2 → Connect it to a live formula that automatically calculates growth %, year changes, and more
Set it up once. It updates itself forever. No more manual fixes before every presentation.
🎓 Full free tutorial → [your YouTube link]
💻 Excel courses → mellontraining.com
Save this post for the next time you're building a dashboard 👇

27/04/2026

Stop working harder than your spreadsheet! 📊🛑

We’ve all been there: you have a massive list of tasks, and you’re spending half your morning manually copying and pasting them into "High," "Medium," and "Low" priority columns.It’s 2026—there’s a much faster way! 🚀By using the FILTER function, you can create a dynamic dashboard that organizes itself. When you update the main list, the priority columns update automatically. No more manual errors, no more wasted time.The Magic Formula:$$\text{=FILTER(\$B\$10:\$B\$34, \$C\$10:\$C\$34=B2, "None")}$$Why this is a game-changer:✅ Automated: Updates in real-time.✅ Clean: No more messy, disorganized lists.✅ Professional: Impress your boss with a dashboard that actually works.

Do you have a favorite Excel "cheat code"? Let us know in the comments! 👇

19/04/2026

Stop doing things the hard way! 🛑 If you’ve ever accidentally deleted a formula while trying to clear out a spreadsheet, you know how frustrating it is to fix.

The "Go To Special" trick is a total game-changer. It lets you wipe out all your old data (the numbers) while leaving your formulas and totals completely untouched. 📈✨

How to do it:
1️⃣ Select your table (Ctrl + A)
2️⃣ Open the Go To menu (Ctrl + G)
3️⃣ Click 'Special' and select 'Constants'
4️⃣ Uncheck everything except 'Numbers' and hit Delete!

Simple, fast, and formula-safe. 🚀

Know someone who lives in Excel? Tag them below! 👇

03/04/2026

Still scrolling through thousands of rows of data? ✋
There’s a better way to present your reports!

If you want to impress your boss (or just save yourself a massive headache), you need to try the Scroll Bar method. It turns a messy, overwhelming spreadsheet into a clean, professional dashboard in about 60 seconds. 📈

In this video, I’ll show you:
✅ How to unlock the hidden "Developer" tab.
✅ The secret to the OFFSET formula.
✅ How to link a scroll bar to your data for a seamless "window" view.

Tag a colleague who spends too much time in Excel! 👇

Address

Ródos

Website

,

Alerts

Be the first to know and let us send you an email when Mellon Training - Online Training and Video Tutorials posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Mellon Training - Online Training and Video Tutorials:

Shortcuts

Share

Category