Instead of putting data on a worksheet, Power Pivot lets you enter it straight into a data model. Additionally, you can link tables together. Say goodbye to the Vlookup function, which combines data into one large table.