This last step is optional, but it is recommended as a way to reduce confusion in the future. This procedure will allow you to convert your flat data into a standard Excel table, as shown in Figure B. Make sure the box that indicates your data has column headers is checked. Or, if you prefer, you can click the Format As Table icon in the Ribbon of the Home Tab. The easiest way to do this is by highlighting the data in your workbook and pressing Ctrl + T. The next step is to convert your flat data into the standard Excel table format. If you have a workbook you want to link to Power BI with those kinds of analysis already embedded, you will have to deconstruct it until you get down to a pristine list of flat data. In general, an Excel workbook like this one would have conditional formatting, summed columns, and so on.