Digi Academy

PowerPivot for End Users

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

After completing this module, students will be able to: Understand your course, classroom, classmates, facility and instructor. In this module we take a look at the lessons of the module! PowerPivot Introduction

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Programma

Install PowerPivot for Excel


After completing this module, students will be able to:


Install PowerPivot for Excel


Be able to navigate the PowerPivot windows


Understand the new features of Excel 2010


In this module we take a look at the lessons of the module!


Supported Data Sources


Load Data From SQL Server


Load Data From Text Files


Load Data via Copy and Paste


Load Data via Data Feeds


Load Data via Reporting Services


Cleaning data in PowerPivot


Create Relationship between Data Sources


After completing this module, students will be able to:


Import various data sources into PowerPivot


Understand how to clean imported data


In this module we take a look at the lessons of the module!


PowerPivot Expressions


Create a Time Table for future labs


Use DATE Function


Use DATEVALUE Function


Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions


Use EDATE Function


Use EOMONTH Function


Use NOW and TODAY Functions


Use TIME and TIMEVALUE Functions


Use WEEKDAY and WEEKNUM Functions


Use FIRST* and LAST* Functions


Use DATE* Functions


Use STARTOF* and ENDOF* Functions


Use CLOSING* and OPENING* Functions


Use LASTOF* and FIRST* Functions


Use PREVIOUS* and NEXT* Functions


Use AVERAGE* Functions


Use COUNT* Functions


Use MAX* and MIN* Functions


Use ALL, ALLEXCEPT and ALLNOBLANKROW


Use CALCULATE, CALCULATETABLE


Use DISTINCT


Use EARLIER and EARLIEST


Use FILTER


Use REALTED, RELATEDTABLE


Use VALUES


Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)


Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)


Use TEXT Functions


After completing this module, students will be able to:


Be able to describe all the new PowerPivot Expressions


Use and apply many of the PowerPivot Expressions


In this module we take a look at the lessons of the module!


PowerPivot Reports


Use PivotCharts


Use Slicers


Use Sparklines


After completing this module, students will be able to:


Describe the different Report types in PowerPivot


Be able to create Slicers and Sparklines for more engaging reports


In this module we take a look at the lessons of the module!


Reports and Email


PowerPivot for SharePoint 2010


Install PowerPivot for SharePoint 2010


Configure PowerPivot for SharePoint


Publish to SharePoint 2010


Configure PowerPivot for SharePoint 2010


After completing this module, students will be able to:


Describe the integration points between PowerPivot and SharePoint 2010


Be able to publish and setup workbook data refresh in SharePoint 2010



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto