Organize, manipulate and report on data using Excel's Power Pivot.
Competencies:
-
Use Excel's Power Pivot to organize, manipulate and report on data
-
Utilize functions, charts, PivotTables and slicers for large quantities of data, and display those elements in a dashboard format
We are living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data by using functions, charts, PivotTables, and slicers. Excel users can display those elements in a dashboard format.
Prerequisite: