How to Use Excel EDATE Function
Excel provides a wide variety of functions to handle date calculations. We have already looked at some of these functions in previous tutorials. The EDATE function is utilized, when one wants to add ...
READ MORE +Latest Posts
Top 10 ExcelDemy Blogs of 2017
2017 was a great year for Excel and Excellers (those of us who love using Excel for work or study purposes and can’t wait to learn more about this wonderful piece of software) - alike.Excel ...
READ MORE +How to Use the For Each Next Loop in Excel VBA
We have already covered an introduction to looping and the simplest type of loop, the For…Next Loop in a previous tutorial. Let’s just remind ourselves of what a loop is: its code that handles ...
READ MORE +How to Use the 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 ...
READ MORE +How to Use Sparklines in Excel [With a Snail Farming Example]
![How to Use Sparklines in Excel [With a Snail Farming Example]](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/Picture2-1tgrnjiw2b8ay9j8r3abw318j0htz3nccqut4rprxozo.png)
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 ...
READ MORE +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 ...
READ MORE +Basic Conditional Formatting in Excel and Access
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 ...
READ MORE +How to Use Do Until Loop in Excel VBA
The Do Until Loop in Excel VBA 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 ...
READ MORE +Changing Case using Worksheet Functions and Excel VBA
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 ...
READ MORE +For Next Loop in VBA Excel (How to Step and Exit Loop)
In this article, I shall discuss at first how to use For Next Loop in Excel VBA. Then I will elaborate the discussion on how to exit a For Loop when some condition is there and then you will learn ...
READ MORE +Exchange (Copy, Import, Export) Data Between Excel and Access
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 ...
READ MORE +MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel
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 at ...
READ MORE +IF & AND Functions in Excel VBA to Test Multiple Conditions
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 conjunction with the ...
READ MORE +How to Use the Select Case Structure in Excel VBA
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 ...
READ MORE +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 false, then the OR ...
READ MORE +About ExcelDemy.com
ExcelDemy is a place where you can learn Excel, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide Excel solutions to your business problems.
ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon.
