Forum Discussion

DDuarte_62's avatar
DDuarte_62
Copper Contributor
Nov 20, 2018

Excel 2016 practice spread sheets

Where can I download free 2016 practice spread sheets? I would like to practice Pivot tables and v-lookups.
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 20, 2018

I guess that's a File->New

DDuarte_62's avatar
DDuarte_62
Copper Contributor
Nov 20, 2018

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 20, 2018

    These are tutorials with data within it and samples explained

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 20, 2018

    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