|
|
Secondly, we focus on the rock-solid PowerPivot data tool in Excel. It allows you to build PivotTables from huge amounts of data, in no time at all. And even more amazing: the data does not all need to come from the same source! You will learn how to merge an Excel list with an Access database without any problem at all. Or by using a table originating from an SQL server. Did you know that a normal Excel list is limited to 1,048,576 rows? PowerPivot manages to break down this barrier too. And not only that, this rock-solid tool has masses of new features that enable you to analyze table data even better.
|