My Online Training Hub - Upgrade Your Skills In Excel, Word and Outlook

Top 4 Excel Features Every Professional Should Master

Mynda Treacy — Tue, 30 Sep 2025 11:45:29 +0000

Excel just turned 40, and over the decades it has introduced features that completely changed the way we work with data. While there have been hundreds of updates, four stand out as truly game-changing. These innovations not only saved time but also reshaped how professionals around the world analyse and present information. In this article, ... Read more

The post Top 4 Excel Features Every Professional Should Master appeared first on My Online Training Hub.

Build an Automated Excel Database

Mynda Treacy — Tue, 23 Sep 2025 11:45:00 +0000

If your work involves capturing and organizing information but you don’t have the budget (or the need) for a full-blown SQL database, Excel can do the job for you. With a bit of setup, you can create an automated, searchable database that saves you time, reduces errors, and simplifies your workflow. In this guide, I’ll walk you ... Read more

The post Build an Automated Excel Database appeared first on My Online Training Hub.

Dynamic Excel Tables for Smarter Spreadsheets

Mynda Treacy — Tue, 16 Sep 2025 11:45:00 +0000

If you’ve ever wasted time reformatting data, copying formulas, or fixing PivotTables that mysteriously miss your latest data, you’re probably using plain cell ranges instead of Excel Tables. Excel Tables aren’t just a visual upgrade - they’re a powerful feature that makes your spreadsheets dynamic, self-maintaining, and far less error-prone. In this guide, you’ll learn: Table ... Read more

The post Dynamic Excel Tables for Smarter Spreadsheets appeared first on My Online Training Hub.

Excel Data Analysis Without Formulas

Mynda Treacy — Tue, 09 Sep 2025 11:45:00 +0000

Do you spend hours every month building Excel reports full of repetitive formulas? You're not alone. Many professionals use hundreds of SUMIFS, COUNTIFS, and AVERAGEIFS formulas across multiple sheets just to answer a handful of business questions. But what if there was a smarter, faster way? In this post, you'll learn how to replace countless ... Read more

The post Excel Data Analysis Without Formulas appeared first on My Online Training Hub.

Excel Threaded Comments

Mynda Treacy — Tue, 02 Sep 2025 11:09:56 +0000

If you’ve ever asked a teammate: ... you know how quickly those questions turn into long email chains, chat threads, or scattered Teams messages. Threaded Excel Comments solve this problem. Instead of bouncing between apps, you keep the conversation right where it belongs - inside the spreadsheet. Note: Threaded comments are available with Microsoft 365 or Excel for the web. ... Read more

The post Excel Threaded Comments appeared first on My Online Training Hub.

5 Ways to Link Data in Excel and Automatically Sync

Mynda Treacy — Tue, 26 Aug 2025 11:45:00 +0000

Whether you're working with raw inputs, dashboards, reports, or filtered views, manually updating everything is slow, error-prone, and unnecessary. There are multiple smart ways to link data in Excel, whether it's from another sheet or workbook, and sync it automatically. In this guide, you'll learn 5 methods to extract and reuse your data, so it ... Read more

The post 5 Ways to Link Data in Excel and Automatically Sync appeared first on My Online Training Hub.

Excel COPILOT Function

Mynda Treacy — Tue, 19 Aug 2025 11:30:41 +0000

Excel is now a whole lot smarter. Imagine typing a plain-English question right into a formula: “Classify these transactions into spending categories,” “Summarise this feedback,” or “Extract the email addresses from this column”, and having Excel instantly deliver the result. Now you can with the new Excel COPILOT function, a built-in AI assistant that reads ... Read more

The post Excel COPILOT Function appeared first on My Online Training Hub.

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

Mynda Treacy — Tue, 12 Aug 2025 11:45:00 +0000

Want to turn your messy customer spreadsheets into a powerful, searchable CRM, right inside Excel? In this step-by-step tutorial, you'll learn how to use Power Query custom data types to combine customer details, interactions, and opportunities into a sleek, self-updating Excel CRM dashboard. No VBA. No add-ins. Just Excel for Microsoft 365. Table of Contents ... Read more

The post Build a Searchable CRM in Excel with Power Query Custom Data Types appeared first on My Online Training Hub.

Excel LET Function

Mynda Treacy — Tue, 05 Aug 2025 11:47:15 +0000

Have you ever written a long Excel formula that broke the moment you changed a single value? The LET function can help you avoid those headaches while improving both readability and performance. Whether you're new to Excel or an advanced user, LET is a game-changer. Table of Contents Watch the LET Function Video Get the ... Read more

The post Excel LET Function appeared first on My Online Training Hub.

Stop Excel Conditional Formatting Rules Duplicating and Fragmenting

Mynda Treacy — Tue, 29 Jul 2025 11:45:00 +0000

Have you ever opened the Conditional Formatting Rules Manager in Excel only to find your rules have mysteriously duplicated or become fragmented? You didn’t create extra rules, so what’s going on? Don’t worry, this frustrating behaviour has a simple explanation and, better still, a reliable fix. In this post, I’ll walk you through what causes ... Read more

The post Stop Excel Conditional Formatting Rules Duplicating and Fragmenting appeared first on My Online Training Hub.