Microsoft/PowerPivot for End Users

PowerPivot for End Users Certification Training Course Overview

This 2-day Instructor Led Course How to utilize PowerPivot to get to information sources, make connections, utilize the PowerPivot DAX articulations and create and design reports. You will likewise investigate how PowerPivot exercise manuals can be coordinated with SharePoint 2010.

Audience :

Progressed Excel clients, clients that need to pick up commonality with PowerPivot to assemble convincing reports.

 

PowerPivot for End Users (16 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training
09 - 10 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
20 - 21 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• AZ-303: Microsoft Azure Architect Technologies
• AZ-304: Microsoft Azure Architect Design
• AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
• AZ-500: Microsoft Azure Security Technologies
• DA-100 Analyze Data with Power BI
• AZ-204: Developing Solutions for Microsoft Azure
• AZ-104T00-A: Microsoft Azure Administrator
• AZ-900T01: Microsoft Azure Fundamentals (1 day)
• DP-203T00: Data Engineering on Microsoft Azure
• Microsoft Power Platform Fundamentals

Course Modules

Module 1: Overview
  • Topic details are not available.
Module 2: PowerPivot Introduction
  • Excel 2010 Features
  • PowerPivot Introduction
  • Installing PowerPivot
Module 3: PowerPivot Data Sources
  • Supported Data Sources
  • Loading Data Sources
  • Cleaning Data
  • Creating Relationships
Module 4: PowerPivot Functions
  • PowerPivot Expressions
  • Create a Time Table
  • Using DATE Functions
  • Using TIME INTELLIGENCE Functions
  • Using STATISTICAL Functions
  • Using FILTER Functions
  • Using LOGICAL and INFORMATION Functions
  • Using TEXT Functions
Module 5: Building Reports using PowerPivot
  • PowerPivot Reports
  • Creating Reports
Module 6: PowerPivot for SharePoint 2010
  • Reports and Email
  • PowerPivot for SharePoint 2010
  • Installing PowerPivot for SharePoint 2010
  • Configuring PowerPivot For SharePoint 2010
Download Course Contents

Request More Information

Course Prerequisites
  • General Excel and Report building aptitudes.

 

After completion of this course, you will learn following topics:

  • Investigate each part of utilizing Microsoft PowerPivot.

 

FAQ's