![]() More details about tables are discussed in the Excel Essentials training, so check out one of those sessions if you have not already. Make sure that all the data is encompassed in your range, make sure My table has headers is checked, and press OK. In the ribbon, select Format as Table, and select any style.ģ. There are many data sources you can use for Power Query, but let’s start here for now.ġ. ![]() I have mentioned before that formatting your data as a table has many advantages, and here is another excellent example. Monthly, we are asked to create a pivot table of fees owed by class and area code, but this will be rough going, given how the data looks: Format as a Table The source has thrown lots of data into one column of a spreadsheet. The scenario is we have some ugly data that we have exported from a different source. Needless to say, this is all fictional data.If you haven’t, please come to my Excel Essentials and Excel Pivot Tables Sessions and learn about them! For this Byte I am assuming you have worked with Tables and Pivot Tables in Excel before. ![]() You will need the PC desktop version of Excel 2016, 365, or 2019 to use this feature.
0 Comments
Leave a Reply. |