Power Pivot for Microsoft Excel
Power Pivot for Microsoft Excel Course Duration: Half Day
Target Audience:
Aimed at experienced Microsoft Excel users who need to merge, analyse and visualise large datasets from various different sources.
Course Objectives:
To demonstrate the capability of Power Pivot for Microsoft Excel; to import data into a Power Pivot and create relationships; to generate Power Pivot tables and charts; to customise Power Pivot tables and Power Pivot charts.
Course Outline:
Course Introduction
Why Use Power Pivot for Microsoft Excel
-
Power Pivot Workbooks
-
Data Sources
-
Relationships
Importing Data
-
Using the Table Import Wizard
-
Importing and Filtering Data 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
Building DAX Formulas
-
DAX Formula Basics
-
Using Calculated Fields and Measures
Creating Power Pivot Tables
-
Setting up a Power Pivot Table
-
Updating the Table
-
Changing the Table Structure
-
Formatting the Table
Using Power Pivot Charts
-
Creating a Power Pivot Chart
-
Modifying the Chart Layout
-
Changing the Chart Type
-
Formatting the Chart
Creating Slicers
-
Adding Slicers to Power Pivot Tables and Charts
-
Setting the Slicer Options
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.