Skip to main content

Posts

Showing posts with the label Dashboard

New Article

How to SUM by matching partial text in Excel

How to Create a Checklist in Excel

How to Create a Checklist in Excel Checklists in Excel: First of all I would like to say, Microsoft Excel is a powerful tool. Because, It is not just for numbers, but additionally for organizing your tasks. Due to you have to do many works in corporate office, you may need a tracker. To track your daily official task, you can simply create a Checklists in Excel with our simple and very easy tutorial. Yes you can use it for non-public and professional duties. So, I created a "To Do List" or "Checklist in Excel" to track my all corporate task. Due to many friends of mine unable to watch my YouTube video tutorial, hence I decided to share it with my blog. You can also watch my YouTube video tutorial and download the free excel templates. You can customize this checklist in Excel by way of selecting exceptional codecs, colorings, and layouts as you want. Image 1: ToDo list template tutorial in excel Step-by-Step Tutorial to Creating an easy Checklist in E...

What is Dashboard in Excel?

Assume that, you are a Flight Lt. of a fighter. You are on training. During the training you need to see how much fuel are available so that you can take a decision how much time you can fly more. But the problem is you have only 1/2 seconds time to check it. Because your eyes should always keep on the windshield glass to observe outside situation and follow the command. At this moment just look the Fuel meter for 0.80 seconds and you will know how much fuel are available and you have already taken the decision how much more time you will fly. This is the best example of a Dashboard. Image 1: Cockpit of F16 fighter What is Dashboard? In my opinion, Dashboard is a summary sheet of your details report, where Management looks for few seconds and can understand the overall situation of the current business. Sometimes, Management can change some options in a Dashboard and it shows the changed report instantly through graph, chart, attractive organizing of data etc. Below is m...