My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Data cleaning is one of the most time-consuming tasks for analysts. While Python is a powerful tool, it’s not always the most efficient choice for cleaning data. In this post, we’ll show you how Power Query in Excel can clean the same dataset 12x faster—with zero coding that’s 100% reusable. The Challenge: Cleaning a Complex …
Excel is packed with hidden tricks that can save you hours of manual work. One of the best ones? Automatically highlighting important data so you can instantly spot patterns, trends, and outliers without manually searching through thousands of rows of data. Think about tracking overdue payments, spotting underperforming sales, identifying top-performing employees, or flagging unusual …
Imagine you've built an Excel report, and everything looks great. But when you add data for the next month, your charts and formulas don’t automatically update. You’re stuck manually editing them every time you add new data. Sound familiar? It doesn’t have to be this way! Excel offers powerful functions that return dynamic references, allowing …
Extracting subsets of data from large datasets is crucial for making informed decisions. However, manually filtering data can be time-consuming, especially when working with dynamic datasets that frequently update. In this guide, we’ll explore a powerful Excel combo that automates real-time data extraction from one sheet to another as shown below, making it easier to …
Over a billion people use Excel and let's guesstimate half of them know how to write an IF formula. Of that 500 million, 99% don't fully understanding how Excel handles logical tests. This knowledge can be the difference between writing monstrous nested IF formulas like this one below that contains 15 IFs, and 5 CEILING …
If like me, you probably never thought you'd use modular arithmetic once leaving high school. Surprisingly, Excel's MOD function brings that idea to life, solving everyday problems with ease. Let's explore 6 practical examples of how you can use the MOD function in your spreadsheets! Table of Contents Watch the MOD Video Get the MOD …
Sometimes, finding the perfect dataset for your project feels like searching for a needle in a haystack. Whether you need Excel practice data to test a formula, mock up a dashboard, or practice new skills, manually searching the web can be tedious and fruitless. Thankfully, ChatGPT offers a quick and free solution to generate tailored …
When working with large datasets in Excel, some functions and formulas can seriously impact calculation speed. I ran an Excel formula race comparing the speed of popular Excel functions like SUMIFS vs DSUM vs SUMPRODUCT and INDEX & MATCH vs VLOOKUP vs XLOOKUP etc. As well as with dynamic and static ranges and the results …
If you're looking to use Microsoft Excel without spending a penny, you're in luck! Microsoft offers legitimate ways to access Excel for free, including a robust online version and free educational licenses. Let's explore these options and see how you can legally get Excel for free, avoiding cracked copies full of malware. Table of Contents …
Master Your Finances: Build a Simple Interactive Tracker in Excel or Google Sheets Taking control of your money is one of the most vital life skills today. Whether it's budgeting for a vacation or managing monthly expenses, tracking your income and spending is key.In this guide, you'll learn how to create an easy and effective, …
2024 was a groundbreaking year for Excel updates, bringing a wealth of new features designed to elevate productivity. But with so many new tools, which ones truly make a difference? Let's explore some of the most impactful updates that can set you apart in 2025. Note: as these are new features, most of them will …
If you've ever received a dataset where first names, last names, or even birthdays are bundled into a single cell, you know the struggle. Or maybe you're dealing with data that should be divided into rows rather than columns. Whatever the case, clean, organized data is essential, and Excel has a few powerful techniques to …
A solid understanding of Excel is a must-have for many top-tier roles, especially in fields like accounting, data science, and business analysis. Companies often use Excel skills tests to assess candidates.Below, we've compiled a list of essential Excel questions - spanning intermediate tasks and bonus challenges - to help you prepare for your next interview. …
Even if you use Microsoft Excel daily, you may not be leveraging some of its best time-saving tools. In this blog post, we'll explore seven overlooked must-know features that can significantly reduce the time you spend on repetitive tasks. Try these out yourself using the example file provided! Table of Contents Must-know Excel Features Video …
Many Excel users are confident in their skills, but Excel's vast functionality means it's easy to overlook some useful features. These overlooked features can lead to inefficiencies, making tasks more time-consuming than they need to be. The good news? With a few quick adjustments, you can streamline your workflow and make Excel work smarter for …
Excel PivotTables are fantastic for basic analysis, but they have limitations, particularly when working with large datasets or multiple data sources. If you've ever wished you could handle advanced calculations, work across multiple tables, or analyze millions of rows without performance issues, then Power Pivot is the solution you've been waiting for. In this post, …
If you're looking to speed up your workflow in Excel, there's a powerful yet often overlooked tool that's been right in front of you: the Quick Access Toolbar (QAT). Whether you're a fan of keyboard shortcuts or prefer the mouse, the QAT can become your new best friend. In this post, I'll show you how …
Most Excel users rely on the Paste Special dialog box for one thing: pasting values. But did you know there are 16 other Paste Special options that can work Excel magic if you know how to use them? In this blog, I'll share some of my favourite shortcuts to transform messy data into clean, well-organized …
Get ready for an exciting update - Microsoft have released new features in the beta version of Excel* with the TRIMRANGE function and trim reference dot operator. They revolutionize the way you reference cells in formulas. Forget about those long formulas involving OFFSET or INDEX to create dynamic ranges — TRIMRANGE makes managing dynamic data …
Various studies report that nearly 9/10 spreadsheets contain errors, with the majority a result of human error relating to formulas. Spreadsheet errors have cost companies millions, and they can put your reputation and career on the line. In this post, I'll guide you through a simple yet powerful Excel formula checklist to help you avoid …
Have you ever found yourself stuck in an endless loop of watching Excel tutorials, hoping the next one will be the game-changer for your workflow? You sit down to work on a real task, and your mind goes blank—nothing you watched seems to apply. If this sounds familiar, don't worry, you're not alone. Many Excel …
Charts are one of the best ways to visualize data and communicate insights quickly, but using the wrong chart can be embarrassing. Knowing how to choose the right chart for your data is an essential skill for communicating your message clearly and quickly. In this guide, we'll break down the four core charts you need, …
PivotTables are one of the most powerful tools in Excel for summarizing and analyzing data, but there are many hidden tricks that can make them even more effective. In this post, we'll cover seven real-world examples that can transform your data analysis, whether you're working with a small business or managing large-scale corporate data. Table …
Spreadsheets are often seen as boring and dull. With the sheer number of settings in Excel, it's easy to get lost when trying to improve your sheet's visual appeal. Luckily, there are some simple tricks that can transform your spreadsheets into visually engaging, attention-grabbing masterpieces. Below, I'll share seven formatting hacks that will make your …
Imagine you're knee-deep in a sales report, trying to pinpoint the key factors driving your revenue. But as you sift through piles of data, the task feels overwhelming. This is where the Pareto Principle, or the 80/20 rule, becomes your best friend. It helps you focus on the 20% of factors that contribute to 80% …
In today's fast-paced world, staying organized is more crucial than ever. With countless tasks to juggle, it often feels like we're spinning plates just to keep up. But what if there was a way to make your life a little easier with an Excel calendar that updates itself, highlights your busiest weeks, and flags upcoming …
Creating multi-level dependent drop-down lists in Excel can significantly speed up data entry and reduce errors. Whether you're managing data for different countries and their regions or any other related lists, dependent drop-down lists allow for a streamlined process. However, these multi-level dependent drop-down lists used to be laborious to set up and maintain. But …
We've all been there - it's the start of a new month, and you're faced with the overwhelming task of updating your Excel files and reports. It can take hours, if not days, to complete. But it doesn't have to. In this post, I'll show you five Excel spreadsheet automation tricks for common tasks like …
I'm about to show you how one overlooked tool can transform the way you work with data. It's not a complex formula or a hidden setting - it's something so fundamental you'll be shocked you haven't been using it all along. Of course, I'm talking about Excel Tables. Before you say, "Oh, I know all …
Are you ready to elevate your Power BI reports from standard to standout? Power BI's extensive array of settings can be overwhelming, but don't panic! In this guide, we'll show you four easy Power BI design tricks to transform your reports into visually engaging narratives that grab attention and clearly deliver your message. …
