Once you have exported data (step 4) you will use Excel. The steps below assume you have basic Excel skills, including opening and saving files.
If you already had access to a training data report before following these instructions, please check your Power BI window to identify which report you are using. These instructions are for the Compliance General report.
Prepare the Excel sheet so it is ready to work with
- Select Downloads to open the Excel Spreadsheet or navigate to where you saved it and open it.
- To ensure the column titles remain visible, 'freeze' the top row of data.
- Select cell B2.
- Go to the View tab on the ribbon.
- Select Freeze Panes and then select Freeze Panes from the dropdown.
