USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
filter data.
|
|
|
sort data.
|
|
|
use aggregate functions.
|
|
|
use data in multiple related tables.
|
Detailed explanation-1: -The normal pivot version just lists fields within this single table or source that we’re pointing to. Power Pivot allows us to access any of the fields in any of the tables in our data model, and then analyze them based on any relationships that we’ve defined. So that’s the most obvious of the differences.
Detailed explanation-2: -Power Pivot is an Excel add-in you can use 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.
Detailed explanation-3: -You can use a PivotTable to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends.
Detailed explanation-4: -Power Pivot allows you to create relationships between tables with a simple drag-and-drop. This means there is NO formula to maintain here, and it is much faster and easier to build relationships between your tables. In the screencast above, I am basically doing the same thing as creating a VLOOKUP formula.