Using a filter in Excel is not a #ROCKETSCIENCE. Everyone knows that they can do a lot of things with filter option. The bad news is they are not actually using it
In Excel, there is no direct function to get a quarter from a date. But you can create a formula for this. Yes… …you can use a formula to calculate a quarter from
I can’t calculate that how many hours I have saved… …since I have discovered “Format Painter”. Yes, that’s right. And you can too.The thing is: While working in Excel, it happens sometimes that you
A chart is a perfect tool to present data in an understandable way. But sometimes it sucks because we overload it with data. Yes, you heard it right.I believe that when it
Excel is like a Swiss army knife for calculations. From mathematical to financial, it’s for every single thing you need to calculate. You can calculate simple to most complex things in Excel.Take
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.