One of the limitations of PivotTables has been the fact that you could only use information from one data table, requiring any additional information to be added into the table in order to be included in the PivotTable. Here’s the original Excel file to start with, and here’s the completed version. You can download the example workbook to follow along (but it requires Microsoft 2013). With Excel 2013, Microsoft has introduced many new PivotTable features, including the new Excel Data Model which takes PivotTables to a whole new level! Well, Microsoft has made a lot of strides over the years to introduce new functionality and options to make PivotTables easier and more intuitive to use. Yet there are still many Excel users who, for one reason or another, find themselves avoiding PivotTables.
PivotTables have certainly become one of the most powerful ways to quickly and easily transform data into information.
0 kommentar(er)
