Quality Seal Emagister EMAGISTER CUM LAUDE

Powerpivot Excel 2013 - Power Pivot

The Knowledge Academy
En Cardiff (Gales)

£2.995 - ($2.539.974)
+ IVA

Información importante

  • Curso
  • Cardiff (Gales)
  • Duración:
    2 Days
  • Cuándo:
    A definir
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
A definir
Cardiff
Castle Street, CF10 1SZ, Cardiff, Gales
Ver mapa

¿Qué aprendes en este curso?

Excel
IT
MS 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