Pivot Table Using Multiple Files

A pivot table is one of the best ways to summarize data. You can create a summary report within seconds from thousands of rows of data.It’s a perfect tool.But while working with data in the real world not everything is perfect. And today, I want to share with you a common problem which we all […]

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

Insert a Check Mark

Last 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 of customers and wanted to add a check […]

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

1 7 8 9 10 11 28