98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel dashboard
Excel dashboard
Resolved · High Priority · Version 2010
Wed 5 Apr 2017, 08:47Delegate Nicki said...
Nicki has attended:
Excel Dashboards for Business Intelligence course
Excel dashboard
Hi.
I have created a valid list based on month-year.
I would like that when any year is selected in the valid list, a total of 12 other cells display the 12 months from the selected month-year in the valid field.
I am not sure which is the best formula to use!
many thanks
Thu 6 Apr 2017, 11:15Trainer Jens said...
RE: Excel dashboard
Hi Nicki,
Thank you for the forum question.
Which formula is the best one to use depends on how your source data are organised.
I have created an example file (See attached file). I have the source data in a list and I have use the Sumproduct function. Please see how I have formatted the dates in column E and J.
I hope this can guide you in the right direction.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Dashboard.xlsxThu 6 Apr 2017, 14:30Delegate Nicki said...
RE: Excel dashboard
Thank you Jens but I cant see the attachment :-(
Thu 6 Apr 2017, 14:40Trainer Jens said...
RE: Excel dashboard
Hi Nicki,
Please try to refresh your browser (Press F5).
If it is still not visible please send me an email:
jens@stl-training.co.uk
Then I will send the file to your email address. You will not need to type anything in the email, I just need your email address.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 6 Apr 2017, 16:28Delegate Nicki said...
RE: Excel dashboard
thanks for the reply Jens. I havent explained myself too well, so I have created a file to try to explain...Is there a way I can upload the file as I cant see any attachment options..
Thu 6 Apr 2017, 16:33Trainer Jens said...
RE: Excel dashboard
Hi Nicki,
Please send the file to:
jens@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
