Excel

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

Excel has a load of AI tools already built-in that we can use to improve productivity and make our lives easier. There are Excel AI tools that will clean data, analyze it for you, create automatic forecasts and even write custom LAMBDA formulas. And that’s all before Copilot gets added! Let’s take a look at …