The Best 8 Tips to Filter Data in Excel Like a PRO
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 up to the best……or maybe they forget to make a habit to use it. But the good news is you can be one of those users […]
How to Get QUARTER from a Date in Excel
In Excel, there is no direct function to get quarter from a date. But you can create a formula for this. Yes, you can use a formula for the quarter calculation from a date.Even there is more than one method which you can use. Alright, as you know there are total four quarters in a year but the […]
How to Create Interactive Charts In Excel
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 comes to charting it should be neat and clean and the best solution to this problem is using interactive charts. By using interactive charts in Excel, […]
How to Calculate SQUARE ROOT in Excel + Insert Symbol
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 an example of SQUARE ROOT.A square root is a quite common calculation which we do in our day to day work, and in Excel, you […]
How to Create a SPEEDOMETER Chart [Gauge] in Excel
When it comes to present data in an understandable way in Excel, charts standout there. And there are few charts which are specific and can be used to present a specific kind of data. A SPEEDOMETER [Gauge] is one of those charts.It’s a kind of thing which you can find in your day to day life [Just […]