Modern Data Analysis -Get & Transform and Power Pivot
With Get & Transform and Power Pivot in Excel, you’ll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how. Whether it’s small data sets or large ones with up to millions of rows, you can connect, clean, analyse, and share your data faster.
Power Pivot allows you to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. You can use the Data Model and a collection of tables to create relationships stored as part of the workbook. The Data Model integrates deeply with other features in Excel, such as tables and PivotTables, to provide a seamless analytics experience.
Like this? Wanna see more bite-size learning?
We have lots of different bite-size learning sessions on offer. To read more about them, click the button below.