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.

MIN

Last Date in Column

By Jeff Lenning | July 23, 2024 |

Hello and welcome to our latest tutorial! Today we’re diving into a common Excel challenge: finding the last date in a column. This is especially useful if you add rows to your data regularly. Let’s explore three different exercises to solve this problem. Video Tutorial Exercise 1: Using the TAKE Function in a Table Step-by-Step…

Read More
Person using a calculator while learning how to use Excel for finance

How to Use Excel for Finance: Balancing Your Personal Budget

By Excel University | June 7, 2022 |

Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.

Read More

Moving, Rolling, and Trailing Averages

By Jeff Lenning | March 19, 2015 |

The terms Moving, Rolling, and Trailing are commonly used to describe the same calculation idea…that we want to operate on the previous say 3, 6, or 12 data rows. In this post, we’ll allow the user to define the number of rows to include and use the OFFSET function to dynamically define the desired range. Objective…

Read More