Forum

Notifications
Clear all

Dashboard Entry

4 Posts
2 Users
0 Reactions
66 Views
(@scollops)
Posts: 15
Eminent Member
Topic starter
 

We have a dashboard for displaying end results, but can you use a dashboard to collect data, make a very boring spreadsheet with 300+ questions to something more appealing ? 

 
Posted : 10/11/2019 1:56 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Mike,

It's difficult to picture what your workbook currently looks like and what you have in mind. Yes, I'm sure you could make it more appealing with various Excel tools. Sorry I'm not more help. It's difficult to say more without a specific question.

Alternatively, you could use Excel survey (requires OneDrive for Business) to collect your data, which you then report on in a dashboard.

Mynda

 
Posted : 10/11/2019 2:59 am
(@scollops)
Posts: 15
Eminent Member
Topic starter
 

That's ok....just started your dashboard course, had me thinking.  If I am displaying my data from a sheet, could I actually create a front end to actually get data.   If you can recall the Cyber assessment I sent recently lots of questions.  Something around that.

 
Posted : 10/11/2019 3:04 am
(@mynda)
Posts: 4761
Member Admin
 

An alternative to Excel Survey is to build a User Form with VBA that will take the user through the questions and deposit the answers in a table that you can then report on. The downside of both of these options is that the user needs to answer each question before moving on. From memory, your questions are quite complex and having them in a table in the worksheet allows the user to answer them out of sequence. I imagine this is something that typically happens, but could be wrong.

 
Posted : 10/11/2019 8:22 pm
Share: