You will be taken to the Power Query Editor. (note: you can also access this from the Get Data dropdown if it is not readily visible)Ģ. Go to the Data tab, and in the Get & Transform Data group, select From Table/Range. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |