Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Features
Microsoft has just introduced one of the most impactful updates to PivotTables in recent memory: Auto Refresh. If you’ve ever relied heavily on PivotTables for financial reports, dashboards, or data summaries, this new feature is a game changer. In this guide, we’ll walk step-by-step through how to enable and use PivotTable auto refresh in Excel,…
If you’ve ever wished Excel could just “do the work for you,” then Microsoft Copilot might be exactly what you need. This AI-powered assistant can generate formulas, analyze data, apply formatting, and even explain complex calculations—all with simple, natural-language commands. Want to access Copilot? Check out this Microsoft Office 365 Bundle which includes Copilot, Excel,…
Planning an event can be a challenge, especially when tracking invitations and RSVPs. Fortunately, Microsoft offers a free Invitation Tracker template that can help streamline the process. Whether you’re organizing a wedding, birthday party, or corporate event, this template provides an easy way to manage guest lists, invitation statuses, and responses. In this guide, we’ll…
If you’ve ever wanted to create a reusable calendar that automatically updates each year with birthdays, holidays, and special events, then this tutorial is for you! In this guide, we’ll walk through how to use an Excel template to set up a dynamic events calendar—perfect for printing and gifting to family members each year. By…
A spin button in Excel is a great way to create an interactive and dynamic scrolling range for reports, dashboards, or data analysis. In this tutorial, we’ll walk through how to insert a spin button, link it to a cell, and use it to scroll through data by days, weeks, months, quarters, and years. Let’s…
When working with messy data, we often turn to Excel, but with the rise of AI tools like ChatGPT, we now have new ways to tackle these challenges. In this post, we’ll compare Excel and ChatGPT side by side, using three common data tasks: We’ll see how each tool handles the job, the pros and…
Creating an interactive Excel dashboard doesn’t have to be complicated. With just a few steps, we can transform raw data into a dynamic, easy-to-read report that updates automatically as new data comes in. In this guide, we’ll walk through the process of building an Excel dashboard using pivot tables, pivot charts, and a timeline filter.…
Are you ready to save hours of manual work each week? In this guide, we’ll explore how to automate your workflow in Excel using tools like Power Query, Pivot Tables, and Pivot Charts. Best of all, you don’t need to be a coding wizard to get started. By the end, you’ll know how to effortlessly…
When working with drop down lists in Excel, creating dependent drop downs that dynamically adapt based on a primary choice is both powerful and time-saving. This post walks through setting up rows of dependent drop downs and concludes with a method to notify users when a secondary choice becomes invalid. Let’s dive in! Video Step-by-step…
Hello, Excel enthusiasts! Today, we’re diving into a neat trick: automatically formatting input cells based on whether they meet specific criteria. The goal? Identify and format cells where the first digit of the input is a “4.” But, you can apply this same technique to other criteria. By the end of this post, you’ll have a clear…