Power Tool in Excel Corporate Training Course Outline

1. Power Pivot

Power Pivot Overview

What is a PowerPivot?

Identifying the Role of Power Pivot in Business Intelligence (BI)

Review of Pivot Tables

Create a PowerPivot Directly from Excel

Adding a second sheet to a Pivot Table

Using the Data Model

What is the Data Model?

Data Sources

Creating a Pivot Table from the Data Model

Relationships

What is a relationship?

Key fields

Detecting relationships

Creating a relationship

2. Power Query

Power Query Overview

Power Query Introduction

Data and its different source

Load data from different source

Connect to an Excel file

Connect Power Query to a .TXT file

Connect Power Query to webdata

Connect Power Query to folders of data

Extracting data from an external database

Import Data into Power Query

Loading and Refresh

Data Transformation

In built transformation in Power Query

Deleting rows, columns, or blanks

Filtering out data you don’t need

Splitting or joining columns or text

Incorporating the next month’s data to an existing report

Reduce your work with Power Query

Apply the repetitive task in one dataset

Apply all the change in other datasets.

3. Power view course outline

Introduction to PowerView

Introduction to Excel PowerView

About Excel Power View

Activating Excel Power View

Correctly Structure Your Data

Graphs and Visualizations

Create a Column Chart

Create a Bar Chart

Create Line Charts

Creating Pie Charts

Geographical Mapping

Create a Scatterplot Chart

Create Chart with Data relationship

Creating Data Relationships

Creating Graphs with Data Relationships

Creating Scatterplots with Data Relationships

Slicers and Timelines

Using Slicers as interactive filters

Using Timelines to filter date ranges

Interactive Dashboards

Introduction to Interactive Dashboards

Creating Interactive Dashboards