Explore Excel Deeply
Excel provides functions to calculate the largest or maximum value in a range and also functions to calculate the smallest or minimum value in a range. The first function we are going to look...
We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how to use the IF statement in...
One can implement conditional logic in VBA using an IF statement, multiple IF-Elseif statements or one can use the Select Case statement in order to implement conditional logic. In the case where one has...
The OR Function is a logical Function, that evaluates two or more conditions and returns true if at least one of the conditions is true. If all of the conditions are found to be...
It is often necessary to protect either the sensitive information in one’s actual worksheet or the workbook structure, from being edited. Excel provides different options for protecting and securing one’s data and we are...
We have already seen how to utilize the VLOOKUP Function in a previous tutorial. We are now going to see how to use the HLOOKUP Function. HLOOKUP stands for horizontal lookup and is used...
The XOR Function is a logical function that was introduced in Excel 2013 and later versions. The XOR Function if used with two conditions and one of the conditions evaluates to true, then the...
The CEILING.MATH Function is a new function that was introduced in Excel 2013 and later versions. The CEILING.MATH Function rounds a specified number up to the nearest integer or nearest specified multiple of significance....
Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are namely the ROUND Function, the ROUNDUP Function, the ROUNDDOWN Function, the MROUND Function and the CEILING Function. The ROUND...
Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D...
This is an interesting situation that often comes up. Namely, sometimes one needs to match data in two different columns or different sheets. So, let’s get started with a simple example, to illustrate how...
Advanced Excel / Formulas / Functions
by Taryn N · Published July 13, 2017 · Last modified September 16, 2017
The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April...
Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Well, look no further, since we will show you how to do just...
We have already covered how to format Excel Tables extensively in a previous tutorial. We are now going to look at using Table Nomenclature or structured Table references in formulas. Using structured Table References...
Most of us are familiar with standard Excel chart types such as a pie chart, a column chart, and a line chart, as well as the types of data they are used to showcase...
The Accounting Format is similar to the Currency format and can be applied to numbers where needed. The difference between the Accounting format and the Currency format is that the Accounting format puts the...
