Top 30 Microsoft Excel Interview Questions

Interviews are challenging. Job interviews that require any sort of tracking data or simple calculations are even trickier, as this would require a kn...

Advanced Conditional Formatting Tricks in Excel

In this article, we will learn Advanced Conditional Formatting Tricks in Excel. Scenario: Microsoft Excel is having so many unbelievable cap...

Restrict Dates using Data Validation

In this article, we will learn How to validate date entries which contain specific year, specific month or specific date using data validation in ...

How to Get the Path of Current Worksheet in Excel

In this article, we will learn How to Get the Path of Current Worksheet in Excel.   CELL function in Excel Cell function in Excel ge...

How to Create Dynamic Data Validation Dropdown List in Excel

In this article we will learn how to create dynamic list? In Excel, we can limit the user to input values in a cell to a drop down list, using Data V...

How to Freeze Panes in Microsoft Excel

In this article, we will learn How to Freeze Panes in Microsoft Excel. Freeze panes: - We use this option to freeze a portion of sheet to keep ...

Delete Blank Rows in Microsoft Excel

In this article, we will learn how we can delete blank rows or rows that contain blank rows in Microsoft Excel 2010. Go To Special: - This option i...

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.