Master Excel, Word & 365 — One Quick Video at a Time

Welcome to Tryit Learnit 365 — your go-to source for clear, practical Microsoft 365 tutorials. Whether you're fixing formatting in Word, building smarter formulas in Excel, or exploring new features in Microsoft 365, you'll find fast solutions that save time and clicks.

Browse the latest videos below or use the search bar to jump to exactly what you need.
📊🧠💡

Don’t forget to subscribe on YouTube and join thousands of viewers getting smarter with Microsoft 365 every week!

Skip to Videos
  • How to Find Text Inside Excel Cells Using XLOOKUP and SEARCH
    • 4/30/25

    How to Find Text Inside Excel Cells Using XLOOKUP and SEARCH

    🔍 Learn how to find words like “Customer” inside Excel cells using XLOOKUP + SEARCH. Perfect for partial matches in departments, rosters, and beyond!

  • Count Duplicates in Excel (3 Easy Methods)
    • 4/21/25

    Count Duplicates in Excel (3 Easy Methods)

    📊 Learn how to count duplicates in Excel using Conditional Formatting, COUNTIF, and Pivot Tables! Perfect for data cleanup and quick analysis 🧹🔍.

  • Auto-Number Rows in Excel from Any Starting Point
    • 4/20/25

    Auto-Number Rows in Excel from Any Starting Point

    🔢 Learn two simple ways to apply auto-numbering in Excel—even if your data starts on row 10! Great for lists, reports, and logs 📊✅.

  • Add Time in Excel (Even Across Midnight!)
    • 4/20/25

    Add Time in Excel (Even Across Midnight!)

    🕒 Learn how to calculate hours worked in Excel, including shifts that cross midnight! Great for time tracking, overnight schedules, and fixing time formula errors 🧮🌙.

  • Create a Multi-Line Chart in Excel
    • 4/20/25

    Create a Multi-Line Chart in Excel

    📊 Learn how to make a multi-line chart in Excel to compare sales, trends, or performance across years. Great for time-based data and easy to customize! 📈🧠

  • Fix Open Apostrophes in Word for Legal Documents
    • 4/20/25

    Fix Open Apostrophes in Word for Legal Documents

    🔍 Struggling with open apostrophes in Word? Learn how to replace them with proper closed (curly) apostrophes—a must for legal formatting and patent documents ✍️⚖️.

  • Delete  Continuous Section Breaks in Word
    • 4/20/25

    Delete Continuous Section Breaks in Word

    ✂️ Can’t delete a continuous section break in Word without messing up your layout? Learn how to remove it without shifting formatting—step by step! 🧠📄

  • Accept Only Formatting Changes in Word
    • 4/20/25

    Accept Only Formatting Changes in Word

    📝 Tired of accepting all changes when you just want to clean up formatting? Learn how to accept only formatting changes in Microsoft Word using Track Changes 🧠✅.

  • Use Continuous Section Breaks for Multi-Column Layouts in Word
    • 4/20/25

    Use Continuous Section Breaks for Multi-Column Layouts in Word

    📄 Learn how to use a continuous section break in Word to mix multiple columns and single-column text on the same page—perfect for layout control and design flexibility! ✍️🧩

  • Delete All Section Breaks in Word Instantly
    • 4/20/25

    Delete All Section Breaks in Word Instantly

    ✂️ Want to clean up your Word document fast? Learn how to delete all section breaks at once using Find and Replace—perfect for removing continuous breaks too! 📄🧹

  • VLOOKUP in Excel with IFERROR and Named Ranges
    • 4/20/25

    VLOOKUP in Excel with IFERROR and Named Ranges

    🔍 Learn how to use VLOOKUP in Excel to pull missing info from another tab! Combine it with IFERROR for cleaner results and smoother spreadsheets 📄✅.

  • Fix Quotation Marks Switching to Calibri in Word
    • 4/20/25

    Fix Quotation Marks Switching to Calibri in Word

    🔤 Tired of Word auto-switching your quotation marks to Calibri? Learn how to fix font inconsistencies by updating your Normal style and default template 📄🛠️.

  • Clean Up Word’s Navigation Pane with Outline Levels
    • 4/20/25

    Clean Up Word’s Navigation Pane with Outline Levels

    🧹 Learn how to clean up the navigation pane in Microsoft Word by using outline levels! Remove unwanted entries, fix heading levels, and keep your document organized 📄🧭.

  • Stacked Column Chart with True Percentages in Excel
    • 4/20/25

    Stacked Column Chart with True Percentages in Excel

    📊 Learn how to create a stacked column chart in Excel and adjust the vertical axis to reflect true percentage values—no misleading visuals here! 🧠✅

  • Mail Merge in Word Using Excel
    • 4/20/25

    Mail Merge in Word Using Excel

    📬 Learn how to create a mail merge in Word using Excel data—without the step-by-step wizard! Perfect for letters, labels, and donor lists 📄🔗.

  • Fix Spell Check Not Working in Word 365
    • 4/20/25

    Fix Spell Check Not Working in Word 365

    🔍 Word not catching your typos? Learn how to enable spellcheck across your whole document by fixing hidden style settings 📝💡. No more missing red squiggly lines!

  • Weight Loss Line Chart in Excel 365
    • 4/20/25

    Weight Loss Line Chart in Excel 365

    📉 Learn how to create a clear and personalized weight loss line chart with markers in Excel 365! Great for progress tracking, adding labels, and making data easier to read 💪⚖️.

  • XLOOKUP in Excel Made Simple
    • 4/19/25

    XLOOKUP in Excel Made Simple

    🔍 Learn how to use XLOOKUP in Excel with a simple, real-world example! Match data between two tabs and return results instantly—with help from a surprise cat cameo 🐱📊.

  • Use Continuous Section Breaks in Word
    • 4/19/25

    Use Continuous Section Breaks in Word

    🧩 Learn how to insert a continuous section break in Word!
    Perfect for changing layouts like columns or formatting without starting a new page 📄✨.

  • How to Use XMATCH in Excel
    • 4/19/25

    How to Use XMATCH in Excel

    🔍 Learn how to use the XMATCH function in Excel to find values faster and more flexibly! Explore exact matches, approximate options, and wildcard lookups—all in one smart formula 🧠⚡.

  • XLOOKUP with Multiple Conditions in Excel
    • 4/19/25

    XLOOKUP with Multiple Conditions in Excel

    🔎 Learn how to use XLOOKUP with multiple conditions in Excel 365! This method helps you match month + year to pull precise data—great for reports and time-based analysis 📆📊.

  • Rearrange Excel Columns with XLOOKUP
    • 4/19/25

    Rearrange Excel Columns with XLOOKUP

    🧩 Learn how to quickly sort columns horizontally in Excel using a smart tip and XLOOKUP! Perfect for reordering columns from regularly generated reports 📑⚡.

  • New TEXT Functions in Excel 365
    • 4/19/25

    New TEXT Functions in Excel 365

    🆕 Discover Excel’s latest text functions—TEXTBEFORE, TEXTAFTER, and TEXTSPLIT! These powerful new tools make it easier than ever to extract and split data from text entries 📤🧠.

  • Calculate Expiration Dates in Excel
    • 4/19/25

    Calculate Expiration Dates in Excel

    📅 Learn how to calculate expiration dates in Excel using IF formulas and conditional formatting 🎯. This method highlights expired dates in red and active ones in green—perfect for tracking renewals, licenses, and deadlines!

  • IF, ISNA, and MATCH Function in Excel
    • 4/19/25

    IF, ISNA, and MATCH Function in Excel

    🤔 Learn how to combine IF, ISNA, and MATCH in Excel to return custom values based on whether a match is found 🔍. Perfect for flagging duplicates or missing items!

  • Conditional Formatting with Multiple Rules in Excel
    • 4/19/25

    Conditional Formatting with Multiple Rules in Excel

    🎨 Learn how to apply conditional formatting with multiple conditions in Excel! Use color rules to highlight data based on logic—great for visualizing comparisons and statuses 🔍🟥🟨🟩.

  • Top 5 Excel Flash Fill Tricks
    • 4/19/25

    Top 5 Excel Flash Fill Tricks

    ⚡ Discover the top 5 ways to use Flash Fill in Excel! From combining columns to splitting data and reversing text, these tricks will save you time and clicks ⏱️🧠.

  • Lock Cells in Excel to Prevent Editing
    • 4/19/25

    Lock Cells in Excel to Prevent Editing

    🔒 Want to prevent edits to certain cells in Excel? This quick tutorial shows you how to lock only the cells you choose—perfect for protecting formulas or data in shared workbooks 📊.

  • XLOOKUP with Partial Match in Excel
    • 4/19/25

    XLOOKUP with Partial Match in Excel

    🔍 Learn how to use XLOOKUP with partial matches in Excel! This tutorial walks through matching part of a string—perfect for searches when full values aren’t available 🧠.

  • Create Dependent Dropdowns in Excel
    • 4/19/25

    Create Dependent Dropdowns in Excel

    📋 Learn how to create dependent dropdown menus in Excel using the INDIRECT function! This tutorial walks you through building dynamic menus that change based on a prior selection 🔁.

  • Convert Rows to One Column in Excel
    • 4/19/25

    Convert Rows to One Column in Excel

    🔄 Want to merge rows or columns into a single list? This Excel tutorial shows how to flatten a range into one column using a powerful formula—perfect for reshaping complex data 🧩.

  • Conditional Formatting in Excel with ChatGPT
    • 4/19/25

    Conditional Formatting in Excel with ChatGPT

    🤖 See how ChatGPT can help you apply conditional formatting with multiple conditions in Excel! No Excel expertise needed—just follow the AI’s step-by-step guidance 📊.

  • Excel SORTBY Function + NVIDIA Eyelock Demo
    • 4/19/25

    Excel SORTBY Function + NVIDIA Eyelock Demo

    🔢 Master Excel’s SORTBY function to organize your data like a pro, then check out NVIDIA’s futuristic Eyelock demo 👁️‍🗨️—a cutting-edge look at AI-powered iris tracking in action.

  • Fix Word Table Wrapping Instantly
    • 4/19/25

    Fix Word Table Wrapping Instantly

    📄 Is your Word table getting pushed into the margins or wrapped in weird ways? This quick fix shows how to disable text wrapping and keep your tables exactly where you want them 💡.

  • Transform Data in Excel with TOCOL
    • 4/19/25

    Transform Data in Excel with TOCOL

    🔄 Master Excel’s TOCOL function to reshape your data with ease! Learn how to use TOCOL(Data, 1) to flatten columns into a single list—perfect for simplifying complex tables 🧩.

  • Track Leave in Excel with FILTER
    • 4/19/25

    Track Leave in Excel with FILTER

    📅 Learn how to track employee leave in Excel using the powerful FILTER function! This tutorial walks you through a simple formula to manage team availability and leave records with ease ✅.

  • Monthly Averages in Excel with Pivot Tables
    • 4/19/25

    Monthly Averages in Excel with Pivot Tables

    📊 Learn how to calculate monthly averages in Excel using Pivot Tables!
    This step-by-step guide is perfect for analyzing time-based data like crypto prices, time logs, or transactions 💹.

  • Delete XE Index Entry Fields in Word
    • 4/18/25

    Delete XE Index Entry Fields in Word

    🧹 Clean up your Word document fast!
    Learn how to remove all { XE "..." } index fields using Find and Replace 🪄—perfect for decluttering complex documents in just a few clicks.

  • Fix Capitalization in Excel Fast
    • 4/19/25

    Fix Capitalization in Excel Fast

    🔠 Fix messy text in Excel fast!
    Learn how to clean up names and titles using the PROPER function 🧠 or Flash Fill ⚡. See which method works best for hyphenated names and abbreviations.

  • Auto-Number Rows in Excel
    • 4/19/25

    Auto-Number Rows in Excel

    🔢 Automatically number rows in Excel using the ROW function and Excel Tables—no dragging, no VBA required. This clean, dynamic solution updates every time you add or remove data 📈.