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