Mynda Treacy, Author at My Online Training Hub

September 16, 2025

Dynamic Excel Tables for Smarter Spreadsheets

If you’ve ever wasted time reformatting data, copying formulas, or fixing PivotTables that mysteriously miss your latest data, you’re probably

September 9, 2025

Excel Data Analysis Without Formulas

Do you spend hours every month building Excel reports full of repetitive formulas? You're not alone. Many professionals use hundreds

September 2, 2025

Excel Threaded Comments

If you’ve ever asked a teammate: ... you know how quickly those questions turn into long email chains, chat threads,

August 26, 2025

5 Ways to Link Data in Excel and Automatically Sync

Whether you're working with raw inputs, dashboards, reports, or filtered views, manually updating everything is slow, error-prone, and unnecessary. There

August 19, 2025

Excel COPILOT Function

Excel is now a whole lot smarter. Imagine typing a plain-English question right into a formula: “Classify these transactions into

August 12, 2025

Build a Searchable CRM in Excel with Power Query Custom Data Types

Want to turn your messy customer spreadsheets into a powerful, searchable CRM, right inside Excel? In this step-by-step tutorial, you'll

August 5, 2025

Excel LET Function

Have you ever written a long Excel formula that broke the moment you changed a single value? The LET function

July 29, 2025

Stop Excel Conditional Formatting Rules Duplicating and Fragmenting

Have you ever opened the Conditional Formatting Rules Manager in Excel only to find your rules have mysteriously duplicated or

July 22, 2025

Power Query vs Power Pivot vs VBA

Power Query, Power Pivot, VBA, and Office Scripts, you’ve likely heard of them all. But knowing when to use each

July 15, 2025

Alternatives to the INDIRECT Function

The INDIRECT function in Excel might seem like a clever solution, turning text into live references and helping build dynamic

July 8, 2025

Automated Work Schedule in Excel

Still typing out employee schedules by hand or dragging cells like it’s 2005? Let’s fix that with an automated work

July 1, 2025

Dynamic Merged Cells in Excel

At first glance, (regular) merged cells can make your spreadsheet look clean and polished - just the way most teams

June 24, 2025

Excel Macros & VBA 101

If you've ever caught yourself doing the same clicks in Excel over and over - formatting columns, rearranging data, applying

Excel Tables Absolute Structured References

June 17, 2025

Excel Table Absolute Structured References

Excel Tables are brilliant for structured data and dynamic formulas, but if you’ve ever copied a formula across columns and ended

June 10, 2025

Excel Formula Symbols

Ever seen strange symbols like #, @, { }, or ~ pop up in Excel formulas and wondered what they

June 3, 2025

Excel IF AND OR Functions Explained

Excel’s IF function is one of the most powerful tools in your spreadsheet arsenal. Combine it with AND or OR,

May 27, 2025

Excel SUM with OR Criteria

Ah, SUM - the first Excel function most of us learn. It’s great for adding up columns and rows, but what if

May 20, 2025

13 Time-Saving Excel Productivity Tricks

Think you know Excel? Think again. These 13 hidden gems will streamline your work, eliminate frustration, and unlock features most

May 13, 2025

Outdated Excel Functions (and What to Use Instead)

Excel is always evolving, and so should your formulas. While classic functions like VLOOKUP, MATCH, and OFFSET were once essential,

May 6, 2025

Excel Automated Invoice Template

If you've ever wanted to create an invoice system in Excel that automatically updates, records, and clears itself—you're in the

April 29, 2025

How to Calculate Percentages in Excel

Ever Googled“how to calculate percentages in Excel”? You’re not alone. We all learned percentages in school — but Excel adds

April 22, 2025

Excel Settings You Need to Change

Raise your hand if Excel’s default settings have ever driven you just a little bit crazy. Maybe your invoice numbers

April 15, 2025

New Excel Functions for Accountants

Microsoft has recently released a set of game-changing Excel functions that would’ve been a dream come true back in my

April 8, 2025

How to AutoFill Dates in Excel

Need to create a list of dates in Excel? Whether you're scheduling projects, building timesheets, or planning reports, it’s quick

April 1, 2025

How to Earn Extra Income with Excel

Excel is one of the most in-demand skills in the world. Businesses, freelancers, and analysts all rely on it. Yet,

March 25, 2025

Excel Goal Seek

Have you ever tried to tweak numbers in Excel manually to find the right value? Whether it’s figuring out how

March 18, 2025

Python vs Excel for Data Cleaning

Data cleaning is one of the most time-consuming tasks for analysts. While Python is a powerful tool, it’s not always

March 11, 2025

Automatically Highlight Key Data in Excel

Excel is packed with hidden tricks that can save you hours of manual work. One of the best ones? Automatically

March 4, 2025

The Best Excel Functions for Dynamic References

Imagine you've built an Excel report, and everything looks great. But when you add data for the next month, your

February 25, 2025

Extract Data from One Sheet to Another

Extracting subsets of data from large datasets is crucial for making informed decisions. However, manually filtering data can be time-consuming,