Written by Puneet Gogia While working in Excel, sometimes, you need to think out of the box. It happens to me sometimes when I share my dashboards and templates with
Data Entry Form is one of the best ways to enter data in a table. But, creating a form to enter data it not a cup of cake. While struggling with this problem, I have found that you can create a form in Excel for data entry just with a single click.
For this, the best solution is to use a dynamic drop-down list in which you don’t need to update data source again and again.
There are a few things which I hate from my soul and a crashed Microsoft Excel is one of those things. Just think like this, you are working on an
Let say you need to create a data validation for dates in which you want to use a specific date range. In simple words, you want when a user enters a
People who track stock, sales, and purchases in Excel often ask me “how can we generate a barcode in Excel?”. Well, in Excel there is no default option to generate