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.
Techniques
By the end of this post, you’ll be able to enter a zip code into a cell and Excel will automatically populate the city and state cells! Specifically, we’ll use Excel’s WEBSERVICE and COPILOT functions. Think of this as combining the power of AI with Excel’s brilliant data connectivity. Video Overview of the Solution This…
Read More
Managing loans and tracking monthly payments just got a whole lot easier. In this tutorial, we’ll explore the PPMT function in Excel—a lesser-known but incredibly powerful function that calculates the principal portion of a loan payment for a specific period. Even better, we’ll show how to transform this function into a fully dynamic loan amortization…
Read More
If you’re managing projects and need a simple way to track progress, Excel’s Agile Gantt Chart template can be a great starting point. This built-in template provides a visual representation of tasks, milestones, and progress, making it easier to stay organized. Video Step-by-step Guide In this guide, we’ll walk through how to: Let’s dive in!…
Read More
Managing your personal finances is easier when you have a structured budget in place. Fortunately, Excel provides built-in budget templates that can help you track your income, expenses, and savings without starting from scratch. In this guide, we’ll walk through how to find, use, and customize a simple annual budget template in Excel to fit…
Read More
In this post, we’ll dive into the following Excel question: How do you sum positive values between two dates? Using the SUMIFS function, we’ll walk through three exercises to build a solution step by step. By the end, you’ll have a clear understanding of how to sum data based on multiple conditions. Let’s get started!…
Read More
Hello, and welcome to our latest Excel tutorial! I was recently asked the following question: how do I see the max date for each vendor assuming each vendor has multiple dates? So, in this post, we’ll learn how to find the maximum date for each category — in this case, each vendor with multiple transactions.…
Read More
Hello, Excel enthusiasts! Welcome back! Today, we’re diving into an interesting question I received recently: “How do I count occurrences between two dates in Excel?” As with most things in Excel, there are multiple ways to accomplish this task. In this post, I’ll focus on how to achieve our goal with a PivotTable. If you’re…
Read More
Today, we’re tackling the following question: How do you create a calendar that can show multiple events per day in Excel? We’re going to transform a simple table of events into a dynamic, graphical calendar. Let’s dive right in! Objective In summary, we have a list of events stored in a Table named Table1, like…
Read More
I was recently asked the following question: I download an excel file every week and make changes like deleting columns, counting and adding rows and so on. Can I automate this repetitive task ? In this post, I’ll attempt to answer this question. The built-in Excel feature we’ll use to accomplish this is Power Query.…
Read More
Time to walk through another exciting Excel adventure 🙂 Today, we’re zooming in on an interesting question I recently received: “How can I highlight correct answers on an Excel worksheet for my granddaughter’s multiplication tables?” Sounds like a marvelously practical application of Excel, doesn’t it? Well, let’s dive in and find out how we can…
Read More