Excel is great tool, with which one can create very efficient and simple solutions. The best part is that even if the solution created needs expert knowledge, the end result is very simple to use that anyone with very basic Excel knowledge can use it with ease.
Here is a simple Dynamic Dashboard of a multi-utility store. Main concepts used are – Charts, Formulas, Conditional Formatting. Check out how the charts change when a different year is selected.