Executive Review Dashboard in Excel [Dashboard Week]
Purpose of the dashboard:
This is a guest article written by John for our Excel Dashboard Week.
This Dashboard was constructed for a number of reasons, one of which was to reduce the number of reports produced with the same data ( up to 6 separate files ). As we all know, when it comes to senior management and reports / files the more information they can get on one report / file the better for them. So, with this in mind I created the Dashboard to show the data they need to see “quickly” each week.
Health-care Dashboard in Excel [Dashboard Week]
As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto. He put together an excellent dashboard to visualize hospital performance and understand what is going on. Read this post to understand how this dashboard is made, watch a tutorial video & download example workbook.
Thank you Alberto for sharing the file & helping us learn.
Calculating Sum of Digits in a Number using Array Formulas [for fun]
Here is a fun formula to write.
Given a number in cell, I want you to find the sum of digits in it. So, for eg. if you have the number 3584398594 in a cell, the sum would be =3+5+8+4+3+9+8+5+9+4, equal to 58.
Now, how would you write a formula to find this sum automatically based on the number entered in the cell?
Go ahead and figure it out. If you can, come back and check your answer with mine below.
Find the Average of Closest 2 Numbers out of 3 [formula challenge]
Today I am asking you a tricky formula question. This is asked by Ionel on the Introduction to VLOOKUP, OFFSET & MATCH Formulas post. The question is, I have data in three columns: A,B,C and I want to get the average of the closest two values out of three in each row. Could you help […]
Happy Birthday Hui, An Excel Dashboard to prove you are awesome!
Some of you know our guest author and Excel ninja Hui. Yesterday was his birthday. And I wanted to create nice birthday gift for him. So I took a database dump of our forums data and created a dashboard.
Read rest of this post to see the dashboard & download workbook.
2011 Calendar – Excel Template [Downloads]
Here is a 2011 new year gift to all our readers – a free 2011 calendar template.
(a little secret: just change the year in worksheet “Full” from 2011 to 2012 to get the next year’s calendar. It works all the way up to year 9999)
You can add notes to individual dates or complete month using the excel template very easily. There are 6 different calendar templates in the download file,
* 4 Yearly Calendar Templates with different color schemes.
* 1 Mini Calendar
* 1 Monthly Calendar (prints in 12 pages)
Go ahead and download the calendar files. Enjoy.
Highlighting Data Points in Scatter and Line Charts
Introducing a method of allowing data points to be interactively highlighted in Excel Scatter / X-Y Charts and Line Charts.
You will see a lot of these style charts in various places where you want to highlight various aspects of the chart to your audience. It is a great technique for complex scientific and engineering charts where you may have hundreds or thousands of points.