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.
The Data Validation feature allows you to control what a user can type into a cell. This post digs into the details of the data validation alert style options. Data Validation Primer First, a quick overview of the Data Validation feature. Data Validation has been in Excel for a long time, and it is one of…Read More
This post explores Excel’s lookup functions, approximate matches, fuzzy lookups, and exact matches. The built-in Excel lookup functions, such as VLOOKUP, are amazing. When implemented in the right way for special projects or in recurring use workbooks, they are able to save a ton of time. The VLOOKUP function alone has saved countless hours in…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
Often, we use Excel to summarize detail that comes from some other program or accounting system. There are essentially three ways that I am aware of to get data from another program into a destination Excel worksheet, I’ll nickname them: Copy/Paste Pull Push Copy/Paste The Copy/Paste method is probably the most common. It is when…Read More
I am excited to announce the launch of Excel University Interactive! Up until now, the Excel U content was delivered only through a book format (both paperback and digital). Starting now, the content is officially available as an online interactive group study format as well. This course is the result of a project I started…Read More
The SUMIFS function is for sure, without a doubt, one of my most favorite Excel functions of all time. I’m sure I use it in well over half of my workbooks, and it is a must-know function for Excel users. I’ll try to get you warmed up, but just know that this post only gets…Read More