MyOnlineTrainingHub

1.4K posts

MyOnlineTrainingHub banner
MyOnlineTrainingHub

MyOnlineTrainingHub

@OnlineTrainingH

I teach Excel & Power BI career transforming skills. 1M+ students globally. Follow me for Excel & Power BI Tips and Tricks.

Sunshine Coast, Australia Katılım Nisan 2010
697 Takip Edilen12.8K Takipçiler
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
There's a reason your weekly report takes hours. You're doing work that 4 formulas could do for you on autopilot. Dropdowns that update themselves. Totals that recalculate. No PivotTables. No macros. Watch here: youtu.be/QZNdbK7njhA Bonus: all courses 20% off until May 14.
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
1
59
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
You think you know conditional formatting? Most people stop at color scales. But 7 formula-based rules can turn your spreadsheet into something that watches itself. Overdue dates. Missing data. Duplicates. All flagged automatically. Watch here: youtu.be/4_HMZqdyR6I #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
1
4
222
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Excel works great. Until it doesn't. Too many users. Too many moving parts. No control over who changes what. What if you could turn your Excel file into a proper app, with one prompt? Watch the video to learn how: youtu.be/PvTUkAOAE7U
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
4
241
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Spent 10 minutes comparing two Excel files manually? Still not sure you caught everything? There are 3 ways to make Excel find every difference for you. Tutorial: youtu.be/Pi5_gRFjiCY #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
3
469
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
You built an Excel template to save time. Then someone asked how to use it. And you lost all that time writing instructions. There's a tool that documents your process as you work. No screenshots. No how-to docs. Watch the tutorial: youtu.be/a2wYmFIVzyI #Scribe #sponsored
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
2
283
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Most Excel users know Ctrl+C and Ctrl+V. Maybe Ctrl+D if they're fancy. Here are 12 shortcuts they don't know exist. Watch the video: youtu.be/ZXuh_dXeV88 ❓ Which one was new to you? #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
1
1
307
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Wildcards in Excel aren't just for formulas. They work in places most people never think to use them: - Data validation - Find & Replace - Conditional formatting And more! Watch the tutorial: youtu.be/DG6dW7ogPjU #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
1
2
248
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
You're paying for project management software. But you could build the same thing in Excel. A Gantt chart that: → Updates when dates change → Shows live progress → Color-codes completion → Highlights weekends Build it: youtu.be/vTbW8aNnWwY #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
2
330
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
PivotTables intimidate people. The problem? The interface makes no sense the first time you see it. So people avoid them forever. Here's the logic that makes them click. Watch: youtu.be/K3KqOTdypyw #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
1
2
5
516
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Your spreadsheet works great. Until you need to share it with your team. Then it's broken formulas, messy mobile views, chaos. I just turned a spreadsheet into a real app in minutes. No coding. Client portals. Booking systems. You name it: youtu.be/hT_7SaRXF_k #Sponsored
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
2
408
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
How many Excel tasks do you still do manually every week? Updating charts. Re-highlighting top values. Opening PDFs one by one. Scanning for overdue tasks. Most of this can be automated. Here are 8 simple Excel automations: youtu.be/V-cSIvJ01ek #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
2
8
716
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
You've used #Excel for years. But someone asks you to do something "simple" and you have no idea how. You don't even know what to Google. So you click around and hope nobody notices. Everyone has these gaps. Here are the tricks nobody taught you: youtu.be/-44kAiJqfI4
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
4
481
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Most Excel users never discover this trick. Two curly braces { } inside a formula. They let you: - Generate date lists - Filter and return specific columns - Sort by multiple levels instantly - Split messy text with one formula Watch the breakdown here: youtu.be/KaC0CGV8he8
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
5
32
1.2K
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Why don't people finish checklists? Because they can't see their progress. Built an Excel tracker with: - Checkboxes for tasks - Auto-updating progress bar - Visual completion percentage Turns boring lists into something you want to finish. Watch how: youtu.be/9HmYFqEumM8
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
1
336
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
NEW Excel Functions! IMPORTCSV and IMPORTTEXT: → One formula imports data → Combine with GROUPBY/SORT instantly → No hidden transformation steps → Anyone can read and troubleshoot Power Query for complexity. Formulas for simplicity. Tutorial: youtu.be/LUpzq4t2nZs #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
2
417
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Most Excel users are working twice as hard as they need to. Using VLOOKUP and nested IFs while Excel has functions that make those obsolete. GROUPBY→ PivotTables in a formula TRIMRANGE→ No wasted calculations COPILOT→ AI-power And more! See them all youtu.be/nWc4J_Uhi8s
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
6
425
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Two job listings. Same title. Same experience. One pays $60K. The other pays $120K. The difference? How Excel skills are listed. "Proficient in Excel" → ignored "Built automated reporting systems" → interview 5 Excel skills that move salary ranges: youtu.be/1mSWPLcjrrc
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
3
324
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
Most people don’t fail at budgeting because of money. They fail because tracking it feels like a chore. I built an Excel finance tracker where you just paste bank transactions… ...and everything updates automatically. Full walkthrough: youtu.be/o1ak8FjuLC8 #Excel
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
4
352
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
I’ve tested a lot of Excel tools. Very few make me say: “Okay… this changes things.” This one did. I put it through real tests, the results surprised me. Watch the breakdown: youtu.be/BIAN6yqxV4s ❓What Excel task would you give to AI tomorrow? #Excel #Endex #ExcelAI
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
5
358
MyOnlineTrainingHub
MyOnlineTrainingHub@OnlineTrainingH·
NEW Excel Copilot Agents. Copilot is no longer an assistant. It's behaving like a junior analyst. I gave it one prompt, and it built a complete financial model! Watch: youtu.be/I0k6zNC0OYQ ❓ Would you trust AI to handle your data?
YouTube video
YouTube
MyOnlineTrainingHub tweet media
English
0
0
3
467