Can you take a look and highlight the steps / areas that I am missing do to my lack of understanding / knowledge?
Base on the information that I have learned, I am attempting to create my own dashboard. The data was generated by data generator on the Internet.
I have attached the original csv file (ExportTraining.csv) and the xlsx file (DashboardTraining.xlsx).
I have included notes within the workbook for what I think I am trying to accomplish. I am stuck on many things and maybe you can help lead me along. I do not know where my knowledge is lacking, but it is lacking enough that I get to a certain step and cannot get past it. I am running and going nowhere.
Basically, The workbook is to track the training of staff. There are two modules to the training. To have completed the training, the staff has to complete both modules to get credit. I have attempted to create sheets, charts, pivot tables, etc. of what I think I would like to track.
Hi Troy,
I have answered your questions in the attached file, but I think a lot of the struggles you're having are because you haven't finished the courses. I say this because a lot of the questions you're asking are answered in the courses, plus you only joined the 3 courses 2 weeks ago and that's a lot of training to complete and practice in that time.
I think the reason you are running and going no where is because you're trying to run before you can walk 😉 There are no shortcuts, the best way to get these skills is to complete the courses, practice as you go and only then try to implement the techniques in your own work.
Mynda
Thank you Mynda for your patience.
I have been going through the material fast. I have watched some of the videos multiple times. Please believe me, I watch your videos during meetings, Birthday Parties, while I eat and put my kids to bed at night. LOL!!!
I will go through the courses again and try to slow down.
Should this be the order that I watch the videos?
- Power Query
- Power Pivot
- Dashboards
Yes, that's the order you should complete the courses in.
It sounds like the key piece you're missing is the 'practice' part. If you're just watching them and not practicing and replicating the examples I'm showing you then it's just Excel Entertainment that largely goes in one ear and out the other 🙂
Mynda
