MyOnlineTrainingHub

Want to sound like the Excel pro in the room?

You don’t need to know everything , just say the right things.

Here are a few lines to drop in your next meeting 😏

Want to actually become an Excel pro (with support, certificate & lifetime access)?

Then, check out my courses here because they provide all these: bit.ly/prophrases25yt

❓What’s your go-to Excel flex?

#Excel #ExcelCourses #ExcelTraining

Skip the Carousel

1 2 3 4 5

1 day ago | [YT] | 172

MyOnlineTrainingHub

If you use Excel every day, change these settings now.

🆓 Get the full cheatsheet here: bit.ly/settings25yt

These defaults cause mistakes, formatting issues, and wasted time.

Fix them once, and you’ll never deal with them again.

❓ Which one drives you crazy the most?

#Excel #ExcelCheatsheet #ExcelTips

3 days ago | [YT] | 551

MyOnlineTrainingHub

If you work with Excel daily, changing these settings is non-negotiable.

They won’t make your spreadsheets prettier.
They’ll make them work the way you expect them to.

No more weird formatting.
No more formulas breaking for no reason.
No more Excel fighting back.

Watch the 15 settings I change on every install: https://youtu.be/Xa10Eb8pOuc

❓Which Excel setting drives you absolutely crazy?

#Excel #ExcelTutorial #ExcelTips

3 days ago | [YT] | 169

MyOnlineTrainingHub

Dynamic drop-down lists in Excel used to be a nightmare.

Static. Fragile. Hard to maintain.

And adding a third level? Forget it.

Now, there’s a better way.

In this throwback video, you’ll learn how to build:

✅ Dependent drop-downs that grow with your data.
✅ Multi-level lists without complicated array formulas.
✅ A setup that feels almost... effortless.

One formula even uses a little-known Excel trick that reacts to the last cell you edited.
(Yes, that’s a thing.)

🎥 Watch the full tutorial and download the practice file here: https://youtu.be/RXSH2UiDc5g

❓Have you ever tried setting up dependent lists before? How did it go?

#Excel #ExcelTutorial #ExcelTips

1 week ago | [YT] | 96

MyOnlineTrainingHub

If you're in finance or accounting and not using these functions,
You're missing out.

🆓 Download the hi-res cheatsheet here: bit.ly/accfin25yt

Yesterday, I shared a video on Excel’s newest functions for finance & accounting.

Today, here's the cheatsheet to make them stick.

❓Which function do you think more pros should start using?

#Excel #ExcelFunctions #ExcelFormulas

1 week ago | [YT] | 545

MyOnlineTrainingHub

If I had these Excel functions back in my accounting days…
I’d have worked half the hours.

But hey, you get to benefit from them now.

These new functions do things like:

- Combine data from multiple sheets (instantly).
- Build dynamic ranges with no extra formulas.
- Calculate running totals automatically.
- Replace PivotTables with formulas (yes, really).

In my new video, I walk through the functions that can change the way you work with data in Excel, especially if you're in accounting or finance.

📌 Watch here: https://youtu.be/vP5w0NErZ64

❓Which of these new Excel functions do you wish you'd learned sooner?

#Excel #ExcelFormulas #ExcelFunctions

1 week ago | [YT] | 134

MyOnlineTrainingHub

We’ve all said things like this, right?

Now it’s your turn, what’s your favorite Excel-ism?

👇 Share it in the comments & let’s build Part 2 together.

Skip the Carousel

1 2 3 4 5

1 week ago | [YT] | 235

MyOnlineTrainingHub

Trying to figure out what’s unique in your data?

Excel has a function for that, and it’s ridiculously simple.

UNIQUE helps you spot patterns, one-offs, or build dynamic lists in seconds.

🎥 Watch the tutorial + get the free practice file: bit.ly/fotwunique25yt

❓What’s one Excel task you wish was easier?

#Excel #ExcelFormulas #ExcelFunctions

Skip the Carousel

1 2 3 4 5

2 weeks ago | [YT] | 396

MyOnlineTrainingHub

Your dashboard shouldn’t fall apart every time someone changes the timeframe.

Most project dashboards:
❌ Can’t toggle between days, weeks, or months.
❌ Break when the data shifts.
❌ Force you to build 3 different versions.

This one does it better:
✅ One dashboard.
✅ One dataset.
✅ Three dynamic views (daily, weekly, monthly).

All controlled with a simple button click.

No VBA. No complex tools.

Just Excel doing smart things with CHOOSE, SWITCH, and a few form controls.

Perfect for project tracking and managing schedules.

🎥 Watch the tutorial and download the template here: https://youtu.be/VU4ncBR0PYw

❓Have you ever had to rebuild your dashboard just to answer a “Can I see this by week?” question?

#Excel #ExcelDashboard #ExcelTutorial

2 weeks ago | [YT] | 76

MyOnlineTrainingHub

If your PivotTables look basic… you're missing the good stuff.

🆓 Download the hi-res cheatsheet here: bit.ly/ptinsights25yt

Most users build PivotTables.
Few actually customize them.

This guide walks you through tricks that turn boring tables into insight machines.

Because it’s not about creating more reports.
It’s about creating more efficient ones.

❓What’s one PivotTable trick you wish more people knew?

#Excel #ExcelCheatSheet #ExcelTips

2 weeks ago | [YT] | 476