Excel Camera Tool
While working in Excel, sometimes, you need to think out of the box. It happens to me sometimes when I share my dashboards and templates with other users and they made changes in it and all of my work break. Well, to solve this problem, I started to use live images of data tables instead of using […]
How to Quickly Insert a Check Mark Symbol in Excel
How to Quickly Insert a Check Mark Symbol in ExcelLast week while traveling, I met a person who asked me a smart question. He was quietly working on his laptop and suddenly asked me this:“Hey, do you know how to insert a check mark symbol in Excel?”And then I figured out that he had a list […]
Refresh All Pivot Tables
A pivot table is one of the best things that I have ever used. I love the thing that I don’t need to insert it again and again. It saves a lot of time because once you create a pivot table, you just need to refresh it with a single click when you update it and […]
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 […]