Home

Excel 2016 practice spread sheets

DDuarte_62
New Contributor

Where can I download free 2016 practice spread sheets? I would like to practice Pivot tables and v-lookups.

4 Replies

I guess that's a File->New

image.png

Thank you Sergei,

I was hoping to find some spreadsheets with data already in them for me to then create my own pivot tables and v look ups.

Hi,

 

Please see the below YouTube playlists which have many training videos related to the PivotTables and VLOOKUP.

 

Each video has a start and finished file, and you can download them from the link below the video.

 

VLOOKUP:

https://www.youtube.com/watch?v=LdhLAa-Vqmg&list=PLE9C01909A6A5A14B

 

PivotTables:

https://www.youtube.com/watch?v=Y2cIAIJAEWA&list=PLDF4390866B480CD2

 

Hope that helps

These are tutorials with data within it and samples explained