ExcelDemy.com Blog

0

How to Use Do While Loop in Excel VBA

We have already covered an introduction to looping and the simplest type of loops, namely the For…Next Loop and the For Each…Next Loop, in previous tutorials. We discovered that the For…Next Loop and the...

0

How to Use Sparklines in Excel

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in 2010 and later versions of Excel. Sparklines allow for visualization of data and one can use sparklines to showcase...

0

How to Use the DATEDIF Function in Excel

Performing operations and calculations involving dates requires that one acquires familiarity with some of Excel’s Date and Time Functions. The DATEDIF worksheet Function in Excel calculates the difference between two dates that are given...

Excel OR Function 0

How to Use the Excel OR Function

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...

2

Excel Security: Worksheet vs. Workbook Level Protection

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...

0

How to Use the HLOOKUP Function in Excel

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...

Excel XOR Function 0

How to Use XOR Function in Excel [With Example]

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...