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

  • Excel Defaults You'll Wish You'd Turned Off Years Ago (+Cheatsheet)

    · 13 min

    Tired of Excel turning text into dates, resizing your columns, or AutoSaving changes you didn’t want? Here are 15 default settings you should turn off today. ⬇️ Download the cheatsheet and the example file here: https://bit.ly/defaults26file 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/defaults26course Most of Excel’s default settings are designed for general use, but in daily work, they often get in the way. In this tutorial, we walk through 15 settings to change once so your spreadsheets stay clean, predictable, and frustration-free. What we cover: • How to stop Excel from guessing dates and changing your text. • Cleaning up PivotTable defaults (tabular layout, fixed column widths, date grouping). • Turning off unhelpful formula prompts and Copilot popups. • Disabling AutoSave to keep test files safe. • Setting up your preferred font, layout, and startup view. 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 Fix these before Excel annoys you 0:30 Stop turning text into dates 1:51 Turn off those green corner triangles 02:42 Pick your own default font 03:46 Hide the gridlines 04:21 Normal cell references instead of table names 05:06 AutoSave saving when you didn’t want it to 06:15 Better default layout for PivotTables 07:20 Stop columns resizing every time you refresh 08:05 Stop grouping dates automatically 08:30 Copying multiple things at once 10:01 Open straight to a blank workbook 10:32 Stop opening links in Excel for Web 11:08 Turn off Copilot formula popups 11:49 Make the top search bar smaller 12:24 Show file extensions (.xlsx) 13:20 Tricks you wish you'd learned sooner #Excel #ExcelSettings #ExcelTutorial

    Not rated yet
  • Why Top Consulting Firms Are Using This Excel AI

    · 10 min

    Click here to try Tracelight, and use code MYNDA for 1 month free of Tracelight Pro: https://tracelight.link/myndafree Tracelight is live with 7 of the top 10 consultancies (including MBB and Big 4 firms), PE funds with over $600B AUM, and Fortune 500 teams. ⬇️ Download the example file here and follow along: https://www.myonlinetraininghub.com/new-excel-ai-tool-for-financial-models What happens when someone gives you a 12-month general ledger in a PDF and says, “Can you turn this into a financial model with a 6- month forecast?” Normally, that means hours of extracting data, checking transactions, mapping accounts, and trying to balance the statements. But what if AI could take that source document, build the P&L and Balance Sheet, link formulas back to the underlying transactions, and show you exactly where every number came from? And then turn the finished model into an interactive forecast app where anyone can adjust assumptions and immediately see the impact? That’s what I’m testing today with Tracelight. Tracelight is sponsoring this video, but I’ll be putting it through a practical financial-modelling workflow to see how far it can really take us. 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 The request that used to cost you a whole day 0:53 The messy PDF ledger we're starting with 1:22 Importing a PDF straight into Excel 2:22 See exactly where every number came from 2:41 Building the P&L and Balance Sheet from scratch 3:21 Save your prompts and reuse them anytime 3:45 How it maps and classifies your accounts 4:01 A P&L that updates itself as data grows 4:32 The Balance Sheet that reconciles automatically 4:43 A one-page dashboard, built in seconds 4:59 Verify any formula in plain English 5:56 Turning the model into a live forecast 7:00 The interactive app you can share with a link 8:02 Catching hidden errors before they cost you 8:45 Spotting exactly what changed between versions 9:39 Why this beats a general AI tool for finance #Excel #Tracelight #FinancialModeling

    Not rated yet
  • Most Excel Users Don’t Know You Can Do This Inside a Formula

    · 7 min

    Excel N function trick: hide comments inside your formulas so they explain themselves. 👩‍🏫 Learn more Excel functions and formulas with my course: https://bit.ly/tif26course ⬇️ Download the example file here and follow along: https://bit.ly/tifn26file If you scroll through Excel’s function list, there’s one function that looks completely pointless. It’s called N. But for those in the know, N lets you hide comments inside your formulas, so they literally explain themselves. Today, I'll show you how to add comments inside your formulas at the beginner, intermediate, and advanced levels, where it breaks, and how to fix it when it does. 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 A pointless-looking Excel function that is brilliant 0:20 What the N function actually does 0:50 The one N behavior we're going to exploit 1:10 Add a hidden comment using N 2:31 Where the N trick breaks and the solution 4:28 One more reason N isn't as pointless as it looks 5:04 Modern alternative to N 6:49 When you should use N and LET 7:14 10 modern functions hiding in plain sight #Excel #ExcelFunctions #ExcelFormulas

    Not rated yet
  • Find & Replace Can Do This? (Most People Have No Idea)

    · 9 min

    Find and Replace tricks in Excel most people have never used: replace by format, wildcards, fix formulas, whole-workbook replace, and line breaks. 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/findreplace26course ⬇️ Download the example file here and follow along: https://bit.ly/findreplace26file 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 The Find and Replace options most people never open 0:26 Change cell formatting without touching the values 2:17 Clean up messy data with wildcards 4:56 Update hard-coded values inside your formulas 6:33 Replace text across an entire workbook at once 7:34 Find and replace line breaks (the hidden trick) 9:00 Excel tricks you wish someone had shown you years ago #Excel #ExcelTools #ExcelTips

    Not rated yet
  • Next-Gen Spreadsheets Are Here. Are You Using One?

    · 10 min

    Watch Quadratic clean messy data, write Python and SQL, build interactive charts, and generate an executive summary inside one spreadsheet. 👉 Sign up to Quadratic for free here: https://bit.ly/quad-moth ⬇️ Download the example file here and follow along: https://www.myonlinetraininghub.com/automate-reporting-with-quadratic 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 What if one spreadsheet could do all of this? 0:48 The messy e-commerce data we're starting with 1:12 A quick tour of the Quadratic workspace 2:55 Watch it clean dates that are stored as text 3:32 Catch and remove hidden duplicate records 3:41 Summarize data across multiple sheets with one prompt 5:48 Build interactive charts without writing Python 6:41 Score each category for opportunity and risk 7:58 Generate an executive summary for management #Excel #Quadratic #AISpreadsheet

    Not rated yet
  • Build an Excel Mini Dashboard with One Function (yes, it’s real)

    · 11 min

    Build a mini Excel dashboard with bar charts, progress bars, and star ratings inside your cells, using the REPT function and no chart objects. 👩‍🏫 Learn more Excel functions and formulas with my course: https://bit.ly/rept26course ⬇️ Download the example file here and follow along: https://bit.ly/rept26file 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 The Excel function that builds charts inside cells 0:34 How REPT works (and the one quirk to watch for) 1:05 Build in-cell bar charts from your sales data 2:30 Color-code your bars by value automatically 4:28 Turn completion rates into clean progress bars 7:21 Why bar width controls how much detail you see 8:25 Build star ratings out of 5 for any score 10:45 If you want to build an interactive dashboard #Excel #ExcelFunctions #ExcelDashboard

    Not rated yet
  • You'll Wish You Found Genspark Before Your Last Report

    · 7 min

    Genspark is an all-in-one workspace that just hit $250M ARR in 12 months + Get started bonus. New users can also trial pro-tier deep research and AI web app building for free via the 'Get Started' bonus: https://bit.ly/genspark-moth Download the practice files and prompt here: https://www.myonlinetraininghub.com/from-business-files-to-management-reports-with-genspark-ai This video is sponsored by @GensparkProduct (https://www.youtube.com/@GensparkProduct) 🔗 FOLLOW GENSPARK ON SOCIAL MEDIA =========== X (Twitter): https://x.com/genspark_ai Instagram (Global): https://www.instagram.com/genspark_ai/ Instagram (Brazil): https://www.instagram.com/gensparkbrasil/ Instagram (Japan): https://www.instagram.com/genspark_japan/ Instagram (Korea): https://www.instagram.com/genspark_korea/ TikTok: https://www.tiktok.com/@genspark_ai LinkedIn: https://www.linkedin.com/company/genspark/ YouTube: https://www.youtube.com/@GensparkProduct 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 What if AI worked like an assistant, not a chatbot? 0:12 One messy pile of files, one Genspark prompt 2:40 What the Genspark Super Agent came back with 2:55 AI Sheets builds the spreadsheet for you (24 sheets) 3:50 AI Slides turns it into a presentation 4:31 AI Docs writes the action plan 6:01 Genspark Claw can start it all from your inbox 6:41 Genspark plugins for PowerPoint, Excel, and Word 7:20 Why your Excel skills still matter #Genspark #WorkwithGenspark

    Not rated yet
  • Say Goodbye to Ugly Excel Numbers with These Tricks (FREE Cheatsheet)

    · 15 min

    Make Excel numbers look professional in seconds with 10 custom number format codes. 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/formats26course ⬇️ Download the example file here and follow along: https://bit.ly/formats26file Most people think Excel formatting is just commas, decimals and dates. But custom number formats can make numbers behave visually in ways most Excel users never realize are possible. They can turn numbers into text without a formula, add arrows and colors without conditional formatting, hide values without deleting them, fill cells with dots or lines automatically, and show units without converting numbers to text. The best part is, underneath, the values are still numbers, so your formulas, PivotTables and charts keep working. 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 The Excel formatting tricks most people never find 0:37 Turn thousands and millions into clean, readable numbers 3:09 Color-code values without conditional formatting 5:20 Display text instead of the actual value 6:39 Make cluttering zeros disappear (without deleting them) 7:24 Add up and down arrows to your variances 10:07 Format phone numbers so Excel stops breaking them 11:02 Bend dates into any format you need 12:28 Add units like kg or km without breaking your numbers 13:13 Hide numbers in plain sight for meetings 14:00 Auto-fill cells with lines and dots for forms 15:11 7 everyday Excel tricks to work twice as fast #Excel #ExcelTutorial #ExcelTricks

    Not rated yet
  • Experienced Excel Users Are Replacing IF With These Functions

    · 13 min

    6 Excel functions that simplify the formulas you thought needed IF. 👩‍🏫 Learn more Excel functions and formulas with my course: https://bit.ly/beyondif26course ⬇️ Download the example file here and follow along: https://bit.ly/beyondif26file IF is one of the most useful functions in Excel. But it's also one of the most overused. People reach for it for everything, so they end up with formulas that look like this, when what they actually wanted was something like this. The problem isn't that IF is bad. The problem is that IF is often doing a job another function was designed to do better. So, in this video, I’m going to show you the alternatives to IF and by the end, you'll have a clear understanding of when to use each. 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 IF is the most overused function in Excel 0:35 1. Handles multiple conditions without nesting 2:30 2. Pulls rates from a table instead of hard-coding them 4:12 3. Tests one value, returns a different calculation for each 6:43 4. Turns a number into the right result instantly 9:17 5. Gets totals and counts without helper columns 11:15 6. Stops repeating the same calculation in one formula 13:13 15 Excel functions every professional should know #Excel #ExcelFunctions #ExcelFormulas

    Not rated yet
  • 9 Excel Myths You Should STOP Believing Today!

    · 14 min

    In this video, I’m busting 9 of the most common Excel myths, with the real story behind each one, so you stop second-guessing yourself. 👩‍🏫 Master Advanced Excel Formulas with my course: https://bit.ly/myths26course ⬇️ Download the example file here and follow along: https://bit.ly/myths26file 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 Not all Excel advice is good 0:27 Are volatile functions really slowing your file down? 1:56 Why people blame Tables for the wrong thing 3:34 Are PivotTables still worth using? 5:00 The limit on how much data Excel can handle 6:23 When whole-column references are actually fine 8:22 Will formatting whole rows blow up your file? 9:44 Does saving as .xlsb really make files better? 12:14 Why helper columns aren't amateur 12:51 Do you need VBA to automate Excel? 14:35 Automate the boring Excel tasks next #Excel #ExcelForWork #ExcelForBusiness

    Not rated yet
  • Build an Excel Pricing Calculator with What-If Analysis (FREE Template)

    · 10 min

    Build an Excel pricing calculator with What-If Analysis tool for service-based businesses. 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/pricing26course ⬇️ Download the example file here and follow along: https://bit.ly/pricing26file 🎬 MORE FREE EXCEL TEMPLATES, full playlist here: https://bit.ly/templates26playlist 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 your hourly rate is probably wrong 0:33 What you're going to get 1:03 Plug in your real numbers 1:45 Calculate how much of your time is actually billable 2:33 The hourly rate your income goal really needs 3:19 See every scenario side by side 6:11 Reverse-engineer your rate with Goal Seek 6:24 What if the market won't pay what you need? 8:21 Could working more hours solve it? 8:40 The reality check most freelancers avoid 10:01 Build Excel files that don't fall apart #Excel #ExcelTemplate #ExcelTutorial

    Not rated yet
  • 6 Excel Tricks That Stop Other People from Breaking Your Files

    · 10 min

    6 Excel techniques to protect your sheet, workbook, or data before sharing it with others. 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/protection26yt 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 The 6 tricks that stop people from breaking your file 0:19 Lock formulas without locking everything 2:01 Hide your formulas so no one can copy them 3:12 Stop people from deleting or renaming your sheets 5:03 Make sheets disappear without deleting them 6:44 The personal info Excel quietly attaches to every file 8:06 Encrypt the whole file 9:47 Which Excel passwords are actually safe #Excel #ExcelTips #ExcelTutorial

    Not rated yet
  • The Excel Tool That Does What PivotTables Can't Calculate

    · 11 min

    In this video, I’ll show you 3 common reporting problems regular PivotTables struggle with, and how Power Pivot solves them properly. 👩‍🏫 Take my Power Pivot and DAX course with 20% off until May 14, 2026: https://bit.ly/dax26course ⬇️ Download the example file here and follow along: https://bit.ly/dax26file 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 your PivotTable can't handle real-world data 1:49 Turn on the feature Excel hides from you 2:18 Set up your data the right way 2:53 Connect 3 tables without a single lookup 4:46 Build one PivotTable from 3 separate tables 5:34 Write your first DAX measures 9:51 The invisible logic behind every DAX measure 11:27 The Excel skills companies are paying more for #Excel #PivotTable #PowerPivot

    Not rated yet
  • Build a Dynamic Excel Report from Scratch (Even If You're a Beginner)

    · 14 min

    Build an automated, dynamic Excel report from scratch using four essential formulas. Use dynamic arrays and dependent drop-down lists to keep your data updating itself. ⬇️ Download the example file here and follow along: https://bit.ly/dynamic26file 👩‍🏫 Take my Excel Expert course: https://bit.ly/dynamic26course 👩‍🏫 Master Excel & Power BI with my courses: https://bit.ly/dynamic26coursesyt In this video, you'll learn: - The foundation: how to properly structure your workbook and use Excel Tables so your reports expand automatically when new data arrives. - Dynamic drop-down lists: how to combine UNIQUE and SORT with the spill operator (#) to create self-updating data validation lists. - Dependent drop-downs: using FILTER so your second drop-down list only shows options relevant to the first selection. - The main report: extracting multi-criteria filtered results using boolean logic (* for AND, + for OR) without PivotTables or VBA. - Executive summary cards: Using modern functions like GROUPBY, CHOOSECOLS, TAKE, and IFERROR to highlight top performers at a glance. - Common gotchas: How to fix #SPILL! errors, avoid Table/Dynamic Array conflicts, and ensure your Excel version supports these formulas. 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 Quick preview of the dynamic dashboard 01:01 Format source data 02:16 Dynamic lists with UNIQUE & SORT 04:16 Drop-downs with the spill operator 05:19 Main report with FILTER 09:13 Dependent drop-downs 10:12 Summary cards with GROUPBY & TAKE 12:54 Testing with new data 13:18 Common mistakes & #SPILL! errors 14:07 More things Excel can do for you automatically #Excel #ExcelTricks #ExcelProductivity

    Not rated yet
  • Most Excel Users Don't Know Conditional Formatting Can Do This

    · 17 min

    Learn Excel conditional formatting with formulas to highlight rows based on a cell value. 👩‍🏫 Learn more about my Advanced Excel Formulas course: https://bit.ly/cfformulas26course ⬇️ Download the example file here and follow along: https://bit.ly/cfformulas26file Most Excel users never go beyond the built-in conditional formatting rules: a colour scale here, a "greater than" rule there. But the moment you start using formulas, everything changes. Formula-based conditional formatting lets you highlight entire rows, flag missing data, catch errors, track deadlines; all automatically, in real time. In this video, I'll show you the rules that will save you from manually scanning your spreadsheet trying to spot problems. Real-world examples, practical scenarios, stuff you'll actually use. 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 What most Excel users are missing 0:36 Format entire rows based on one cell 2:23 Compare two columns with conditional formatting 4:38 Flag rows with missing data 7:15 Make Excel search and highlight keywords 9:17 Create date-based alerts that update themselves daily 11:39 Detect duplicates Excel's built-in tool misses 14:42 Banded rows that survive filters 17:14 Excel functions every professional should know #Excel #ConditionalFormattingInExcel #ExcelTutorial

    Not rated yet
  • Outgrown Excel? This AI Tool Does What Excel Can't

    · 7 min

    Try Zite with your own Excel data → https://try.fillout.com/mynda-treacy-01xr Free to start + 50% extra credits included. Using this link supports the channel. If you’ve ever used Excel to manage data like customers, projects, or inventory, you’ll know it works… up to a point. Then the file starts getting bigger and slower. More rows. More users. More moving parts. And things start to break. People overwrite data. There’s no control over who can change what. And sharing it with others who don’t use Excel becomes a problem. That’s usually when you realize the file isn’t the issue anymore. It’s the way it’s being used. You need something that can handle multiple users, control data entry, and give people a proper interface. But most tools that solve this feel like a big step up in complexity. So in this video, I’ve partnered with Zite to show you how to take an Excel file you already have, like this with data for customers, opportunities and interactions and turn it into something much more robust, with structured data, controlled access, and an app interface your team can actually use. 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 #Zite #ExcelTutorial

    Not rated yet
  • Compare Two Excel Sheets and Catch Every Single Difference

    · 10 min

    How to compare two Excel sheets and find differences between them, without missing anything. 👩‍🏫 Learn more about my Power Query course: https://bit.ly/compare26course ⬇️ Download the example file here and follow along: https://bit.ly/compare26file Your colleague sends you an updated version of a file you built last week. And when you open it, everything looks fine. But something feels off. Did they change the numbers? Move a row? Fix something, or break something? You start comparing. Eyes jumping back and forth. And five minutes later you're still not sure you've caught everything. Sound familiar? In this video, I'm going to show you three ways to compare two Excel sheets and find every single difference. And I'll show you something that most tutorials skip: which is how Excel can sometimes make two cells look identical when they're actually different. 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 Compare Excel sheets and find differences 0:41 How to view Excel sheets side by side 1:28 The first way to compare sheets and find differences 4:50 The second way to compare sheets and find differences 6:24 The third way to compare sheets and find differences #Excel #DataCleaning #ExcelTutorial

    Not rated yet
  • I Stopped Writing Process Docs After Finding This AI Tool (Scribe Demo)

    · 5 min

    Save hours creating how-to guides with this AI tool (step-by-step tutorial) Try Scribe for free: https://Scribe.how/MOTH Scribe’s Workflow AI platform instantly turns workflows into step-by-step guides, SOPs, training manuals, and how-to documentation to help teams get work done right and improve how work gets done. Automatically capture your clicks and keystrokes to generate visual process documentation in seconds - perfect for employee onboarding, standard operating procedures, workflow documentation, internal knowledge bases, and team knowledge sharing. 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 #Scribe #ScribeTutorial

    Not rated yet
  • Secret Excel Shortcuts That Aren't on Any Cheat Sheet (But Should Be)

    · 7 min

    11 secret Excel shortcuts that almost no one knows about, but that make a difference. 👩‍🏫 Learn more about my Excel Expert course: https://bit.ly/secretshortcuts26course ⬇️ Download the example file here and follow along: https://bit.ly/secretshortcuts26file Most Excel users know the obvious shortcuts. Ctrl+C, Ctrl+V, maybe even Ctrl+D. But there are a handful of shortcuts that are incredibly useful… and almost no one knows they exist. Some of these will save you time. Others will completely change how you work. Let’s get into them. 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 Almost no one knows these Excel shortcuts 0:22 Shortcut №1 0:52 Shortcut №2 1:46 Shortcut №3 2:40 The easiest way to become an Excel expert 2:58 Shortcut №4 3:35 Shortcut №5 3:54 Shortcut №6 4:12 Shortcut №7 4:28 Shortcut №8 5:00 Shortcut №9 6:00 Shortcut №10 6:44 Shortcut №11 7:11 Fix most common and annoying Excel problems #Excel #ExcelShortcuts #ExcelKeyboardshortcuts

    Not rated yet
  • The Excel Wildcard Tricks That Separate Beginners from Advanced Users

    · 12 min

    Use wildcards (*, ?, ~) in Excel formulas for beginners and advanced users. 👩‍🏫 Learn more about my Excel Expert course: https://bit.ly/wildcards26course ⬇️ Download the example file here and follow along: https://bit.ly/wildcards26file You might think you already know wildcards in Excel… Most people use them in COUNTIF or maybe XLOOKUP and stop there. But wildcards show up in more places than formulas, and when you start combining them with Excel’s other tools, you can solve problems much faster than most users realise. In this video, I’ll show you both the basics and some less obvious uses that can really level up your workflow. 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 Wildcards from the basics to advanced 0:24 XLOOKUP with wildcards 1:19 The solution to the previous setback 2:25 COUNTIF with wildcards 2:50 SUMIFS with wildcards 3:22 Data validation with wildcards 6:06 The easiest way to become an Excel expert 6:38 Advanced filter with wildcards 8:17 Find and Replace with wildcards 8:59 IF with wildcards 10:05 Escaping the wildcards 11:05 Conditional formatting with wildcards 12:17 The most important Excel functions everyone needs #Excel #ExcelWildcards #ExcelTutorial

    Not rated yet