Evaluate Day Of The Week Using Format Cells In Microsoft Excel

Let's say you want to see the date to be displayed when you enter a date value in a cell as "Tuesday" instead of the actual date of January 27, 2014. ...

Custom Error Messages in Data Validation in Microsoft Excel 2010

Consider while creating a pre-set field for other users which will be helpful when entering the value that you have already set where you do not want ...

Cascading Drop Down List Using Conditional Formatting in Microsoft Excel

In this article, we will learn about how to create cascading drop down list using conditional formatting. To create the cascading drop down list we wi...

Automatic Spell Checker in Microsoft Excel 2010

If you are wondering how you can make Excel to spell check the data (typing error), in this article, you will learn how to automatic spell check in...

Ignoring Blank Cells When Performing Calculations In Microsoft Excel 2010

In this article, we will learn ignoring blank cells when performing calculations in Microsoft Excel 2010. Consider a scenario in which you have two...

Find if a character is in a range and cell in Microsoft Excel

In this article, we will learn Find if a character is in a range and cell in Microsoft Excel. Scenario: In simple words, while working with ...

How to Make a Pie Chart in Microsoft Excel 2010

In this article, we will learn how we can prepare a Pie chart in Microsoft Excel 2010. Pie Chart: - This chart is used to show the proportion of th...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.