Use Data Entry Form in Excel

A data entry form is the best way to enter data in a table. But sometimes it’s time consuming to create a form.While struggling with this problem, I have found there is a default form in Excel which you can use for data entry.The best part about this form is it’s pre-designed and flexible in […]

VBA Code to Search on Google

There are a lot of important things which we all do other than using Excel.Am I right?One of those things is using Google to search for something.In my list of useful macro codes, I have a code which you can use to perform a search query on Google using Chrome.And today, I’m gonna share that […]

Count Words in Excel [Cell + Range + Worksheet]

There is one option which I always wish Excel should have.That’s ==> Count Number of Words.If you work in Microsoft Word, there is an inbuilt option on the status bar which shows you how many words are there in the sheet.But, when it comes to Excel there is no such option to count words. You can […]

Add Vertical Line in a Chart

Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there.And, the best way for this is to add a vertical line to a chart.Yes, you heard it right.You can highlight a specific point on a chart with a vertical line. Just look at the below […]

Dynamic Drop Down List

A drop down list is a powerful tool.It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data.While using it, one thing always gave me nuts that you need to update its data source whenever you add a new […]

1 3 4 5 6 7 28