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

Man making notes on a large calendar underneath an open laptop

Top 5 Excel Calendar Tutorials & Free Templates

By Excel University | June 28, 2022 |

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
Text that says "Excel Formulas Tutorial: What are Formulas and How to Use Them" over a man stacking blocks

Excel Formulas Tutorial: What are Formulas and How to Use Them

By Excel University | April 19, 2022 |

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

Excel Month List

By Jeff Lenning | November 2, 2021 |

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

Excel Calendar with One Formula

By Jeff Lenning | October 20, 2021 |

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

Split Amount into Monthly Columns

By Jeff Lenning | May 12, 2020 |

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

Charting a Spill Range

By Jeff Lenning | March 19, 2019 |

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