MyOnlineTrainingHub

You're somewhere inside a workbook.

Sheet 7 of 14.

Row 847.

And all you need is to get back to the summary tab.

So you click. And scroll. And click again.

Meanwhile, the person who sent you this file is probably still waiting for your reply.

The problem is you don't know how to move through large workbooks fast.

The HYPERLINK function can turn any workbook into something you navigate in one click.

Jump to any sheet.

Open any external file.

Land on any row in a database of thousands automatically.

Watch the full tutorial and download the free practice file using the link in the post: bit.ly/hyperlink26yt

❓What does your most chaotic Excel workbook look like right now, how many sheets are we talking?

#Excel #ExcelFunctions #ExcelFormulas

Skip the Carousel

1 2 3 4 5

7 hours ago | [YT] | 97

MyOnlineTrainingHub

You've never seen Excel do this.

Most people think Excel is for numbers.

Also, for charts and formulas.

But Excel can send your WhatsApp messages too.

Yes, actual WhatsApp messages to real phone numbers.

You can personalize a message for every customer from one spreadsheet.

Payment reminders. Appointment confirmations. Promos. Thank-you notes.

Send in seconds!

Watch the full tutorial + download the free practice file: bit.ly/whatsapp26yt

❓ What would you use this for first?

#Excel #ExcelAutomation #WhatsApp

Skip the Carousel

1 2 3 4 5

2 days ago | [YT] | 344

MyOnlineTrainingHub

Cancel the project management subscription.

You can build a fully modern, color-coded Gantt chart in Excel.

For free.

It runs on just 3 inputs:
→ Start date
→ Duration
→ Progress

And it does the rest automatically:

- Live progress bars that fill as work gets done.
- Timelines that shift when dates change.
- Completed tasks that turn green on their own.
- Today's date highlighted, every day.

📌 Watch the full tutorial + download the free template ready to use at work tomorrow: bit.ly/gantt26yt

❓ What are you currently using to manage projects?

#Excel #ExcelTemplate #ProjectManagement

Skip the Carousel

1 2 3 4 5

5 days ago | [YT] | 471

MyOnlineTrainingHub

You're still using VLOOKUP, aren't you?

And CONCATENATE.

Maybe some INDIRECT.

They work.

But they're also slow, fragile, and harder to maintain than they need to be.

Excel has quietly replaced most of the formulas people learned 5+ years ago.

The problem is nobody announces when a formula becomes outdated.

So you keep using what you know, even though there's a better option sitting right there.

This video walks through the old formulas still showing up in spreadsheets everywhere and what actually replaced them.

Worth watching if you learned Excel before 2021: https://youtu.be/teZgWftPT-w

❓Which Excel formula do you use most often?

#Excel #ExcelFunctions #ExcelFormulas

6 days ago | [YT] | 67

MyOnlineTrainingHub

I see people manually transpose data by hand.

🆓 Download the hi-res cheatsheet + watch the video: bit.ly/special26yt

Rewrite formulas after pasting.

Clean up formatting they didn't ask for.

All of this is already built into Excel.

You just have to know where to look.

The cheatsheet covers all 10 uses with examples.

❓Which one didn't you know about?

#Excel #ExcelTips #ExcelTutorial

1 week ago | [YT] | 495

MyOnlineTrainingHub

You're only using 10% of SUM.

Most people think SUM just adds up numbers.

That's it. That's the whole function.

But SUM can quietly do the job of COUNTIFS, SUMIFS, and AVERAGEIFS.

And it can handle things those functions simply can't.

Watch the full tutorial + download the free practice file with every example built and ready to use: bit.ly/sum26yt

❓ Did you know SUM could do more than add numbers?

#Excel #ExcelFunctions #ExcelFormulas

Skip the Carousel

1 2 3 4 5

1 week ago | [YT] | 374

MyOnlineTrainingHub

Sales teams pay $25-300 per user/month for a CRM.
You can build one in Excel for $0.

I'm not talking about a basic contact list.

I'm talking about a real CRM that:

→ Pulls customer details, interactions, and opportunities from one place.
→ Filters active leads by industry, stage, or value with one click.
→ Updates automatically when new deals come in (no manual entry).
→ Lets you switch between customers from a drop-down and watch every field refresh instantly.

The secret? An underrated Power Query feature called custom data types.

👉 Watch the full step-by-step tutorial + download the free CRM template here: bit.ly/crm26yt

❓ What CRM are you using right now (or are you still living in spreadsheet chaos)?

#Excel #PowerQuery #ExcelTemplate

Skip the Carousel

1 2 3 4 5

1 week ago | [YT] | 470

MyOnlineTrainingHub

A few hours left to get 20% off.

This time next week you could be:

The person who finally understands why formulas break.
And knows exactly how to fix them in seconds.

The person whose reports update automatically.
No more eating up half your Monday.

The person colleagues come to when Excel isn't working.

That's what these courses actually do.

❗20% off ends tonight, hurry up: bit.ly/hours26yt

#Excel #ExcelCourses #ExcelTips

1 week ago | [YT] | 69

MyOnlineTrainingHub

The Excel functions every data analyst actually needs (all in one place).

🆓 Download the multi-page, high-res cheatsheet: bit.ly/dataanalysts26yt

20 functions across logic, lookup, dates, and more.

Each one with syntax and a real example so you can use it straight away.

Bookmark this. You'll come back to it.

❓ Which function took you the longest to finally understand?

🎁 Bonus: all my courses are 20% off until May 14, with a 30-day guarantee: www.myonlinetraininghub.com/excel-tabular-data-for…

#Excel #ExcelTips #DataAnalysis

2 weeks ago | [YT] | 501

MyOnlineTrainingHub

A weekly report takes most people 2-3 hours to rebuild.

That's 100+ hours a year doing the same thing over and over.

This Excel report does it for you.

- Self-updating drop-downs.
- One-click filtering across the whole report.
- Your top result, surfaced automatically.

And you need just 4 formulas.

Watch the tutorial + download the free template: bit.ly/report26yt

🎁 Bonus: all my courses are 20% off until May 14, with a 30-day guarantee (link in the comments).

❓ How many hours a week do you lose to manual reports?

#Excel #ExcelFormulas #ExcelForBusiness

Skip the Carousel

1 2 3 4 5

2 weeks ago | [YT] | 348