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

Using INDEX and MATCH

Every Excel user who loves VLOOKUP has this secret pain inside: You can’t use it for advanced lookups.Yes, it’s a pain.No doubt, VLOOKUP is one the most popular lookup functions and you should learn it. But, when it comes to power and flexibility it has some shortfalls (as I mentioned) which you can’t cover up […]

Check it out now
1 3 4 5 6 7 27