Top Ten New Features in Excel 2013
4 of 10
Integrated Data Model support
Excel 2013 now supports true one-to-one and one-to-many relations between the data tables that you import into Excel from stand-alone database management programs as well as between the data lists that you create in Excel. The relationships between the data tables and lists in the Data Model then enable you to use data from any of their columns in the Excel pivot tables and charts you create.