My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
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. …
Dashboards are time consuming to make, but this AI dashboard generation tool can make them in under a minute, and it's not ChatGPT! We'll take a basic table of data and transform it into the dynamic, interactive dashboard you see below with minimal effort, thanks to the power of AI. By the end of this …
Handling messy data is a common challenge for anyone working with Excel. Tasks such as splitting columns, merging tables with VLOOKUP or XLOOKUP, unpivoting, transposing data, and removing duplicates can be tedious, especially if they need to be repeated regularly. Imagine cutting your data cleanup time in half! That's what Emmanuelle did with Power Query …
Ever felt overwhelmed by the complexity of DAX formulas in Power BI? Whether you're just getting started or have been working with Power BI for a while, mastering DAX can seem like a monumental task. But what if I told you there's an easier way to handle those calculations? Enter the brand-new Power BI Visual …
If you've ever wrestled with Excel's formula bar, you know how frustrating it can be. Limited space, lack of formatting, debugging difficulties, and no real-time error detection can make writing anything beyond basic formulas a tedious task. However, there's a game-changing solution available: the Advanced Formula Environment (AFE) developed by Microsoft. Table of Contents New …
Imagine needing to gather data from multiple users without letting them see each other's entries or risking your file's integrity by giving too many people access. Traditionally, this would have been managed using Excel User Forms, but these are outdated and require VBA skills. Moreover, they are limited to desktop use, which isn't practical for …
Microsoft Excel is packed with hidden tools that can transform your workflow, yet many users never discover them. Today, I'm unveiling five secret Excel tools that will enhance your productivity and make your tasks easier. By the end of this blog post, you'll wonder how you ever managed without them. My favorite is number four …
Did you know that Excel skills can earn you over $100,000 a year? This guide will show you how to make money with Excel, turning your knowledge into cash, no matter your experience level. We'll cover everything from beginner to advanced roles and even share opportunities for those who prefer to work independently. Stay tuned …
Hidden within Excel (sometimes in plain sight) are game-changing tools that most users overlook. In this post, I'm going to share 6 must-know Excel tools that will transform your productivity. You can watch the video below or read on to learn more about these tools. Table of Contents Must-know Excel Tools Video Free Practice Workbook …
Ever heard of the Excel FILES function? If you haven't, you're not alone. This little-known function can list all file names in a folder and has been part of Excel for many versions. However, it's hidden as a legacy Excel 4 Macro function. In this post I'll reveal how to use the FILES function and …
In a world where data analytics is becoming the cornerstone of business decisions, the demand for skilled data analysts has skyrocketed, and according to the U.S. Bureau of Labor Statistics, it will continue to grow. Data analytics in Excel is at the heart of the toolkit because 80% of a data analyst's time is spent …
Parsing text in Excel with functions like FIND, MID, and SUBSTITUTE can be cumbersome and inefficient, especially for complex tasks. These limitations make advanced text manipulation time-consuming and error-prone, not to mention frustrating. The new Excel REGEX functions* revolutionize text manipulation. In this blog post, we'll delve into these new functions, providing practical examples to …
Ever felt overwhelmed by a massive spreadsheet filled with data, wondering how to make sense of it all? In today's fast-paced environment, being able to quickly visualize and interact with your data is crucial for making informed decisions. Here's how you can transform a sea of data into an insightful and interactive dashboard in Excel, …
Excel is the key to unlocking limitless opportunities. It's a skill that can elevate your career, manage your finances like a pro, and turn raw data into powerful insights. Table of Contents In this tutorial I cover everything from the basics right through to tools most Excel users never learn. Topics include: Navigating the interface …
