Overview of Power Pivot for Microsoft Excel
Course Duration: 90 Minutes
Target Audience:
Aimed at experienced Microsoft Excel users who need to merge, analyse and visualise large datasets from various different sources.
Course Objectives:
This session aimed at experienced Microsoft Excel users who need to merge, analyse, and visualise large datasets from various different sources. To demonstrate the capability of Power Pivot in Microsoft Excel; to import data into a Power Pivot and create relationships; to generate Power Pivot tables and charts; to customise Power Pivot table and Power Pivot chart.
Course Outline:
Course Introduction
Why Use Power Pivot for Microsoft Excel?
-
Using Power Pivot Workbooks
-
Choosing Data Sources and Relationships
Importing Data and Running a Query
-
Using the Table Import Wizard
-
Importing and Filtering from Databases
-
Running an SQL query
-
Getting Data from Files
-
Copying and Pasting Data
-
Creating Linked Tables
Creating Relationships
-
Understanding Relationships
-
Reviewing Existing Relationships
-
Creating New Relationships
Using Power Pivot Charts
-
Creating a Power Pivot Chart
-
Choosing a Power Pivot Chart Layout
-
Changing the Chart Type
-
Formatting the Chart
-
Adding, Removing, and Changing Chart Elements