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.
Excel
Mastering 5 Key Financial Functions: PMT, PV, FV, NPER, RATE Whether we’re planning to buy a car, save for retirement, or pay off a loan, numbers play a central role in our financial journey. Excel gives us powerful tools to analyze and plan financial scenarios. In this post, we’ll walk through five key Excel financial…
Read More
When it comes to evaluating investments in Excel, most people immediately jump to the familiar NPV and IRR functions. While these are incredibly powerful, they can lead to incorrect conclusions if we don’t fully understand how they work, especially when cash flows vary or are irregular. In this post, we’ll walk through six powerful finance…
Read More
I’m thrilled to introduce this year’s Excel University Scholarship recipients! These awards are made possible by the generous support of the Excel University Alumni Association. Thank you to everyone who has contributed to make this program a reality for the past 10 years. This was a very competitive scholarship year with many applicants! Thanks to…
Read More
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,…
Read More
When it comes to evaluating the performance of investment opportunities in Excel, many of us start with the IRR (Internal Rate of Return) function. While helpful, it carries assumptions that don’t always fit real-world situations … especially when financing costs or different reinvestment options are involved. That’s where MIRR (Modified Internal Rate of Return) becomes…
Read More
If we need to calculate the internal rate of return (IRR) for a series of cash flows occurring on irregular dates, the standard IRR function in Excel falls short. That’s where XIRR steps in. The XIRR function allows us to incorporate actual dates for each cash flow, offering a more precise and reliable result which…
Read More
When evaluating where to invest our money, whether it’s in education, a new business, or a CD, understanding the rate of return is essential. Thankfully, Excel makes this process straightforward with the IRR function, or Internal Rate of Return. This function helps us calculate the annualized rate our cash flows will earn over time. In…
Read More
When assessing whether an investment is financially worthwhile, smart investors don’t guess … they measure. Excel has multiple functions that can measure an investment’s net present value. Excel’s classic net present value function, NPV, assumes cash flows occur at regular intervals. But what do we do when the cash flow timing is irregular? That’s where…
Read More
Welcome! In today’s post, we’ll walk through the concept of Net Present Value (NPV) and how to calculate it accurately in Excel. If you’ve ever wondered how to measure whether an investment is worth it, NPV is one of the most practical tools you can use. But, as with many financial functions, there’s a catch.…
Read More
Understanding interest rates is key to accurate financial modeling in Excel. In this guide, we’ll explore the NOMINAL function, which helps us convert an effective rate (APY) into a nominal rate (APR). Once we make this conversion, we can generate more precise projections using Excel’s other financial functions like FV (Future Value) and PMT (Payment).…
Read More