Explore Excel Deeply
Conditional formatting allows one to visually highlight or visually emphasize certain values in one’s dataset, based on the fulfilment of a certain criteria. It can be time consuming to go through large data sets...
The Do Until Loop Structure is utilized, when one has a set of statements or actions to be repeated and repetition occurs until the condition evaluates to true, in other words, while the condition...
Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified input text string. This text string could be entered...
Often when writing VBA code, one may need to repeat the same action or series of actions more than a couple of times. One could, in this case, write each action over and over...
Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides relational database capability in a compact desktop environment. Fewer people use Access, even...
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...
