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.
Let’s face it, Excel users probably insert the SUM function more often than any other function. As you know, we can improve our productivity by keeping our hands on our keyboards. This post discusses my favorite keyboard shortcut for inserting the SUM function. Keyboard Shortcut The SUM function is easily inserted into a workbook with…Read More
In this post, we’ll cover a handy technique for manually filling data labels down through an Excel range. This can also be referred to as repeating the labels, or, as flattening the data. Let’s get into it. Note: An alternative would be to use a Get & Transform query, as discussed in this post. Flattening…Read More
You know I love keyboard shortcuts. I believe that keeping your hands on your keyboard will improve your speed. I recently came across two very cool shortcuts I’d like to share in this post. Precedent First, let’s get a term cleared up. A Precedent is something that comes earlier, or before. In Excel, this idea…Read More
Have you ever called up the Go To dialog in Excel? There is a little button in it that enables you to go to special places in Excel. This post explores some of these special destinations. For starters, let’s call up the Go To dialog within an empty workbook. There are a few different ways…Read More
Did you know that Excel has two levels of hidden worksheets? Excel has “hidden” worksheets, and, “very hidden” worksheets. This post walks through the differences, and how to hide worksheets at each level. By default, all new worksheets are visible. A visible worksheet’s tab appears in the bottom of the Excel window, enabling the user…Read More