Section outline


    • Task 2: Video Guide

      Your trainer will outline the key aspects of this practical task in the videos below. Further down the page you will find the accompanying briefing notes (PDF document) with instructions and screenshots for the task. 

      Video 1:

      • Transposing data
      • Correcting rows, columns and headers

      Video 2:

      • Combining data from multiple worksheets into one (Excel Power Query, Append function)


    • Practical Task 2: Guidance Note

      You can view the guidance note on screen, or download the PDF and view locally.