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

Check it out now

Excel Camera Tool

Learn About Excel Camera Tool Before Creating Your First Dashboard

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

Check it out now

Insert a Check Mark

Last week while traveling on a train, 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 […]

Check it out now

Refresh All Pivot Tables

refresh all pivot tables at once featured image

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’s a one-time setup.It saves a lot of time because once you create a pivot table, you just need to refresh it with a single click when […]

Check it out now

Thermometer Chart in Excel

featured image how to create 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 single point target. It’s easy to create […]

Check it out now
1 2 3 26