by Ilker | Aug 1, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 30, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 19, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 19, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 18, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 18, 2019 | Excel Tips & Tricks
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...
by Ilker | Jul 16, 2019 | Excel Formulas, Excel Tips & Tricks
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...
by Ilker | Jul 16, 2019 | Excel Formulas, Excel Tips & Tricks
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...
by Ilker | Jul 11, 2019 | Excel Formulas, Excel Tips & Tricks
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...