@myonlinetraininghub MyOnlineTrainingHub
MyOnlineTrainingHub posts on YouTube about microsoft, how to, excel, what is the most. They currently have [-------] followers and [---] posts still getting attention that total [------] engagements in the last [--] hours.
Engagements: [------] #
- [--] Week [-------] +5.90%
- [--] Month [---------] +12%
- [--] Months [---------] +62%
- [--] Year [---------] +62%
Mentions: [--] #
- [--] Week [--] +6.30%
- [--] Month [--] +3.50%
- [--] Months [---] +54%
- [--] Year [---] +161%
Followers: [-------] #
- [--] Week [-------] +0.36%
- [--] Month [-------] +1.50%
- [--] Months [-------] +11%
- [--] Year [-------] +20%
CreatorRank: [-------] #
Social Influence
Social category influence technology brands 61.19% stocks #4409 social networks 11.94% finance 8.21%
Social topic influence microsoft #102, how to #5765, excel #39, what is 12.69%, linkedin #455, data #589, build 8.21%, how to create #83, finance #1566, save 3.73%
Top accounts mentioned or mentioned by @myndatreacylangen @excelambda
Top assets mentioned Microsoft Corp. (MSFT) Alphabet Inc Class A (GOOGL) FilesCoins Power Cu (FILECOIN)
Top Social Posts
Top posts by engagements in the last [--] hours
"IF IFS Nested IFs: Avoid the Mistakes Slowing You Down IF function tutorial in Excel: IF nested IFs IFS etc. Performance issues with solutions. 👩🏫 Master Excel with my courses: https://bit.ly/iffunction24courses ➡ Download the example file here: https://bit.ly/iffunction24file ➡ Use our IF Formula Builder: https://www.myonlinetraininghub.com/if-formula-builder IF Statements are essential for all Excel users to master. Unfortunately many get stuck with nesting and make mistakes that can cause performance issues which I address in this video. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join"
YouTube Link 2021-06-23T12:00Z 835K followers, 97.8K engagements
"You Don't Need VLOOKUP & XLOOKUP You Need This Excel Start using a better alternative to the XLOOKUP and VLOOKUP functions in Excel. 👩🏫 Learn more about the Power Pivot and DAX in my course: https://bit.ly/lookups25course Download the example file here and follow along: https://bit.ly/lookups25file VLOOKUP or XLOOKUP are probably the first formulas you reach for when you need to pull data from one sheet to another in Excel. They work great on small tables but the moment your file grows they can slow everything down because they duplicate data. I'm going to show you exactly why the pros have"
YouTube Link 2025-11-04T11:45Z 835K followers, 1.2M engagements
"10 Excel Formula Symbols You Wish You Knew Years Ago How to use symbols in Excel formulas (* @ # $ etc.) to avoid errors and get the results you need. 👩🏫 Learn more about my Excel Expert course: https://bit.ly/symbols25course Download the example file here and follow along: https://bit.ly/symbols25file Videos mentioned in the tutorial: [--]. Everyone's Talking About This NEW Excel Function (TRIMRANGE): https://youtu.be/mGOhfSHFlro [--]. Excel Hash Sign Operator - What is it + ADVANCED Tricks: https://youtu.be/1ios50O45-M Do you know what Excel symbols mean in formulas They show up in Excel all"
YouTube Link 2025-06-10T11:45Z 835K followers, 522.9K engagements
"Excel Tutorial for Beginners Made Easy Download the example file here and follow along: https://bit.ly/beginner24file 👩🏫 Advanced Excel Formulas course: https://bit.ly/formulas24course 👩🏫 Excel Tables course: https://bit.ly/tables24course Excel is the key to unlocking limitless opportunities. Its a skill that can elevate your career manage your finances like a pro and turn raw data into powerful insights. In this video well cover everything from the basics right through to tools most Excel users never learn which holds them back. Well start with navigating the interface entering data"
YouTube Link 2024-05-07T11:45Z 835K followers, 187K engagements
"Excel's Secret WhatsApp Integration That 99% of Users Don't Know About How to send bulk WhatsApp messages in second using Excel. 👩🏫 Join my Excel & Power BI courses: https://bit.ly/waexcel25courses Download the example file here and follow along: https://bit.ly/waexcel25file In-depth SWITCH Function tutorial: https://youtu.be/oJ-RwnZ_uE8 Imagine you need to send payment reminders to [--] clients or event updates to [---] conference participants. Doing that one-by-one in WhatsApp would take hours. But Excel can do it in seconds. Yes youve heard me right. Let me show you how to turn Excel into"
YouTube Link 2025-10-21T11:45Z 835K followers, 222.6K engagements
"Secrets to Building Excel Dashboards in Under [--] Minutes & UPDATES with [--] CLICK Learn the tricks that allow you to build an Excel Dashboard super fast and how to set it up so you can update it with one click. 🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/workbook-downloads 🎓 LEARN MORE in my comprehensive courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel"
YouTube Link 2020-08-19T23:00Z 835K followers, 1.9M engagements
"How to Create a QR Code in Excel for Every Need (FREE File) UPDATE: the Google API in the video no longer works. See the post linked to below for an alternate API: https://bit.ly/qrcodesfile How to make QR codes in bulk for a website PDF etc. in Excel using formulas. 👩🏫 Simplify your work in Excel with my Advanced Formulas: https://bit.ly/advformulas0130 ➡ DOWNLOAD the free example file here: https://bit.ly/qrcodesfile In Excel we can create QR codes in bulk for free for use in any application using a formula. Unlike Google Sheets you can simply copy the image and paste it where you need"
YouTube Link 2024-01-30T11:45Z 835K followers, 87.7K engagements
"The Excel Tool That Does What PivotTables Cant (File Included) Discover how Power Pivot outperforms PivotTables for advanced data analysis. 👩🏫 Learn more about the Power Pivot and DAX course: https://bit.ly/powerpivot24course Download the example file here and follow along: https://bit.ly/powerpivot24file Excel's regular PivotTables are great for the basics providing a straightforward and effective tool for simple tasks. However they have limited calculation abilities and can only work with a single source of data. In today's world we need a more modern tool that can handle advanced"
YouTube Link 2024-11-19T11:45Z 835K followers, 801.9K engagements
"Excel Just Made File Imports Ridiculously Simple (New Functions) 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 [---] 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"
YouTube Link 2026-02-03T11:58Z 835K followers, 55.7K engagements
"How to Get Microsoft Excel for Free (Legally) in [----] Find out how you can get Excel for free legally and directly from Microsoft. 👩🏫 Learn more with my Excel courses: https://bit.ly/freeexcel25courses No cracked copies that could be full of malware. Well look at both the web version which has some great features including some we dont have in the desktop app. And options that might be available to you to get the desktop app for free. By the end of this video youll be set to start using Excel without spending a penny. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2025-01-21T11:45Z 835K followers, 267.8K engagements
"EASIEST Excel Data Entry Form in [----] No VBA Required Create a simple automated data entry form in Excel with Microsoft Forms. 👩🏫 Learn Excel with my courses: https://bit.ly/mforms24courses 🔗 Migrate Your Google Forms to Microsoft Forms: https://techcommunity.microsoft.com/t5/microsoft-forms-blog/migrate-your-google-forms-to-microsoft-forms-in-microsoft-365/ba-p/4033163 Picture this you need to gather data from many users but you dont want them to see each others entries or you just dont want loads of people having access to your file because they might break it. The old-style Excel User"
YouTube Link 2024-07-02T11:45Z 835K followers, 148.8K engagements
"15 Excel Functions Every Professional Should Know in [----] Download the example file here and follow along: https://bit.ly/functions26file 👩🏫 Learn more Excel functions and formulas with my course: https://bit.ly/functions26course Excel has released a ton of new functions in the past couple of years and if you haven't kept up you're probably working a lot harder than you need to. In this video I'll walk you through the best modern Excel functions with practical examples that will transform the way you work in [----]. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2026-01-27T11:45Z 835K followers, 60.3K engagements
"The Automated Database in Excel Youll Actually Use (Free Template) Turn simple data entry into an automated Excel system that builds a structured database for you. 👩🏫 Join my Excel Expert course: https://bit.ly/database25course Download the template here and follow along: https://bit.ly/database25file You fill out a simple form: name email service theyre interested in industry date and some notes. Click one button and your client is automatically added to a structured searchable database. From here you can sort and filter entries by date industry or service etc. and connect the data to"
YouTube Link 2025-09-23T11:45Z 835K followers, 300.7K engagements
"Build a Self-Updating Checklist & Progress Bar (No VBA) 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. Download the example file here and follow along:"
YouTube Link 2026-02-10T11:45Z 835K followers, 18.4K engagements
"Excel Group & Outline Buttons Easiest way to Hide & Unhide Rows & Columns Quickly hide and unhide rows and columns with group and outline toggle buttons. Donwload the Excel example file here: https://www.myonlinetraininghub.com/excel-group-and-outline-data View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:23 Manually Group Rows and Columns 2:34 Automatically Group Rows 3:18 Automatic Subtotals 5:00 Tips for working with Grouped Data 5:38 Hiding Group and Outline buttons excel group rows"
YouTube Link 2022-04-14T12:00Z 835K followers, 140.5K engagements
"How Excel PROs Filter Data (FILTER Function) The FILTER function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/profilter25yt 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel functions excel"
YouTube Link 2025-11-07T11:45Z 835K followers, 67.1K engagements
"How to easily automate boring Excel tasks with Power Query Learn how Power Query can automate the boring and laborious tasks of getting and cleaning data reducing time spent on these tasks down to the click of a button 🔻 DOWNLOAD files for this lesson here: https://www.myonlinetraininghub.com/introduction-to-power-query 🎓 LEARN MORE Power Query here: https://www.myonlinetraininghub.com/excel-power-query-course Or view my comprehensive courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀"
YouTube Link 2020-10-14T23:00Z 835K followers, 1.8M engagements
"Excel for Beginners - Save Save As & Saving Different File Types Lesson [--] of [--] - Get started with Excel and learn how to save your work including different file types. Download the Excel file for all [--] lessons here: https://www.myonlinetraininghub.com/workbook-downloads Get the full course here: https://www.myonlinetraininghub.com/microsoft-office-online-training-courses View all my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ excel microsoft excel excel for beginners excel microsoft excel excel for"
YouTube Link 2020-08-08T23:00Z 835K followers, 133.2K engagements
"Master Data Cleaning with Power Query in Excel in [--] Minutes Change your life with this data cleaning tool built into Excel that most users don't know. It's easy to use and fast to learn. No programming required. DOWNLOAD the example file & practice data here: https://www.myonlinetraininghub.com/get-started-with-power-query 🎓 LEARN MORE in my Excel course: https://www.myonlinetraininghub.com/excel-power-query-course 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all 🎯 CONNECT with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2023-07-18T11:45Z 835K followers, 184.4K engagements
"Build a Self-Updating Excel Invoice & Tracker (Free Template) No Add-Ins Create an automated invoice template in Excel with a tracker auto-invoice numbering and self-clearing features (no coding experience needed). 👩🏫 Master Excel & Power BI with 20% off all my courses until May [--] 2025: https://bit.ly/invoice25courses Download the invoice template here and follow along: https://bit.ly/invoice25file Click a button. Invoice clears and a new number appears. Enter your items. Tab for a new row. Click a button and the invoice tracker updates itself. It looks easy because it is. In this video I"
YouTube Link 2025-05-06T11:45Z 835K followers, 105.4K engagements
"3 Ways to Sum Data in Excel Beginner to Advanced How to sum data in Excel: beginner intermediate and advanced levels. 👩🏫 Join my Excel courses: https://bit.ly/sumdata25coms 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 #ExcelTips #ExcelTutorial Mynda Treacy My Online Training Hub Microsoft Excel Excel sum in excel how to sum in excel"
YouTube Link 2025-09-17T11:45Z 835K followers, 584K engagements
"Get Multiple Files Containing Multiple Sheets with Power Query How to import multiple files containing multiple sheets with Power Query even if the data isnt formatted in an Excel Table. 🔻 DOWNLOAD the Excel file & see step by step written instructions here: https://www.myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-query 🎓 LEARN MORE: view my comprehensive courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn:"
YouTube Link 2020-04-01T23:00Z 835K followers, 494.9K engagements
"Have You Used This Excel Trick Before How to hide and unhide columns and rows with the grouping/ungrouping feature in Excel. Download the example file here and follow along: https://bit.ly/hide26yt 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 #ExcelTips #ExcelTutorial Mynda Treacy My Online Training Hub Microsoft Excel Excel excel short"
YouTube Link 2026-01-23T11:45Z 835K followers, 38.5K engagements
"4 Mins. to MASTER Excel INDEX & MATCH formulas Overcome the limitations of VLOOKUP. Get up to speed with Excel INDEX & MATCH formulas fast. We'll look at the functions individually and then bring them together to perform powerful lookups using real world examples. 🔻 DOWNLOAD EXCEL EXAMPLE FILE HERE: https://www.myonlinetraininghub.com/excel-index-and-match-functions [--] SECRET INDEX Function Features: https://www.youtube.com/watchv=pP7AMLJa0Vc 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 🎁 SHARE this video"
YouTube Link 2023-04-13T11:45Z 835K followers, 513.3K engagements
"Excel Hash Sign Operator - What is it + ADVANCED Tricks The hash sign spill operator enables you to reference spilled arrays returned by dynamic array formulas. In this video I share some little known tricks for using it in data validation and defined names. Download the file here: https://www.myonlinetraininghub.com/hash-sign-in-excel-formulas 0:00 Introduction 0:29 What is a spilled array 0:58 Referencing spilled arrays with # 2:21 Referencing spilled arrays in Data Validation 7:03 # sign in Defined Names View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on"
YouTube Link 2021-10-21T12:00Z 834K followers, 80.8K engagements
"Excel Skills to Add to Your Resume in [----] (Worth $15K-30K More) Find out what the five Excel and Power BI skills are that drive salary differences and how to list them on your resume so companies notice. 👩🏫 Increase your salary [----] Join my Excel Data Analyst course: https://bit.ly/skills26course Watch the Power Query tutorial: https://youtu.be/L4BuUzccLpo Watch the Power Pivot & DAX tutorial: https://youtu.be/JvnezVM2uP4 Watch the Interactive Dashboard tutorial: https://youtu.be/K74_FNnlIF8 Watch the Power BI tutorial: https://youtu.be/gOs7EC-FebE LEARN MORE =========== 📰 EXCEL"
YouTube Link 2026-01-20T11:45Z 835K followers, 22.2K engagements
"Why EVERY Excel User Needs Power Query & Power Pivot Differences between Power Query and Power Pivot Excel users need to know. Versions of Excel supporting Power Query: https://bit.ly/3daTuU0 Versions of Excel supporting Power Pivot: https://bit.ly/3s7RcJu 🎓 LEARN MORE in my courses: Power Query Course: https://www.myonlinetraininghub.com/excel-power-query-course Power Pivot Course: https://www.myonlinetraininghub.com/power-pivot-course Power BI Course: https://www.myonlinetraininghub.com/power-bi-course 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a"
YouTube Link 2021-04-13T12:00Z 835K followers, 267.1K engagements
"NEW Excel COPILOT Function Will Replace Half of What You Do Excel's New COPILOT function changes everything 👩🏫 Join Advanced Excel Formulas course: https://bit.ly/copilot25course Download the example file here and follow along: https://bit.ly/copilotfile With the COPILOT function you can type plain English into a cell and Excel does the work. Categorize hundreds of transactions clean messy addresses explain scary formulas even analyze financial statements without you lifting a finger. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2025-08-19T11:00Z 835K followers, 341.4K engagements
"These SUM Tricks Will Blow Your Mind (No Seriously) SUM isn't only for totals it can also handle COUNTIFS SUMIFS OR logic and conditional averages. 👩🏫 Go deeper with the Advanced Excel Formulas course: https://bit.ly/sum25course Download the example file here and follow along: https://bit.ly/sum25file Ah SUM. The first formula we all learned. Its great for adding up columns and rows but what if I told you SUM can actually do the job of COUNTIFS SUMIFS even AVERAGEIFS without switching functions In fact it can also overcome the limitations of those functions. Surprised Theres more so lets"
YouTube Link 2025-05-27T11:45Z 835K followers, 73K engagements
"Interactive Excel Dashboards & ONE CLICK Update 🔻 DOWNLOAD EXCEL FILE used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive Excel dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel [----] onward for Windows & Excel [----] onward for Mac. 🎓 LEARN MORE in my Excel Dashboard course: https://www.myonlinetraininghub.com/excel-dashboard-course 🔔 SUBSCRIBE if youd like more tips and tutorials like"
YouTube Link 2017-12-19T04:35Z 835K followers, 10.6M engagements
"Excel Techniques for 80/20 Data Analysis (Pareto Principle) Ways to apply the 80/20 rule (also known as the Pareto Principle) in Excel and save hours. 👩🏫 Learn more about my PivotTables course: https://bit.ly/paretoprinciple24course 👩🏫 Learn Excel with my courses: https://bit.ly/paretoprinciple24allcourses Download the example file here and follow along: https://bit.ly/paretoprinciple24file Imagine you're working on a sales report trying to identify the key factors driving your revenue. But with so much data to sift through it feels overwhelming. That's where the Pareto Principle or the"
YouTube Link 2024-09-10T11:45Z 835K followers, 55K engagements
"Combine Files from a Folder with Power Query the RIGHT WAY Most people combine files from a folder with Power Query all wrong. In this video I show you why its wrong and the way you should be doing it. When Power Query combines files in a folder it automatically creates a bunch of queries for you. There are two queries that are important the sample file query and the final query. Most people use the wrong query to make their transformations and wonder why theyre struggling. Check out the video to see examples of when and why you should use the sample file query vs the final query. 📑FILE"
YouTube Link 2023-05-23T11:45Z 835K followers, 354.3K engagements
"Excel Shortcuts that Will Save You Hours of Work (Windows & Mac) Most common Excel shorcut keys you should know to work faster. ➡ FREE [---] Excel Shortcuts for Windows & Mac: https://bit.ly/shortcuts240225 👩🏫 Improve your productivity in Excel with my courses: https://bit.ly/courses240225 Do you know there are over [---] Excel keyboard shortcuts It's a lot and I'm not going to cover all of them in this video. Instead I'm going to focus on sharing the most useful ones to both Windows and Mac users to supercharge Excel skills. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers"
YouTube Link 2024-02-27T11:45Z 835K followers, 60.9K engagements
"VLOOKUP in Power Query Using List Functions Using List functions in Power Query to do Exact Lookup and Approximate Match Lookup is faster and easier to create than using table merges. Download the Excel file that includes the data and queries in this video: https://www.myonlinetraininghub.com/vlookup-in-power-query-using-list-functions 0:15 Exact Match VLOOKUP 1:21 Using List.PositionOf to lookup value 2:32 Looking up the category for the corresponding value 3:15 Combining M code to reduce query steps 4:33 Approximate Match VLOOKUP 5:34 Using List.Select to lookup all matching values 7:55"
YouTube Link 2021-07-29T12:30Z 835K followers, 229.7K engagements
"STOP Using Excel Formulas Use Ctrl + E Instead (Examples) The Ctrl + E shortcut (Flash Fill) can save you hours of work in Excel (examples included). 👩🏫 Learn more in my Excel courses: https://bit.ly/4abYMJW ➡ Download the example file here: https://bit.ly/4awkFTU How Flash Fill was developed: https://research.microsoft.com/en-us/news/features/flashfill-020613.aspx If you waste time reformatting text and haven't had time to learn Power Query yet then you're going to love Excel's Flash Fill tool. It enables you to split reformat and combine columns of text with an easy keyboard shortcut."
YouTube Link 2022-06-22T23:45Z 834K followers, 29.5K engagements
"Excel Charts 101: Simplify Your Data with These [--] Winners Four most popular Excel graph types: when & how they should be used. 👩🏫 Learn more about the Excel Dashboard course: https://bit.ly/rightchart24course Download a free eBook/PDF with [--] tips for better charts: https://bit.ly/rightchart24file Lets be honest choosing the wrong Excel chart for your data can be embarrassing. But Im here to tell you that it doesnt have to be. In this video Im going to show you the only [--] charts you actually need and why its easier than you think to get it right. LEARN MORE =========== 📰 EXCEL NEWSLETTER -"
YouTube Link 2024-10-01T11:45Z 832K followers, 26.2K engagements
"Excel Personal Finance Tracker [---] Build & Automate Yours in Minutes Track your income and expenses in Excel (step-by-step guide & free template) 👩🏫 Master Excel with my courses: https://bit.ly/pftracker25courses Download the example file here and follow along: https://bit.ly/personalfinance25file Being in control of your money is one of the most important life skills we can learn today. In this video Im going to show you how to build a simple effective finance tracker in Excel or Google Sheets that lets you monitor every dollar. You can analyze your spending by category month and even year"
YouTube Link 2025-01-14T11:45Z 835K followers, 788.9K engagements
"Easy Build Budget vs Actual Dashboard + FREE File Download 🔻 DOWNLOAD the Excel file for this video here: https://www.myonlinetraininghub.com/plan-v-actual-excel-dashboard In this video you will learn how to create an interactive Excel budget vs actuals dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel [----] onward for Windows & Excel [----] onward for Mac. 🎓 LEARN MORE: view my comprehensive courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I"
YouTube Link 2020-08-10T23:00Z 835K followers, 1M engagements
"Cool Tricks with Excel Hyperlink Buttons Excel hyperlink buttons make your reports look slick and allow users to navigate workbooks in an intuitive way. Download the example file here: https://www.myonlinetraininghub.com/excel-hyperlink-buttons 0:23 Creating Buttons 1:20 Inserting Hyperlinks 2:00 Preventing Hyperlinks Breaking 4:35 Tabbed Hyperlinks View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ excel hyperlinks excel hyperlink buttons excel hyperlinks excel hyperlink buttons"
YouTube Link 2021-08-12T12:00Z 834K followers, 118.6K engagements
"Excel Features That Will Set You Apart in [----] New Excel features that are essential for [----]. 👩🏫 Learn more about the Excel Expert course: https://bit.ly/newexcel25course Download the example file here and follow along: https://bit.ly/newexcel25file Videos mentioned in the tutorial: How to Insert a Checkbox in Excel Interactive Checklists: https://youtu.be/MB9DWvHXQLk Everyone's Talking About This NEW Excel Function (TRIMRANGE): https://youtu.be/mGOhfSHFlro NEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy: https://youtu.be/-_1IaUjO-hk Excel Just Got NEW REGEX Functions You Need to"
YouTube Link 2025-01-07T11:45Z 834K followers, 110.1K engagements
"Excel Just Got NEW REGEX Functions You Need to Try REGEXTEST REGEXEXTRACT & REGEXREPLACE finally bring RegEx to Excel 👩🏫 Learn more with my Excel courses: https://bit.ly/regex24courses Step-by-step guide on how to use REGEX and a downloadable file: https://bit.ly/regex24file Excel has [--] new functions that revolutionize text manipulation. And its about time because parsing text in Excel with functions like SEARCH MID and LEFT etc. can be cumbersome and frustrating. These new functions allow you to work with regular expressions commonly known as Regex. ❗NOTE❗These functions are currently"
YouTube Link 2024-05-22T11:30Z 835K followers, 58.4K engagements
"UPDATED Trick to show items with no data in PivotTables - including Power Pivot Show Items with no Data in PivotTables is a handy setting that allows you to show items in the PivotTable even if there isnt any data for them. Download the Excel file here: https://www.myonlinetraininghub.com/show-items-with-no-data-in-pivottables 0:14 Example Data 0:30 Regular PivotTable 1:33 Show Items with No Data setting for regular PivotTables 1:59 Power Pivot PivotTables 2:48 Item Dimension Table 3:04 Create Relationship 3:33 Select Fields 4:40 Example 2: dates View my comprehensive courses:"
YouTube Link 2021-06-18T10:15Z 834K followers, 53.6K engagements
"10 Excel Formulas That Will Set You Apart (+Cheat Sheet) Top [--] new essential Excel formulas & functions in [----]. 👩🏫 Learn more Excel functions with my course: https://bit.ly/functions24course Download the example file here and follow along: https://bit.ly/functions24file These days knowing basic Excel won't set you apart. You have to keep up with the new features that enable you to improve productivity or youll be left behind. In this video Im going to share [--] must know modern Excel functions that simplify common tasks. These functions will not only make your life easier theyll also make"
YouTube Link 2024-04-09T11:45Z 835K followers, 572.7K engagements
"Automate Excel Without Becoming a Programmer Macros & VBA [---] Excel Macros & VBA for beginners to automate Excel tasks. 👩🏫 Master Excel & Power BI with my courses: https://bit.ly/macrosvba25courses Download the example file here and follow along: https://bit.ly/macrosvba25file If youve ever caught yourself repeating the same clicks in Excel day after day: formatting data sorting columns moving things around.stop Theres a faster way. With just one click a macro can do the job for you. And with a little VBA you can take it even further building your own smart automations that adapt to your"
YouTube Link 2025-06-24T11:45Z 835K followers, 95.3K engagements
"STOP Emailing Excel Files - Securely Embed them in Web Pages Instead Embedding dashboards and reports in web pages is super easy when your files are saved on OneDrive or SharePoint. Get the step by step written instructions here: https://www.myonlinetraininghub.com/embedding-excel-dashboards-in-a-web-page View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:41 Defining a Named Range 1:09 Getting embed code from OneDrive/SharePoint 4:43 Web Page demo 5:44 Things to avoid 6:25 Getting iframe"
YouTube Link 2022-05-26T11:40Z 835K followers, 91.6K engagements
"Interactive Excel Dashboard for BETTER Data Visualization (Free Download) Build an interactive Excel dashboard for better data visualization in less than [--] minutes. ❗Master Excel with my courses: https://bit.ly/visualization24courses Download the example file here and follow along: https://bit.ly/visualization24file 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:"
YouTube Link 2024-05-14T11:45Z 832K followers, 77.4K engagements
"Interactive Excel Dashboard Tutorial in [--] Steps (+ FREE Template) How to Make Interactive Excel Dashboards & ONE CLICK Update. 👩🏫 Master Excel now with 20% off all courses until Feb [--] 2024: https://bit.ly/excelcourses130224 ➡ DOWNLOAD the free example file here: https://bit.ly/3-step-dashboards In this video we're going to transform the sea of data into a sleek interactive dashboard. We'll craft this dashboard in [--] steps starting with cohesive design elements. Then we will analyze and visualize key metrics; and lastly add interactive elements for data exploration. All in under [--] minutes."
YouTube Link 2024-02-13T11:45Z 835K followers, 316.1K engagements
"STOP Making Basic Drop-Downs Try These [--] Advanced Methods Instead [--] ways to build drop-downs in Excel that update themselves pull data from anywhere and change depending on what you select. Download the example file here and follow along: https://bit.ly/dropdowns25file 👩🏫 Join my Excel Expert course: https://bit.ly/dropdowns25course 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:"
YouTube Link 2025-10-28T11:56Z 835K followers, 157.8K engagements
"Easy Excel PivotTable Profit & Loss Statements Automate creating Profit and Loss statements with PivotTables which can be linked to Slicers and formatted with Conditional Formatting. Download the Excel file here: https://www.myonlinetraininghub.com/excel-pivottable-profit-and-loss View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-07-29T23:00Z 835K followers, 219.7K engagements
"Interactive Excel Project Management Dashboard - FREE Download Step by step tutorial on how to build an interactive Excel project management dashboard. 🔻 DOWNLOAD the Excel file containing the completed dashboard and steps for building it yourself: https://www.myonlinetraininghub.com/excel-project-management-dashboard 🎓 LEARN MORE Join my Excel Dashboard course here: https://www.myonlinetraininghub.com/excel-dashboard-course ALTERNATIVE TO SEQUENCE FUNCTION For those who don't have the SEQUENCE function you can use two formulas instead: Cell K5: =MIN( start date column ) + output of form"
YouTube Link 2020-03-24T23:00Z 835K followers, 2.4M engagements
"This Excel Template Will Save Your Small Business (Free Download) Track your small business finances with this fully automated Excel profit & loss dashboard. Download the free template and follow along: https://bit.ly/smtemplate25file 👩🏫 Take the Power Query course with 20% off until December [--] 2025: https://bit.ly/smtemplate25pq 👩🏫 Master Excel & Power BI with 20% off all my courses until December [--] 2025: https://bit.ly/smtemplate25courses Running a small business or side hustle means keeping track of every dollar that comes in and out. But if youre still spending hours figuring out your"
YouTube Link 2025-11-25T11:45Z 835K followers, 42.7K engagements
"5 Ways to Keep Excel Sheets & Workbooks Linked Automatically [--] ways to sync your data across sheets and workbooks automatically. 👩🏫 Join Advanced Excel Formulas course: https://bit.ly/linkdata25course Download the example file here and follow along: https://bit.ly/linkdata25file Its common to need the same data in different places: one file for raw inputs another for reports dashboards or even subsets of the data in the same file filtered for specific criteria. But updating everything manually is slow risky and completely avoidable. In this video Ill show you [--] ways to sync your data across"
YouTube Link 2025-08-26T11:45Z 835K followers, 195.5K engagements
"Create an Automated Inventory Management System in Excel (FREE Template) Build an inventory management system that tracks your stock records transactions generates automatic reorder lists and gives you instant reports - all in one simple workbook. Download the free template here and follow along: https://bit.ly/invmngt25file 👩🏫 Join my Excel Expert course: https://bit.ly/invmngt25course 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/ 💬"
YouTube Link 2025-10-14T11:45Z 835K followers, 105.6K engagements
"UNIQUE Function Explained in [--] Seconds Excel Tutorial The UNIQUE function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/unique25short 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel"
YouTube Link 2025-10-10T11:45Z 835K followers, 34.5K engagements
"NEW Copilot Agents Build What Used to Take Hours (Automatically) How to install and use Excel's AI Agent Mode (example included). 👩🏫 Learn Excel and Power BI with my courses: https://bit.ly/agents25courses Download the example file here and follow along: https://bit.ly/agents25file Microsoft just released Copilot Agent Mode in Excel and it can now build entire spreadsheets for you. Im talking full models linked sheets calculations charts dashboards the whole workflow. It works more like a digital analyst than a standard AI assistant. In this video Im going to show you how I used it to build"
YouTube Link 2025-12-09T11:45Z 835K followers, 124.6K engagements
"Interactive Personal Finance Dashboard with FREE EXCEL TEMPLATE 🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/interactive-personal-finance-dashboard Visualise keep track of and manage where youre spending your money with this interactive Excel personal finance dashboard. 🎓 LEARN MORE: Take my Dashboard course: https://www.myonlinetraininghub.com/excel-dashboard-course 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🎁 SHARE this video and spread the Excel love. Or if youre short of time please click the 👍 🧟♀"
YouTube Link 2021-11-18T12:00Z 835K followers, 1.2M engagements
"Say GOODBYE to These [--] Excel Functions The TEXTJOIN function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/textjoin25shorts 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 #ExcelFormulas Mynda Treacy My Online Training Hub Microsoft Excel Excel excel functions excel"
YouTube Link 2025-12-12T11:45Z 835K followers, 67.5K engagements
"How to Get Excel for Free (Legally) Find out how you can get Excel for free legally and directly from Microsoft. 👩🏫 My Black Friday sale is live 20% off all Excel courses until December [--] 2025: https://bit.ly/freeexcel25yt 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 #FreeExcel #ExcelForFree Mynda Treacy My Online Training Hub"
YouTube Link 2025-11-21T11:45Z 835K followers, 36.1K engagements
"How to Split Text in Excel in Seconds (Flash Fill) Learn to split Excel data automatically using Ctrl + E (Flash Fill). 👩🏫 Join my Excel courses: https://bit.ly/flashfill25shorts 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 #ExcelTips Mynda Treacy My Online Training Hub Microsoft Excel Excel flash fill flash fill in"
YouTube Link 2025-09-10T11:45Z 835K followers, 148K engagements
"The MUST Know Symbol in Excel The dollar symbol in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/dollar25shorts 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 #ExcelSymbol #ExcelOperator Mynda Treacy My Online Training Hub Microsoft Excel Excel excel symbols excel wildcard characters"
YouTube Link 2026-01-09T11:45Z 835K followers, 34.8K engagements
"How to Start Making Money with Excel (Beginner Level) 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 Mynda Treacy My Online Training"
YouTube Link 2026-02-06T11:45Z 835K followers, 12.9K engagements
"Excel LAMBDA Function: How & When to Use It (Beginner-Friendly) How to create custom functions in Excel with no programming languages. 👩🏫 Save hours of work by mastering Excel with my courses: https://bit.ly/excelcourses0221 ➡ DOWNLOAD the free example file here: https://bit.ly/lambdafile The new Excel LAMBDA function allows you to define your own custom functions using Excel's familiar formula language and that means we no longer need JavaScript or VBA programming knowledge to create our own functions. This is a huge step forward For those familiar with the concept of LAMBDAs it is worth"
YouTube Link 2021-02-24T23:00Z 835K followers, 75.5K engagements
"The QUICKEST Way to Convert Values to Percentages in Excel How to turn values to percentages in Excel. Download the example file here and follow along: https://bit.ly/percentages26yt 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 #ExcelTips #ExcelTutorial Mynda Treacy My Online Training Hub Microsoft Excel Excel paste special in excel"
YouTube Link 2026-01-30T11:45Z 835K followers, 28.4K engagements
"ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template) ➡ Download and customize a FREE automated personal budget template here: https://bit.ly/pbtemplate2024 With the cost of living crisis affecting everyone it is essential to get control of your finances so you don't leave yourself short. I've put together this interactive personal budget tracking spreadsheet designed for use in future years. It's super quick and easy to use for multiple bank accounts all in one place and it gives you a handle on your financial position at a glance. It highlights problem areas and you can"
YouTube Link 2024-01-02T11:45Z 835K followers, 389.2K engagements
"The Most Underrated Excel Function Youre Not Using (But Should) Start using this one function that will help you navigate Excel like a pro. 👩🏫 Learn more Advanced Excel Functions in my course: https://bit.ly/hyperlink25course Download the example file here and follow along: https://bit.ly/hyperlink25file If your Excel files feel like a maze Ill show you how to build shortcuts that get you where you need with one click. Working in Excel often means juggling large workbooks or jumping between related files. But navigating through sheets scrolling to the right section or keeping track of"
YouTube Link 2025-11-11T11:45Z 835K followers, 50.6K engagements
"This FREE Excel Template Replaces Expensive Task-Management Apps Build a clean assignment or task tracker in Excel with automatic schedule view (no macros needed) Download the free template and follow along: https://bit.ly/tracker25file 👩🏫 Join my Excel Expert course: https://bit.ly/tracker25course In this video well build a clean Assignment or Task Tracker in Excel with drop-downs for Subject and Type automatic Days Available colour-coded Status and highlighted overdue tasks. Youll be able to filter by subject to see whats due next focus on specific work types and status. Plus theres an"
YouTube Link 2025-11-18T11:45Z 835K followers, 70.5K engagements
"The Only Finance Tracker You Need for [----] (FREE Template) Build a personal finance tracker in Excel that imports bank transactions automatically categorizes spending updates savings goals and refreshes a dashboard. 👩🏫 Join my Excel Expert course: https://bit.ly/finance26course Download the example file here and follow along: https://bit.ly/finance26file 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"
YouTube Link 2026-01-13T11:45Z 835K followers, 62.8K engagements
"Still Guessing Between Power Query Power Pivot and VBA (Watch This) Power Query vs Power Pivot vs VBA which one to use in Excel and when. Learn how to clean data build dashboards and automate tasks. Download the cheat sheet here: https://bit.ly/exceltools25file 👩🏫 Master Power Query with my course: https://bit.ly/exceltools25pq 👩🏫 Master Power Pivot with my course: https://bit.ly/exceltools25pp Power Query Power Pivot VBA or Office Scripts - youve heard of them all. But when should you use each one And more importantly when shouldnt you In this video Ill walk you through what each tool is"
YouTube Link 2025-07-22T11:45Z 835K followers, 38K engagements
"5 Hidden Excel Formula Rules That Make Everything Easier Start writing better Excel formulas using the hidden rules advanced users follow. 👩🏫 Take the Advanced Excel Formulas course with 20% off until December [--] 2025: https://bit.ly/hfr25course Download the example file here and follow along: https://bit.ly/hfr25file 👩🏫 Master Excel & Power BI with 20% off all my courses until December [--] 2025: https://bit.ly/hfr25courses Excel has rules invisible ones that control how every formula works. Once you know them youll see patterns everywhere and your formulas just work. In this video Ill share"
YouTube Link 2025-12-02T11:45Z 835K followers, 61.6K engagements
"Freeze Panes to Lock Rows and Columns in Excel How to freeze panes to lock rows and columns in Excel. 👩🏫 Join my Excel courses: https://bit.ly/freeze25short 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 #ExcelTips #ExcelTutorial Mynda Treacy My Online Training Hub Microsoft Excel Excel freeze panes excel freeze panes in excel freeze"
YouTube Link 2025-09-26T11:45Z 835K followers, 55.4K engagements
"Turn Excel Into Your Own CRM System (No Coding Needed) Build your own CRM system in Excel with Power Query custom data types. 👩🏫 Take the Power Query course: https://bit.ly/crm25course Download the example file here and follow along: https://bit.ly/crm25file In this video Im going to show you how to convert [--] separate customer datasets containing customer information interactions and opportunities into a clean searchable customer relationship management system in Excel enabling you to extract customer details and get a list of your active leads and opportunities that automatically updates."
YouTube Link 2025-12-16T11:45Z 835K followers, 38.5K engagements
"Power Query Fuzzy Matching Makes Lookups EASY Fuzzy Matching in Power Query now means we can match text with typos upper and lower case and much more. Download the example file here: https://www.myonlinetraininghub.com/fuzzy-matching-in-power-query 0:26 Example Data 1:28 Merge Tables 2:04 Similarity Threshold 3:29 Transformation Table View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2021-06-10T12:00Z 828K followers, 89.9K engagements
"Captivating Excel Charts: Use Stylish Picture Fills to Enhance Data Visualization Using a stylish picture fill in your Excel Charts is a simple way to make your data visualizations more captivating and memorable. I'll walk you through the tricks from selecting the right images adjusting picture format and the trick to get the picture to span the chart width (it's not as obvious as you might think). 🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/picture-fill-excel-charts 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more"
YouTube Link 2023-03-02T11:45Z 770K followers, 18.1K engagements
"Avoid Calc. ERRORS - Scale Numbers in Excel the RIGHT WAY - $K $M $B #shorts Scaling numbers to thousands millions billions etc. in Excel is often done the wrong way which can lead to spreadsheet errors with massive ramifications. In this video I show you the right way to scale numbers so you won't get caught out. 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and"
YouTube Link 2023-02-14T11:45Z 826K followers, 18.6K engagements
"Writing Formulas in Excel Will Never Be the Same (Free File) If you struggle with writing Excel functions this tool might be the solution. 👩🏫 Advanced Excel Formulas course: https://bit.ly/labs24formula Download the example file here and follow along: https://bit.ly/labs24file Excels formula bar is difficult to work in with its limited space lack of formatting debugging and real time error detection it makes writing anything more than basic formulas tedious. In this video I'll introduce you to a free tool built by Microsoft and available for Excel [----] onward that will transform how you"
YouTube Link 2024-07-09T11:45Z 768K followers, 59.8K engagements
"Excel Stock Portfolio Dashboard - FREE File Download Build your own personal stock portfolio dashboard using the built in tools available in Excel for Microsoft [---]. 🔻 DOWNLOAD the Excel Stock Portfolio Dashboard here: https://www.myonlinetraininghub.com/personal-stock-portfolio-dashboard 🎓 LEARN MORE: Join my Excel Dashboard course here: https://www.myonlinetraininghub.com/excel-dashboard-course 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this"
YouTube Link 2021-02-03T21:00Z 826K followers, 597.9K engagements
"Only 1% of Excel Users Know Excel Tables STAND OUT from the Crowd Excel Tables can provide huge efficiency gains but few Excel users know about them. This video will get you started with Excel Tables and showcase some of their cool features. 🎓 LEARN MORE If you'd like to learn more including how to reference Excel Tables in formulas please take a moment to check out my course: https://www.myonlinetraininghub.com/excel-tables-course 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn:"
YouTube Link 2018-10-19T00:52Z 819K followers, 271.7K engagements
"Visio for Excel - Create Flowcharts Linked to Cells Get the free Visio Data Visualizer add-in for Excel and create cell linked flowcharts and organization charts Download the Excel file containing the [--] types of flowcharts here: https://www.myonlinetraininghub.com/visio-for-excel-free-add-in Reach out to the Visio team and tell them what you think directly via email: tellvisio @ Microsoft.com (spaces added to avoid spam) View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-04-29T23:00Z 828K followers, 140.2K engagements
"These Excel Functions Make Data Analysis Easy How to use Boolean logic IF statements AND OR XOR and to automate decisions and analyze data. 👩🏫 Learn more about Excel Expert course: https://bit.ly/boolean25course Download the example file here and follow along: https://bit.ly/boolean25file 99% of Excel users dont fully understand how logical tests work and it shows. This knowledge can be the difference between writing monstrous nested IF formulas or writing a simple formula that achieves the same result without using IF at all. Logic is at the core of Excel powering advanced filters formulas"
YouTube Link 2025-02-18T11:45Z 769K followers, 84.8K engagements
"Excel Lookup formulas are REDUNDANT Use the intersect operator instead. The intersect operator is a little known way you can lookup a cell or range of cells. Tip: create named ranges with a couple of clicks: https://www.youtube.com/shorts/Ygr3hzqHi_E 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if youre short of time please click the 👍"
YouTube Link 2023-04-04T11:45Z 816K followers, 84.4K engagements
"5 Dashboard Design Tips - COMMON MISTAKES to avoid A poorly designed dashboard not only makes it difficult for your audience but also reflects poorly on you. These [--] Dashboard Design Tips will make your readers love your work. Get the Dashboard shown in this video: https://www.youtube.com/watchv=TK0CJBaqvnY Color Tools ========== Color Brewer: For choosing sequential diverging and qualitative colors that are colour blind safe print friendly or photocopy safe. http://www.colorbrewer.org/ Coblis Color Blindness Simulator: A helpful simulator to see how readers who have colour vision"
YouTube Link 2022-02-10T12:00Z 784K followers, 74.7K engagements
"Excel for Beginners - Interface Ribbon & Contextual Tabs Lesson [--] of [--] - Get started with Excel beginning with the interface and some terminology. Download the Excel file for all [--] lessons here: https://www.myonlinetraininghub.com/workbook-downloads Get the full course here: https://www.myonlinetraininghub.com/excel-expert-upgrade View all my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-08-08T23:00Z 806K followers, 91.7K engagements
"Power BI Dashboards - Non-Financial Data Analysis - FREE Download 🔻 DOWNLOAD the completed Power BI Desktop file and data used in the video here: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create two interactive Power BI dashboards based on school data using the free Power BI tools available to everyone. Get Power BI Desktop here: https://powerbi.microsoft.com/en-us/desktop/ 🎓 LEARN MORE Power BI here: https://www.myonlinetraininghub.com/power-bi-course 🔔 SUBSCRIBE to my free newsletter and get my [---] Tips & Tricks eBook here:"
YouTube Link 2019-08-20T11:00Z 773K followers, 124.3K engagements
"5 Ways to Make Your Excel Data Usable (Splitting Cells) [--] different ways to split cells into columns and rows. 👩🏫 Learn more about the Advanced Excel Formulas course: https://bit.ly/splitcells24course Download the example file here and follow along: https://bit.ly/splitcells24file 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"
YouTube Link 2024-12-17T11:45Z 819K followers, 43.5K engagements
"No More DAX Power BIs NEW Feature Explained (File Included) With Visual Calculations you might not need DAX anymore in Power BI. 👩🏫 Learn more about my Power BI course: https://bit.ly/3zHT4SM Download the example file here and follow along: https://bit.ly/viscalc24file Ever felt overwhelmed by the complexity of DAX formulas in Power BI Or maybe youre just getting started and the thought of mastering DAX feels like a huge challenge. What if I told you theres a simpler way to handle all those calculations Say hello to Power BI's brand-new Visual Calculations. Visual Calculations simplify"
YouTube Link 2024-07-16T11:45Z 810K followers, 230.5K engagements
"Power Query Change Type Using Locale Fix dates and numbers imported with different region settings with Power Query's Change Type Using Locale setting. See step by step written instructions here: https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query 00:17 Identifying the Problem 1:55 Fixing the problem with Change Type Using Locale View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2021-03-25T12:00Z 826K followers, 26.4K engagements
"NEW Excel Drop-Down Lists That Adapt to Your Data Create self-updating dependent drop-down lists with dynamic array formulas. 👩🏫 Learn Excel with my courses: https://bit.ly/ddlists24courses Download the example file here and follow along: https://bit.ly/ddlists24file Dependent drop-down lists where you choose a country and magically the next drop-down list only displays the states for that country used to be laborious to set up and maintain but now that we have dynamic array formulas we can make them dynamic so they automatically grow with your data. In this video Im going to show you two"
YouTube Link 2024-08-27T11:45Z 699K followers, 113.6K engagements
"7 Advanced PivotTable Techniques That Feel Like Cheating Advanced Pivot Table tips & tricks to make you a PRO Excel user. 👩🏫 Learn more about the Excel Dashboard course: https://bit.ly/advancedpt24course Download the example file here and follow along: https://bit.ly/advancedpt24file Excel PivotTables are great at summarising data but finding all the hidden tricks that make your data analysis faster and more effective is not so obvious. In this video I will walk you through seven real-world examples that will make your work easier whether youre crunching numbers for a small business or"
YouTube Link 2024-09-24T11:45Z 819K followers, 235.8K engagements
"Boost Your Productivity: Learn How to Display Excel Function Syntax in Cells as a Handy Reference Displaying the function syntax in a cell is a handy tool for writing procedures for other staff to follow or writing tutorials like me. With this shortcut you can do it in the blink of an eye. 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if"
YouTube Link 2023-04-25T11:45Z 772K followers, 34.7K engagements
"Display Different Top n from a Slicer - EASY Trick Works in Excel or Power BI Toggle through different top n values using a Slicer with a PivotTable Pivot Chart or Power BI. Download the sample Excel and Power BI files here: https://www.myonlinetraininghub.com/toggle-top-n-with-slicers Learn Power Pivot with Mynda's course: https://www.myonlinetraininghub.com/power-pivot-course 0:00 Introduction 0:18 The set up 1:00 Measures 2:58 Create PivotTable 4:14 Insert Slicer 4:42 Insert Pivot Chart 5:52 Dynamic Chart Title Connect with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2021-11-25T12:00Z 804K followers, 60.2K engagements
"Embed Excel Dashboards in PowerPoint - It's so bad The [--] options for embedding Excel Dashboards and charts in PowerPoint and the downsides of each. 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if youre short of time please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum"
YouTube Link 2020-09-02T23:00Z 821K followers, 112.5K engagements
"Excel CUBE Functions can do everything a PivotTable does and more Get started with Excel CUBE Functions the EASY way Download the practice workbook here: https://www.myonlinetraininghub.com/excel-cube-functions CUBE Function List and Reference Guide: https://support.microsoft.com/en-us/office/cube-functions-reference-2378132b-d3f2-4af1-896d-48a9ee840eb2 0:00 Introduction 0:21 Creating PivotTables Suitable for CUBE Functions 0:36 Converting PivotTables to CUBE Functions 1:45 CUBEVALUE Formulas 2:40 Slicer Names 3:17 CUBEMEMBER Formulas 4:25 Nesting CUBE Functions 5:42 Dynamic CUBE Formulas"
YouTube Link 2022-02-03T12:00Z 802K followers, 166.7K engagements
"Excel COUNTIF & COUNTIFS Video Tutorial Learn how to use COUNTIF and COUNTIFS formulas in Excel. Go here for step by step written instructions: https://www.myonlinetraininghub.com/excel-countif-and-countifs-formulas-explained View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2010-10-29T02:11Z 824K followers, 402.9K engagements
"How to Build Power BI Reports from Start to Finish 🔻 DOWNLOAD the completed Power BI Desktop file and data files here: https://www.myonlinetraininghub.com/how-to-build-power-bi-dashboards In this video you will learn how to create two interactive Power BI dashboards plus a decomposition tree using the free Power BI tools available to everyone. Get Power BI Desktop here: https://powerbi.microsoft.com/en-us/desktop/ 🎓 LEARN MORE - My Power BI course: https://www.MyOnlineTrainingHub.com/power-bi-course - Introduction to cleaning data with Power Query: https://youtu.be/L4BuUzccLpo 🔔 SUBSCRIBE"
YouTube Link 2020-11-02T23:00Z 815K followers, 1.6M engagements
"Excel FILTER Function incl. Trick to Rearrange Column Order The Excel FILTER function is incredible It enables you to extract a subset of your data based on criteria you specify. You can think of the FILTER function like a lookup that returns multiple matches. The FILTER function can return a single column of data or multiple columns and with a clever trick which Ill show you at the end it can even return non-adjacent columns. Download the Excel file here: https://www.myonlinetraininghub.com/excel-functions/excel-filter-function 0:00 Introduction to FILTER 0:31 FILTER function Syntax 1:03"
YouTube Link 2021-10-14T12:00Z 802K followers, 189.4K engagements
"Freeze Panes vs Split Panes - The Correct Way to Use Them One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes set. Theyre easily confused so I thought Id explain the difference. View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-12-22T23:00Z 811K followers, 39.5K engagements
"Extract Data to Separate Sheets the Right Way Theres a little known tool for PivotTables that will automatically extract the source data to separate sheets based on criteria. Download the Excel file here: https://www.myonlinetraininghub.com/excel-pivot-tables-to-extract-data View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 How to extract data to separate sheets in Excel 0:40 Using PivotTables to extract data 4:11 Using FILTER function to extract data 7:23 PivotTables vs Formulas for extracting data"
YouTube Link 2022-10-13T11:45Z 775K followers, 295.4K engagements
"This One Function Does What Most Excel Users Cant Figure Out The Excel formula you NEED for grouping & pattern problems (MOD) 👩🏫 Advanced Excel Formulas course: https://bit.ly/mod25course Download the example file here and follow along: https://bit.ly/mod25file Im sure youve sat through your fair share of high school classes thinking 'When am I ever going to use this' I did. I completely blanked on modular arithmetic back then no memory of it at all. But guess what It turns out Excel's MOD function is a total game-changer and I wish Id paid attention In this video Im going to show you 6"
YouTube Link 2025-02-11T11:45Z 820K followers, 199.4K engagements
"SECRET Excel Named Range Shortcuts to Save Time Defining names in Excel has a load of benefits from faster formula writing easier to read workbooks and more robust files. In this video I cover the various types of names you can define and some shortcuts the experts use. Download the Excel file here: https://www.myonlinetraininghub.com/excel-named-range-shortcut View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:21 Types of Defined Names 0:37 Defining Named Cells 1:37 Defining Named"
YouTube Link 2022-04-28T12:00Z 773K followers, 63.6K engagements
"Excel for Beginners - Cut Copy and Paste like a Pro Lesson [--] of [--] - Get started with Excel and learn how to cut copy and paste like a pro user. Download the Excel file for all [--] lessons here: https://www.myonlinetraininghub.com/workbook-downloads Get the full course here: https://www.myonlinetraininghub.com/microsoft-office-online-training-courses View all my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-08-08T23:00Z 814K followers, 167.8K engagements
"Excel VLOOKUP Formula Exact Match video tutorial Watch this video to learn how to create a VLOOKUP Exact Match Formula in Excel. Click here for step by step written instructions: https://www.myonlinetraininghub.com/excel-vlookup-formulas-explained View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2010-10-05T20:04Z 816K followers, 142.4K engagements
"Excel Formula to List First Monday in each Month Generate a list of the first Monday date in each month with this easy formula. Download the workbook here: https://www.myonlinetraininghub.com/list-first-monday-date-in-each-month View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-01-20T23:00Z 828K followers, 45.6K engagements
"Custom Excel Chart Label Positions GHOST Trick Customize Excel Chart Label Positions with a ghost/dummy series in your chart. 🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/custom-excel-chart-label-positions 🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 🔔 SUBSCRIBE if youd like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all 🧟♀ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if youre short of time please click the 👍 💬 EXCEL QUESTIONS: Get"
YouTube Link 2020-02-19T23:00Z 803K followers, 51.2K engagements
"Everyone's Talking About This NEW Excel Function (TRIMRANGE) New Excel TRIMRANGE Function Explained Download the example/practice file here: https://www.myonlinetraininghub.com/excel-trimrange-function 👩🏫 Master Excel with my courses: https://bit.ly/trimrange24courses Learn more about the BYROW function: https://youtu.be/8-ANSpXcHr0 There's a new function just released in the beta version of Excel that will save you a ton of time. It's called TRIMRANGE Its nothing like the TRIM function. TRIMRANGE automatically detects the cell range your data occupies and expands and contracts with it. You"
YouTube Link 2024-10-21T11:45Z 768K followers, 172.8K engagements
"Top [--] Most Important Intermediate Excel Functions Most Excel users know the basic functions like SUM COUNT AVERAGE etc. Therefore in this tutorial Im going to cover the [--] most important intermediate level Excel functions every Excel user should know. Watch the video for an introduction to each function and then dive deeper by following the links below. Download the file here: https://www.myonlinetraininghub.com/top-10-intermediate-excel-functions Note: theres technically [--] functions covered in this tutorial but a few of them do the same thing as other functions or are very similar so Ive"
YouTube Link 2022-03-10T12:00Z 802K followers, 67.3K engagements
"Excel Variance Charts Excel charts for plotting budget vs actual variances. Get the workbook from our blog: http://www.myonlinetraininghub.com/charting-variances-in-excel View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2015-04-02T03:10Z 796K followers, 78.2K engagements
"How to Clean Data in Excel in [--] Minutes (Free File) How to clean any data in Excel using these [--] data cleaning tips & tricks (beginner to pro). 👩🏫 Master Excel formulas with real-world examples: https://bit.ly/course240305 Download the example file here and follow along: https://www.myonlinetraininghub.com/how-to-clean-data-in-excel Duplicates extra spaces misspelt words and poor formatting make our job harder than it needs to be. That's not even a complete list of dirty data types. Today's tutorial is all about mastering data cleaning in Excel. We've got a dataset that's a bit on the"
YouTube Link 2024-03-05T11:45Z 827K followers, 258.1K engagements
"Easy Dynamic Dependent Data Validation Two Ways Dynamic Dependent Data Validation lists are easy with dynamic array formulas but in this video I show you both with and without dynamic arrays. Download the Excel file here: https://www.myonlinetraininghub.com/dynamic-dependent-data-validation To dynamically expand the regions for more countries copy the FILTER function across more columns and use the 'not found' argument in FILTER to return blank with two double quotes e.g.: =SORT(FILTER(TblRegionsRegionTblRegionsCountry=H4"")) Then modify the XLOOKUP to also include further columns e.g. if"
YouTube Link 2021-08-26T12:00Z 818K followers, 113K engagements
"Interactive Excel HR Dashboard - FREE Download In this video you will learn how to create an interactive HR dashboard from scratch using Excel's Power Query and Power Pivot tools. Applies to Excel [----] onward for Windows only. 🔻 DOWNLOAD file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads 🎓 LEARN MORE - Learn POWER QUERY here: https://www.myonlinetraininghub.com/excel-power-query-course - Learn POWER PIVOT here: https://www.myonlinetraininghub.com/power-pivot-course 🔔 SUBSCRIBE to my free newsletter and"
YouTube Link 2019-02-22T06:52Z 813K followers, 1.3M engagements
"These Excel Functions Were Great [--] Years Ago (Time to Upgrade) Outdated Excel formulas you should stop using and what to replace them with. 👩🏫 20% off all Excel courses ends May [--] Grab the Advanced Formulas course here: https://bit.ly/outdated25course Download the example file here and follow along: https://bit.ly/outdated25file You know those Excel functions youve been using for years They used to be essential but thanks to new functions we now have simpler faster and better ways to get the job done. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2025-05-13T11:45Z 768K followers, 75.6K engagements
"Power Query Combine Files with Different Column Names - Super EASY Combining files with different column names in Power Query can be tricky. In this video we look at two scenarios and several ways to tackle it. Download the Power BI Desktop file here: https://www.myonlinetraininghub.com/combine-files-with-different-column-names-in-power-query Learn Power Query with Mynda here: https://www.myonlinetraininghub.com/excel-power-query-course Connect with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:30 Example [--] CSV file data 1:48 Get files from a folder 2:49 The"
YouTube Link 2022-03-03T12:00Z 777K followers, 101.1K engagements
"Use These Excel Tricks to List Dates Automatically (Autofill & Formulas) Autofill dates in Excel based on another cell: days weekdays months and years. 👩🏫 Learn more about my Excel Expert course: https://bit.ly/dates25course Download the example file here and follow along: https://bit.ly/dates25file If you ever need to create a list of dates in Excel theres a quick and easy way to do it without manually typing each one. Whether its consecutive dates only weekdays or custom intervals Ill show you the fastest methods both manual and formula-based. LEARN MORE =========== 📰 EXCEL NEWSLETTER -"
YouTube Link 2025-04-08T11:45Z 803K followers, 78.7K engagements
"Data Analysis for BEGINNERS in Excel in [----] No Python Required How to analyze data with no programming languages in [--] minutes. 👩🏫 Improve your productivity in Excel with Power Query: https://bit.ly/powerquery0124 ➡ DOWNLOAD the free example file here: https://bit.ly/danalysisfile Have you ever looked at an Excel spreadsheet and wondered "Where do I even start" The numbers blur into a maze of confusion and the data seems like an unsolvable riddle. All while the clock is ticking on your deadline. The good news is as a data analyst you don't necessarily need to use complex programming"
YouTube Link 2024-01-23T11:45Z 813K followers, 136.4K engagements
"Are You Missing Out on Excels Secret Function Excel function for data organization that lists all files in a folder. 👩🏫 Learn more with my Excel courses: https://bit.ly/files24courses Download the example file here and follow along: https://bit.ly/files24file I bet I can name an Excel function that youve never heard of. Are you ready Its called 'FILES'. Its available in all versions of Excel but not in the conventional way which Ill cover in a moment. The FILES function lists all files contained within a specified folder and there are loads of uses for this information. FILES is a legacy"
YouTube Link 2024-06-04T11:45Z 811K followers, 55.7K engagements
"New Excel STOCKHISTORY Function - Definitive Guide We've been waiting a long time for the Excel STOCKHISTORY function and it doesn't disappoint. Get historical prices for stocks bonds funds crypto and foreign currency pairs. Download the Excel file here: https://www.myonlinetraininghub.com/excel-stockhistory-function View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/"
YouTube Link 2020-06-18T04:50Z 773K followers, 54.2K engagements
"Excel: [--] AI Game-Changers DOWNLOAD the example file here: https://www.myonlinetraininghub.com/built-in-excel-ai-tools Dive into [--] OFFICIAL Microsoft AI tools that'll skyrocket your productivity by 10x No third-party add-ins just pure Excel magic. With just a click: 🧹 Make your data spotless 🧮 Craft formulas effortlessly Analyze data like a pro 📊 Visualize data in dazzling ways TOPICS IN MORE DETAIL: ===================== Flash Fill: https://youtu.be/VfRyCLFQTi8 Excel Labs: https://youtu.be/yIAl1XbuVzU Forecasting: https://youtu.be/9zFQrRRwpl0 Formula by Example:"
YouTube Link 2023-09-05T11:45Z 773K followers, 78.9K engagements
"The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS) Database Functions are similar to the *IFS functions but much better. 👩🏫 Learn more about the Advanced Excel Formulas course: https://bit.ly/dfunctions24course 👩🏫 Master Excel with my courses: https://bit.ly/dfunctions24courses Download the example file and cheatsheet here and follow along: https://bit.ly/dfunctions24file Imagine you're working with a massive spreadsheet and your boss asks you to sum up sales for a specific product but only if it meets certain criteria. Oh and they need it in the next [--] minutes. Most"
YouTube Link 2024-10-29T11:45Z 775K followers, 229.9K engagements
"The Excel Function That Makes Formulas Easier to Read (and Fix) Turn long messy Excel formulas into clean ones with the LET function. 👩🏫 Master Excel & Power BI with 20% off all my courses until August [--] 2025: https://bit.ly/let25courses Download the example file here and follow along: https://bit.ly/let25file Ever written a giant formula only to break it changing just one value With the LET function we can avoid these headaches AND improve the calc efficiency of our formulas. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2025-08-05T11:45Z 835K followers, 42K engagements
"Is This the End of Excel As We Know It Try Endex AI Agent and save 25% with code MOTH2026 at checkout: https://bit.ly/endexai If youve ever inherited a messy workbook or a valuation model so big you dont know where to start you know how time-consuming it is to understand it. Endex claims to eliminate the drudgery It can understand your workbook like a financial analyst find hidden errors extract PDFs into formulas and even build complete financial models from scratch all from within Excel. That sounded bold to me. So I put it through four practical tests to see what it can really do. Get the"
YouTube Link 2026-01-06T11:45Z 835K followers, 63.3K engagements
"The Excel Feature That Replaces [--] Follow-Up Emails (and a Meeting) Learn how to insert reply to resolve and delete comments in Excel cells and sheets with Threaded Comments. 👩🏫 Join my Excel courses: https://bit.ly/comments25courses Excel turns [--] this month. And after four decades of formulas charts and PivotTables one of my favourite features feels more like a group chat than a spreadsheet. It replaces that quick catch-up meeting that shouldve been an email. Actually it replaces the email too. Let me show you. Instead of tennising emails asking: - Whats in this cell - Why isnt this"
YouTube Link 2025-09-02T11:45Z 835K followers, 16.5K engagements
"Excels Secret Number Generator SEQUENCE Function The SEQUENCE function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/sequence25shorts 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 #ExcelFormulas Mynda Treacy My Online Training Hub Microsoft Excel Excel excel"
YouTube Link 2025-12-19T11:45Z 835K followers, 35.7K engagements
"TEXTJOIN Function Explained in [--] Seconds Excel Tutorial The TEXTJOIN function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/textjoin25yt 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel"
YouTube Link 2025-10-31T11:45Z 835K followers, 33.5K engagements
"The Excel Feature Everyone Loves.But Shouldn't Use (Alternative) Merged cells look clean but they break your filters formulas and PivotTables. Heres an alternative. 👩🏫 Learn more about my Excel Expert course: https://bit.ly/mergedcells25course Download the example file here and follow along: https://bit.ly/mergedcells25file The second part of the video with the solution is on the channel: https://youtu.be/pKJX6B2qTuc Thank you for your activity and interest In this video Im going to show you how to structure your spreadsheets without merged cells so you can still use all the built-in tools"
YouTube Link 2025-07-01T10:45Z 835K followers, 94.2K engagements
"Alternative to Nested IF Formulas in Excel The IFS function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/ifs25shorts 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel functions excel"
YouTube Link 2025-12-05T11:45Z 835K followers, 40.2K engagements
"STOP Using VLOOKUP in Excel (Better Alternative) The XLOOKUP function in Excel: what it is and how to use it. Download the example file here and follow along: https://bit.ly/stopvlookup25yt 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel functions"
YouTube Link 2025-11-14T11:45Z 835K followers, 34.1K engagements
"Difference Between a Function and a Formula in Excel Formula vs Function: important differences in Excel to know. Download the example file here and follow along: https://bit.ly/functionformula25file 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 #ExcelFunction #ExcelFormula Mynda Treacy My Online Training Hub Microsoft Excel Excel excel"
YouTube Link 2025-10-24T11:45Z 835K followers, 26.8K engagements
"The Excel Function You Should STOP Using (Alternatives) Avoid common Excel errors by ditching INDIRECT for better alternatives. 👩🏫 Master Power Query with my course: https://bit.ly/indirect25course Download the example file here and follow along: https://bit.ly/indirect25file Lets talk about a function that seems useful but secretly causes chaos in your workbook: INDIRECT. You enter a cell reference or a defined name as text and INDIRECT turns that text into a real reference. It feels advanced and powerful because it overcomes limitations we used to experience but its one of the top reasons"
YouTube Link 2025-07-15T11:45Z 835K followers, 49.8K engagements
"Create a Self-Updating Work Schedule in Excel (+ Free Template) Build a dynamic work schedule with automatic dates color-coded shifts and time calculations. 👩🏫 Master Excel & Power BI with my courses: https://bit.ly/workschedule25courses Download the example file here and follow along: https://bit.ly/workschedule25file Still typing out work schedules by hand or dragging cells like its [----] In this video Ill show you how to build this smarter schedule in Excel that colour codes itself calculates the finish time for each employee and highlights days off automatically. You dont need to be an"
YouTube Link 2025-07-08T11:45Z 835K followers, 191.2K engagements
"Easy PivotTable Trick That Replaces Dozens of Excel Formulas (File Included) Build dynamic Excel reports with one PivotTable instead of hundreds of formulas includes calculated fields and interactive slicers. 👩🏫 Join my PivotTable - Quick Start course: https://bit.ly/pttrick25course Download the example file here and follow along: https://bit.ly/pttrick25file Many people spend hours every month building Excel reports often requiring hundreds of formulas. In this video Ill show you a faster way to analyze your data in Excel thats easy to modify and ideal for handling last minute changes."
YouTube Link 2025-09-09T11:45Z 835K followers, 50K engagements
"5 Excel Shortcuts Most Users Don't Know About (but should) [--] Excel shortcuts you'll use daily. 👩🏫 Download the FREE Excel Shortcuts Cheatsheet here: https://bit.ly/shortcutssheet25yt 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 #ExcelShortcuts #ExcelTutorial Mynda Treacy My Online Training Hub Microsoft Excel Excel Excel shortcuts"
YouTube Link 2025-10-03T11:45Z 835K followers, 29.7K engagements
"The [--] Most Important Excel Features Ever Released (MUST Know) [--] Excel skills that will make your life easier: PivotTable Tables Power Query and Dynamic Arrays. 👩🏫 Join my Excel & Power BI courses: https://bit.ly/dynamictable25courses Download the example file here and follow along: https://bit.ly/4decades25file Excel just turned [--] and to celebrate Im sharing the four game changing skills and hidden tips from each decade that still pay off today. Master these and everything else gets easier. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here:"
YouTube Link 2025-09-30T11:45Z 835K followers, 37.9K engagements
"SOLVED - Stop Conditional Formatting Duplicating & Fragmenting Stop Excel from quietly breaking your Conditional Formatting rules every time you insert a row. 👩🏫 Master Excel & Power BI with my courses: https://bit.ly/condromatting25courses Download the example file here and follow along: https://bit.ly/condromatting25file Watch the first part of the video here: https://youtu.be/VPJK0hEPy-A Have you ever noticed your conditional formatting rules duplicating and fragmenting on their own Youre not alone. In this video Im going to explain what causes this and a small tweak to prevent it"
YouTube Link 2025-07-29T11:45Z 835K followers, 40K engagements
"Master 80% of Essential Excel Functions in [--] Minutes (2025) Learn the [--] essential Excel functions that handle 80% of real-world tasks. Download the example file here and follow along: https://bit.ly/essentials25file 👩🏫 Learn more Excel functions with my course: https://bit.ly/essentials25course Most people waste hours in Excel because they dont know which functions actually matter. The truth is of the 450-plus functions available you only need about [--] to handle 80% of your work. Learn these and youll work faster and more confidently than ever. LEARN MORE =========== 📰 EXCEL NEWSLETTER -"
YouTube Link 2025-10-07T11:45Z 835K followers, 53.6K engagements
"STOP Ignoring This Excel Feature (One of My Favs) How to insert reply to resolve and delete comments in Excel cells with Threaded Comments. 👩🏫 Join my Excel courses: https://bit.ly/comments25courses Excel turns [--] this month. And after four decades of formulas charts and PivotTables one of my favourite features feels more like a group chat than a spreadsheet. It replaces that quick catch-up meeting that shouldve been an email. Actually it replaces the email too. Let me show you. Instead of tennising emails asking: - Whats in this cell - Why isnt this formula working - Is this value final"
YouTube Link 2025-09-03T11:45Z 835K followers, 27.4K engagements
Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing