How to Create a Thermometer Chart in Excel
It happens sometimes when we need to track a single point target vs. its achievement.And for this, it’s important to have a specific chart which can help you to present your data in an understandable way.I believe that thermometer chart is one of the best charts for a single point target. It’s easy to create […]
VLOOKUP with Multiple Criteria
VLOOKUP is one of the most popular Excel Functions. But, it’s one of the most limited functions as well. Advanced Excel users know that there are so many things which we can’t do with VLOOKUP or they need to put some extra efforts to make it work. For example, using VLOOKUP with multiple criteria. By default, VLOOKUP allows […]
Excel’s AUTO FORMAT Option
Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]
Top 31 Pivot Table Tips & Tricks for Advanced Excel Users
No doubt, Pivot Tables are the single most important tool which can help you to become an advanced Excel user. When it comes to data analysis, quick and effective reporting or presenting summarized data nothing can beat a Pivot Table. The best thing about pivot tables is they are powerful and flexible. Even when you compare formulas and […]
How to Concatenate a Range of Cells in Excel [5 Methods]
CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine. It’s simple and easy to apply. But here is a bad news. In concatenate, it’s not possible to refer to an entire range. You need to select all the cells of a range one by one. […]