Pivot tables and drop down options

Hi Sharon,

Thank you for the forum question.

Pivot Tables are very useful to analyse data and to create reports.

I found a very good video on YouTube, which go through the basics.

https://www.youtube.com/watch?v=m0wI61ahfLc& ;t=45s

I believe that you talk about data validation when you ask for drop down options.

Please watch the video below:

https://www.youtube.com/watch?v=QR04owFaJy4

We have Pivot Tables and create drop down option on our Excel Advanced course


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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