Drilled down financial dashboard developed in Excel without any use of VBA or macros. One can drill down from overview to expense/income type and then further in each category. Watch the video for more details.
Category: Excel
Strategic hospital dashboard
An overview dashboard about various hospitals with detailed view on each of outpatient, inpatient, critical care and emergency departments. Developed without any use of VBA or macros. Check the video for detail.
Home expense/income record
A simple easy way to enter daily records of home expenses and incomes.
- Easy to use
- Set categories in first sheet of January and you are set for all months
- Get monthly trends of all categories
- Get annual overview
- Possible to record borrowings and lending
- Set months based on the year.
