Hi Mynda,
I am currently on Lesson 3 of the course and I must say I am already loving it! I also have the Office 365 pro version of Excel. However, I wanted to check if you plan to add at least a couple of if not more comprehensive dashboards to the course? If yes, is there a timeline I can look forward to?
I am into Financial Planning & Analysis and would love to see a Dashboard built from the scratch that talks about the different KPIs' and provides the delta between Current Year (CY) Actuals vs Last Year (LY), AOP (Budget) and Forecast (FC). Within each of the cost KPIs' or Functional Areas like Sellex, R&D, G&A, etc, I would like to see the Cost Center details by cost elements like S&W, Travel, etc. I tried to search for such a dashboard but have not yet found a comprehensive Finance related dashboard online. I was hoping you can consider this request and come up with something as you have been part of the Finance domain. Will be really thankful.
Regards,
Rajiv
Hi Rajiv,
Great to hear you're enjoying the course. The challenge I have in creating new dashboards is getting sample data to use. If you have any I'd be grateful 🙂
Did you see my Plan v Actual dashboard here?
Mynda
Hi Mynda,
Thanks for your response. I did check out the video and it's amazing. I understand the Dashboard course has undergone an overhaul. However I did receive a notification there will be 3 sample dashboards. Hence my question, maybe I will find these once I make progress (pardon my ignorance). Will you be also overhauling the Dashboards created for the previous excel versions and film it in Excel 365 with some of the new functions/formulas?
Regarding the sample data for an FP&A dashboard, let me try to come up with something soon.
Btw best wishes on reaching 200k subscribers on your YT channel soon!
Thanks,
Rajiv
Hi Rajiv,
Thanks for your best wishes on YT. It's been amazing to have the support of so many people.
In the homework_completed_365.xlsx file there are three dashboards (Trend, Region and Product).
I don't plan to overhaul the dashboards from the old course at this stage.
Mynda
