Blog • My Online Training Hub

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,

February 18, 2025

Excel Logical Functions

Over a billion people use Excel and let's guesstimate half of them know how to write an IF formula. Of

February 11, 2025

Excel MOD Function

If like me, you probably never thought you'd use modular arithmetic once leaving high school. Surprisingly, Excel's MOD function brings

February 4, 2025

Generate Excel Practice Data with ChatGPT

Sometimes, finding the perfect dataset for your project feels like searching for a needle in a haystack. Whether you need

January 28, 2025

Excel Formula Race

When working with large datasets in Excel, some functions and formulas can seriously impact calculation speed. I ran an Excel

January 21, 2025

How to Get Microsoft Excel for Free

If you're looking to use Microsoft Excel without spending a penny, you're in luck! Microsoft offers legitimate ways to access

January 14, 2025

Excel Income & Expense Tracker

Master Your Finances: Build a Simple Interactive Tracker in Excel or Google Sheets Taking control of your money is one

January 7, 2025

Best New Excel Features for 2025

2024 was a groundbreaking year for Excel updates, bringing a wealth of new features designed to elevate productivity. But with

December 17, 2024

How to Split Data into Separate Cells in Excel

If you've ever received a dataset where first names, last names, or even birthdays are bundled into a single cell,

December 10, 2024

Excel Interview Questions

A solid understanding of Excel is a must-have for many top-tier roles, especially in fields like accounting, data science, and

December 3, 2024

Must-know Excel Features

Even if you use Microsoft Excel daily, you may not be leveraging some of its best time-saving tools. In this

November 26, 2024

Common Excel Mistakes

Many Excel users are confident in their skills, but Excel's vast functionality means it's easy to overlook some useful features.

November 19, 2024

Introduction to Power Pivot in Excel

Excel PivotTables are fantastic for basic analysis, but they have limitations, particularly when working with large datasets or multiple data

November 12, 2024

Excel Quick Access Toolbar

If you're looking to speed up your workflow in Excel, there's a powerful yet often overlooked tool that's been right

November 5, 2024

Excel Paste Special Tricks

Most Excel users rely on the Paste Special dialog box for one thing: pasting values. But did you know there