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.
Functions
Imagine having a financial crystal ball—something that gives us a glimpse into how our money could grow into the future. That’s exactly what Excel’s FV (Future Value) function offers. Whether we’re saving for retirement, planning an investment, or just trying to hit a savings goal, FV gives us the power to explore different scenarios and…
Read More
Understanding the concept of present value can be one element in our financial decision making process. From evaluating loans and subscriptions to complex financial instruments like reverse mortgages, Excel’s PV function provides an accessible, effective tool for comparing future payments in today’s dollars. In this post, we’ll explore how to use the Excel PV function…
Read More
Understanding how to calculate interest rates is crucial for financial planning. Whether you’re determining the interest rate for a loan or projecting your investment growth, Excel’s RATE function is a powerful tool. In this post, we’ll explore how to use the RATE function to unlock hidden financial insights, covering loans, balloon payments, and investment goals.…
Read More
Managing finances effectively often requires understanding how long it will take to pay off a loan or reach a savings goal. Excel’s NPER function helps us determine the number of periods needed based on interest rate, payments, and loan amounts. Whether we’re looking at loans, mortgages, or investments, this function is crucial for financial planning.…
Read More
Ever wondered how much you need to save each month to reach a financial goal, like becoming a millionaire? The PMT function in Excel can help you calculate that with just a few simple inputs. While the PMT function is traditionally used to calculate loan payments, we can also use it to determine how much…
Read More
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…
Read More
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…
Read More
Today, we’re tackling an interesting challenge: How to add a fixed value to the first day of each month between a start and end date. We’ll explore three approaches, ranging from detailed to concise, so you can choose the one that best suits your needs. Video Step-by-step Tutorial The task is straightforward: We’ll walk through…
Read More
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…
Read More
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…
Read More