Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

All posts by Puneet

Insert/Type Degree Symbol in Excel

Yesterday I was working on some temperature data for weather forecast with one of my friends.For this, one of the important things was to use degree symbol in data to show numbers in Celsius and Fahrenheit.If you use a laptop like me, you’ll find that there is no key to type a degree symbol.While working […]

➲ Continue Reading

Best 8 Tips to Filter Data in Excel

Using a filter in Excel is not a #rocketscience. Everyone knows that they can do a lot of things with filter option.But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it.And, the good news is you can be one of […]

➲ Continue Reading

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading