Skip to main content
AmigoFish

MyOnlineTrainingHub

MyOnlineTrainingHubVideo

Format:
YouTube channel
New videos:
Weekly
Typical length:
about 10 minutes
Latest video:
Not rated yet

About this show

Teaching you Excel and Power BI skills that will get you noticed and promoted. For more, check out my courses here: https://www.myonlinetraininghub.com/courses

Covers: spreadsheets, microsoft excel, excel formulas, data analysis, excel templates, business reporting, copilot AI, excel tutorials

Videos come from the channel's public YouTube feed. The artwork is the newest video thumbnail. Last updated . Names, artwork and text belong to their publishers.

Recently on this show

Summary of recent videos, drawn from the publisher's feed.

MyOnlineTrainingHub is a video channel teaching Excel and Power BI skills for work. Recent videos cover unusual Excel functions, a free automatic shift calendar template, checks for AI-generated spreadsheets, and a subscription audit dashboard.

Report a problem with this summary

Cosmos

Similar in subject

See the full Cosmos

Similar shows

See all Education shows

Explore more

Videos

  • The Excel Gantt Chart That Replaces Your Project Management Tool

    · 15 min

    Make a simple Gantt chart in Excel for project management from scratch. 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/gantt26course ⬇️ Download the example file here and follow along: https://bit.ly/gantt26file 🎬 MORE FREE EXCEL TEMPLATES, full playlist here: https://bit.ly/templates26playlist Most teams end up paying for tools like Asana, Monday, or Notion just to manage a simple project timeline. Not because Excel can't do it, but because every time they try to build a Gantt chart in Excel it ends up looking confusing, fragile, or just plain ugly. Today, I'm going to show you how to build a fully modern, color-coded Gantt chart that automatically updates when your dates change and shows live progress on every task. Right here in Excel, for free. And the best part is that this entire chart runs on just three inputs: start date, duration, and progress. Once those are entered, everything else updates automatically. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #GanttChart #ProjectManagement

    Not rated yet
  • Excel PivotTables Made Easy in 2026 (+ What's Changed!)

    · 16 min

    Analyze data in Excel and turn it into a summary with PivotTables, suitable for beginners and pros. ⬇️ Download the example file here and follow along: https://bit.ly/pivottables26file 👩‍🏫 Become an Excel Dashboard master with my course: https://bit.ly/pivottables26course PivotTables are the single most powerful tool in Excel for analyzing data, and they're probably the one skill most Excel users keep putting off learning. With a PivotTable, you can take thousands of rows of raw data and turn it into a clear, meaningful summary in under a minute. Whether you've never built a PivotTable before or you use them regularly, this video has something for you. I'm covering the essentials, the mistakes that silently break PivotTables, and a couple of things that have changed recently that'll make you faster. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Why PivotTables are so special 0:36 How to create a PivotTable (AVOID this mistake) 4:37 To to make changes in a PivotTable 4:59 What you can automatically do with values 5:52 How to change a layout of a PivotTable 6:11 If you don't know where to start with a PivotTable (AI alternatives) 8:21 Dashboards is the next step you need 8:34 PivotTable trick many users don't know about 10:00 Two features will make your PivotTables more powerful 12:13 Useful trick for slicers 12:52 How to update a PivotTable if the data changes 14:02 Mistakes that make PivotTables difficult 16:36 The next MUST have tool in your arsenal #Excel #PivotTable #PivotTables

    Not rated yet
  • Convert an Excel Spreadsheet to an App in Minutes Using Glide

    · 50 sec

    Transform a simple Excel spreadsheet to a fully working app in under 10 minutes using Glide. Try Glide here: https://bit.ly/glide-excel This video is sponsored by Glide. The link above is an affiliate link, which means I may earn a small commission if you sign up, at no extra cost to you. Learn more about Glide on their YouTube channel @glideapps ⬇️ Download the Excel file used in this demo: https://bit.ly/glide26file LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #GlidePartner #Sponsored #Ad

    Not rated yet
  • From Excel File to Mobile App in Under 10 Minutes | Glide

    · 10 min

    Transform a simple Excel spreadsheet to a fully working app in under 10 minutes using Glide. Try Glide here: https://bit.ly/glide-excel This video is sponsored by Glide. The link above is an affiliate link, which means I may earn a small commission if you sign up, at no extra cost to you. Learn more about Glide on their YouTube channel @glideapps ⬇️ Download the Excel file used in this demo: https://bit.ly/glide26file LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #GlidePartner #Ad

    Not rated yet
  • SIMPLE Excel Automations I Use EVERY DAY (and you should too!)

    · 15 min

    Automate your work in Excel with no coding, suitable even for complete beginners. ⬇️ Download the example file here and follow along: https://bit.ly/automations26file 👩‍🏫 Master Excel Dashboard with my course: https://bit.ly/automations26course How many times have you manually updated a chart, re-highlighted a deadline, or hunted down a file that should have been one click away? Most Excel users don't realize that half the things they do manually every single week, Excel can do automatically. Today, I'm going to show you 8 very simple Excel automations that will save you hours of time in the future. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Excel can do these and more automatically 0:26 The easiest trick that makes a difference 1:10 Automation for every office worker 3:06 If you work with reports regularly 3:39 Make Excel read your mind 4:44 You wish you knew this automation sooner 6:15 Make Excel highlight what's important 8:11 You literally need this one tool to skip many others 10:06 The most surprising automation 12:58 Automation that saves you the most time 14:50 The settings you need to change #Excel #ExcelAutomation #ExcelTutorial

    Not rated yet
  • 7 Excel Tricks You'll Wish You'd Learned on Day One

    · 14 min

    Excel tricks that work for any job: beginner, intermediate, and advanced. 👩‍🏫 Get the Data Analyst Fast Track course: https://bit.ly/jobskills26course ⬇️ Download the example file here and follow along: https://bit.ly/jobskills26yt 👩‍🏫 Get my Excel & Power BI courses: https://bit.ly/jobskills26courses ⬇️ Download the automated invoice template: https://bit.ly/3MMRmWZ Stop doing repetitive spreadsheet tasks the hard way! In this video, we cover 7 practical Excel techniques that solve common workplace headaches, from making your formulas and charts expand automatically with Ctrl + T to building interactive slicers and dynamic auto-adjusting print areas. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Excel tricks you'll need at any job 0:54 Convert data to an Excel Table (Ctrl + T) 3:02 Interactive visual slicers for tables 5:36 Focus Cell row & column highlighter 6:15 Flash Fill to split & format data (Ctrl + E) 6:57 Fill blank cells fast (Go To Special) 7:40 Data validation & custom input guidance 9:57 Dynamic print ranges for invoices & PDFs 14:22 Excel functions you'll need at any job #Excel #ExcelForWork #ExcelTricks

    Not rated yet
  • STOP Writing Multiple Formulas When One Will Do

    · 8 min

    How to use curly braces in Excel formulas to make functions do more. 👩‍🏫 Master Advanced Excel Formulas with 20% off until February 26, 2026: https://bit.ly/curlybraces26course ⬇️ Download the example file here and follow along: https://bit.ly/curlybraces26file Most Excel users aren’t aware they can use curly braces inside functions like DATE, XLOOKUP, SORT and more to unlock behavior and advanced tricks. I’m going to show you a handful of examples you can use immediately. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Did you know you could do this in Excel? 0:15 The very basics of curly braces in Excel 0:54 The DATE function with curly braces 1:52 The FILTER & CHOOSE combination with curly braces 3:18 The VSTACK function with curly braces 4:08 The XLOOKUP function with curly braces 5:10 LIMITED-TIME DISCOUNT 5:28 The SORT function with curly braces 6:32 The TEXTSPLIT function with curly braces 7:40 You absolutely need to know these functions #Excel #ExcelFormulas #ExcelSymbols

    Not rated yet
  • Build a Self-Updating Checklist & Progress Bar (No VBA!)

    · 12 min

    Try Scribe for free: https://scribe.how/MOTH ⬇️ Download the example file here and follow along: https://bit.ly/checklist26file 👩‍🏫 Learn Advanced Excel Functions and Formulas: https://bit.ly/checklist26course 🎬 MORE FREE EXCEL TEMPLATES, full playlist here: https://bit.ly/templates26playlist Create an Excel checklist that automatically prioritizes tasks, highlights urgent vs completed items, and tracks overall progress. As you check tasks off, everything updates automatically; no VBA coding required. Works for any project: product launches, content calendars, event planning, or everyday life. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #ExcelTutorial #ExcelTemplate

    Not rated yet
  • How to Start Making Money with Excel (Beginner Level)

    · 29 sec

    Beginner ways to make money with Excel both offline and online, working from home. ⬇️ Click here to learn more about other opportunities and how to get them: https://bit.ly/money26yt LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #ExcelJobs #HighPayingSkills

    Not rated yet
  • Excel Just Made File Imports Ridiculously Simple (New Functions)

    · 7 min

    Excel has just made Power Query optional with these new functions: IMPORTCSV and IMPORTTEXT. ⬇️ Download the example file here and follow along: https://bit.ly/import26file ▶️ Excel LET Function video: https://youtu.be/5eOII3sq8wY 👩‍🏫 Join my Excel and Power BI courses: https://bit.ly/import26courses ⬇️ Join the Microsoft 365 beta program: https://techcommunity.microsoft.com/category/microsoft365/kb/microsoft-365-insider-kb Excel has two new functions that make importing data from CSV and Text files super easy and most importantly, completely transparent. Don’t get me wrong, Power Query is still my favourite tool for gathering and cleaning data, but CSV and Text Files are typically already clean, so Power Query can feel like overkill. Plus, if anything goes wrong down the track, the Power Query settings are all encoded in the query editor, which can be daunting to try and troubleshoot. Whereas with these new functions, the encoding and structure are explicit, visible and easy to control. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #ExcelFunctions #PowerQuery

    Not rated yet