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.
ROWS
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
I recently received a question: “I have two columns of numbers and want one cell at the top to tell me if any values in column A exist in column B.” In this blog post, we’ll walk through how to accomplish this using some essential Excel functions. Video Objective The question asked how to write…
Read More
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
Despite the many ways you can shuffle rows, columns, and cells, there’s no built-in option to random sort in Excel. That can be useful for randomly assigning tasks or responsibilities, selecting samples, and much more. Instead, you can write a formula that allows you to randomly sort any data you select. Video How to Random…
Read More
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