My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
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 …
Ever felt held back with Word documents that just look too plain, almost like they're stuck in the past? You might have put hours of work into writing the text that goes into your document, but no one wants to read them because they look boring and tedious. But it doesn't have to be that …
Reconciliations, variance analysis and debtor management are time consuming tasks finance professionals juggle on a regular basis. But did you know that there's a solution that makes these boring tasks incredibly easy? Microsoft Copilot for Finance is the latest AI tool designed to help you reclaim time. It's like having an expert by your side, …
These days, knowing basic Excel won't set you apart. You have to keep up with new features that enable you to improve productivity, or you'll be left behind. There are 10 must know modern Excel functions that simplify common tasks. These functions will not only make your life easier, they'll also make you the go-to …
There's no denying PivotTables are time-savers! They're one of Excel's most powerful tools, but they have a lot of cool features that most Excel users will never find on their own. In this video I'm going to uncover the pro Excel PivotTable tips & tricks that will take your PivotTables to the next level, so …
Believe it or not, more than half the job listings across a wide range of industries identify Excel as an essential skill. From administrative assistants to sales managers and data analysts to name a few. I'm going to share 3 Excel skills employers want that will put you on the fast track to the top. …
Ever felt like you're wrestling with spreadsheets, trying to make sense of overwhelming data, only to end up with static charts that barely scratch the surface of what's truly happening? You're not alone. In this Power BI tutorial for Excel users we'll turn that frustration into empowerment. Power BI's visualization capabilities are not only more …
Sending out a report that contains errors is embarrassing. I know, I've done it! You present a report to management, and they come back with questions around errors you should have found. In this post I'll share 11 essential steps for pristine data to ensure it doesn't contain duplicates, extra spaces, misspelt words, and other …
Excel Dashboards may appear intimidating at first glance, but by mastering three simple steps, you'll be crafting interactive dashboards like the one below in no time. And when you can update them with the click of a single button, they'll be sure to get you noticed and hopefully promoted. If not, you'll have the skills …
Ever felt like you're spending hours on tasks in Excel that should take minutes? You're not alone. These are my top Excel productivity tips for work and study. For each tip, I'll present a problem and a solution. Check out the video below for a demonstration. Table of Contents Excel Productivity Tips Video Use Templates …
Using Excel as a QR Code Generator is quick, easy, and free. 20 years after the first scanning of the UPC barcode, its successor, the 2D matrix barcode was invented - what we now know as the QR Code. QR codes are used for everything - marketing campaigns, contactless payments, business cards, and restaurant menus …
In today's data-driven landscape, mastering the art of data analysis is an essential skill that can open doors. Join us as we delve into the fundamental stages of data analysis, encompassing everything from data collection and cleansing to insights that empower you to make informed decisions. As a data analyst your role revolves around harnessing …
No matter whether you're an Excel newbie or an expert, be prepared to revolutionize how you work in Excel with ChatGPT. ChatGPT can magically turn you into an Excel wizard within seconds. It can help you find the right function to use, explain how any function works, and even speed things up for you. All …
The GROUPBY and PIVOTBY functions are a significant breakthrough in Excel's toolbox of functions. They let you easily group or aggregate data, a concept that's been around in Excel since the days of PivotTables in 1993 and Power Query since 2010. But what's exciting about GROUPBY and PIVOTBY is that they simplify this process down …
With the cost-of-living crisis affecting everyone, it's essential to get control of your finances. Having a personal budget can be your most valuable tool, but creating a budget spreadsheet from scratch can be intimidating, time-consuming, and, for some, a downright chore. In this post I'll step you through creating a personal budget in Excel, that's …
Imagine having a tool that transforms the way you work, a tool so powerful it's valued at a minimum of $237,600 a year1. Yes, you read that right! Microsoft 365 Copilot, "the most powerful productivity tool on the planet"2 1. This was the minimum investment when Copilot was first available. Thankfully, now you can get …
With AI gradually making its way into every aspect of our lives, working in Excel has become much easier. You no longer need to research the web and copy over the data into Excel. Simply prompt the AI in natural language, and it will spill out the results for you within Excel! All thanks to …
New in October 2023, Microsoft introduced Excel checkboxes embedded directly within cells*. This enhancement is set to streamline data interaction and management in Excel, making it more efficient and user-friendly. *Currently available to Microsoft 365 users on the Beta channel. Table of Contents Download Example File Excel Checkboxes in Cells Video Excel Checkboxes in Cells …
We now have a new, improved way to import data from the web to Excel. Just like in Power BI, the Get Data > From Web connector for Power Query in Excel now auto-detects tables and curates them into a Suggested Tables list. Plus, you can use the AI-driven Add Tables Using Examples to show …
Slicers enable you to quickly and easily toggle filters on and off. They're best known for working with PivotTables, but Slicers also work with Excel Tables. I like to use them to save time applying filters I use regularly, but we can also create dynamic reports by leveraging formulas that can recognize when a row …
Descriptive statistics enable you to summarize, organize, and simplify large datasets to derive meaningful patterns and insights. For a long time there’s only really been one tool to get descriptive statistics in Excel, but in this tutorial, I cover 3 ways. They all have their pros and cons. Table of Contents Download the Excel …
Slicers are a fantastic tool to get a filtered view of your data and visuals. But by default, they get sorted alphabetically or follow the calendar year if your parameter contains months. What if you wanted them sorted in a custom order? Maybe you want to show fiscal years, a Sunday to Monday work week …
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 …
