Powerpivot Excel 2013 - Power Pivot

The Knowledge Academy
En Cardiff (Gales)

$2.536.040
+ IVA
*Precio Orientativo
Importe original en GBP:
£2.995

Información importante

Tipología Curso
Lugar Cardiff (Gales)
Duración 2 Days
Inicio Fechas a escoger
  • Curso
  • Cardiff (Gales)
  • Duración:
    2 Days
  • Inicio:
    Fechas a escoger
Descripción

Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments

Información importante
Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
Fechas a escoger
Cardiff
Castle Street, CF10 1SZ, Cardiff, Gales
Ver mapa
comienzo Fechas a escoger
Ubicación
Cardiff
Castle Street, CF10 1SZ, Cardiff, Gales
Ver mapa

¿Qué aprendes en este curso?

Excel
Access
IT
SQL
Import
MS Excel
MS Excel
Excel
MS Excel
Excel

Temario

The Knowledge Academy PowerPivot for Excel 2 day course covers the following topics:

This intense and practical training course will provide delegates with a comprehensive understanding of Excel. The course will explore the stages of creating a KPIKPIs with absolute targets

Pre-Requisites                       

  • There are no pre-requisites needed prior to attending this course

Who should attend?

  • This course is suitable for those who need to use PowerPivot for Excel 

What will you learn?

  • Once you have completed PowerPivot for Excel Course you will understand:
  • Connecting to SQL ServerFiltering rows and columns
  • The EARLIER function
  • Semi-additive measures
  • Creating the measures needed
  • Using in pivot tables

Course Outline

  • Changing a table after import
  • Creating a data model
  • Hiding columns and tables
  • Renaming columns and tables
  • Diagram view
  • Manually creating
  • Pivot tables
  • Creating pivot tables
  • Sorting pivot tables
  • Connecting to Excel
  • Creating Excel tables
  • Linking to Excel tables
  • Connecting to other data
  • Linking to Access
  • Pasting tables
  • Creating aggregation measures
  • The FILTER function
  • The CALCULATE function
  • ALL and ALLEXCEPT
  •  Creating a calendar
  • Date calculations
  • Working days
  • Period to date
  • Prior and parallel year
  • Hierarchies
  • Creating a hierarchy
  • Three parts of a KPI

Información adicional

  • Learn Linking to SSRS reports
  • Identify Key Performance Indicators
  • Understand Problems with ratiosX suffix functions (eg SUMX)
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Courses Delivered By World Class Training Instructors
  • Training Provided In Luxury Venues 
  • The Training Course Includes Material And Manuals
  • Book Online Or Call 01344 203999 To Speak To A Training Advisor Today