The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don’t show in printed documents. If you want to print them anyways, Excel has an option which allows including row...
The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on...
Excel comparison operators can compare two values and return a logical (Boolean) value. You can use the return logical value in other functions like IF, or features, like Conditional Formatting, that require a logical value input. In this guide, we are going to show...
Using the current time and/or date in Excel can help keep track of activities or add timestamps to your work easily. In Excel, there are a few ways for inserting the current date and time in a cell. In this article, we are going to show you how to insert Excel...
Finding the number of work hours between two dates can be a little more challenging due to the fact that you must also consider holidays and weekends. After finding the number of business days, you can easily multiply this number by daily work hours (i.e. 8 hours) to...
Reference types can be used in Excel to determine how Excel will treat a specific target reference. By default, all references are relative references, and this means that all subsequent actions will be relative to the position of that reference. To switch into an...
A popular use case for the IF function is creating nested formulas that can check for various criteria. However, nested IF statements can get pretty complicated and cumbersome when dealing with several conditions. In this article, we’re going to show you how to use...
Lookup functions are widely used in Excel models. However, one of the most popular lookup functions, VLOOKUP, can only search the left-most column in the search area. This function will fall short if you need to search in the middle of a table and return values from...
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...
