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.
SEQUENCE
Do you use Excel to keep track of your to-do lists, upcoming events, deadlines, etc.? Since spreadsheets are so customizable, many Excel users rely on the software to create unique calendars tailored to their needs. It’s one of the most popular uses for Excel and great practice for users of all skill levels. If you’re…
Read More
Formulas are what make Excel, Excel. They’re how we perform both simple and complex calculations, and the possibilities are nearly endless as far as what they can do. Today, we’re going back to the basics with an overview of what formulas are and how to use them, as well as sharing our Excel formulas tutorial…
Read More
In this post, we’ll create a list of months with a single Excel formula. To make it more interesting, we’ll allow the user to enter the desired number of months to display and create additional formulas to show the last day of each month, the number of days in the each month, the month number,…
Read More
In this post, we’ll see how to create an Excel calendar with a single formula. Specifically, we will write a formula that displays the days of any month in a graphical calendar format. Our graphical calendar displays the days of the specified month in 7 columns (Sunday through Saturday) and includes a row for each…
Read More
Let’s say you need to take an amount and split it evenly into monthly columns. For example, perhaps you need to recognize revenue over time. Or, perhaps you have spent some money and you need to allocate the expense over time. There are other illustrations, but the basic idea is that you have a total…
Read More
The past several posts have illustrated various ways to apply dynamic array formulas and their spill ranges. Kent asked if we could use spill ranges to create a dynamic chart to visualize the future value of an investment portfolio. For example, start with someone’s current portfolio value and then apply an assumed growth rate and…
Read More