Top 30 Microsoft Excel Interview Questions

Q11. Is it possible to make Pivot Table using multiple sources of data? How? Answer: Yes, this is possible by using data modelling technique. St...

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

Conditional Formatting E-book

11IncredibleExcel Conditional Formatting Tricks or Read it online ...

Restrict Dates using Data Validation

How to Restrict Dates using Data Validation in Excel? If you want to prevent user from entering dates of their choice in specific cells, then this ...

Get the Path of Current Worksheet

How to Get the Path of Current Worksheet In Excel? In case you need a smart way to get the path of the current Excel workbook without VBA, then thi...

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

Freeze Panes in Microsoft Excel

In this article, we will learn from where we can insert Freeze panes and what is the use of it in Microsoft Excel? Freeze panes: - We use this opti...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube