Learn to master Power Pivot for Excel from your chair with our high quality video course.
This video course is divided in three parts: the first one (Beginner) introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Beginner section is completely available in the free trial, you are just one click away to start.
The second part of the course (Intermediate) improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions.
The last part (Advanced) enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.
Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course.
The course includes almost 10 hours of video in 73 lectures.
To see that is base on Power pivot 2010 and 2013 is very disappointing, it seems outdated, even the authors are very young in the videos
Victor Leonel Gorra Ramos(Aug 10, 2023)
El curso me ha parecido super,
sin embargo, quisiera ver si me pueden orientar con algún correo a donde pudiera plantear mis dudas con respecto a algunos ejemplos que utilizan en los videos, como:
en la sección de patrones DAX en el capitulo de jerarquias padre - hijo
al momento de agregar la columna calculada
LOOKUPVALUE( Padre[Node], Padre[NodelID], PATHITEM( Padre[Jerarq PadreHijo],1))
me marca un error:
La función 'LOOKUPVALUE' no admite los valores de compraración de tipo Integer con valores de tipo text. Considere la posibilidad de usar la función VALUE o FORMAT para convertir uno de los valores
Agradezco de antemano la atención
Les envÃo un cordial saludo
Edgar Gallego(Aug 18, 2021)
It is an easy-to-follow and useful course. So many things learned to apply in my daily activities to simplify and speed up my tasks. Great content!
carlos barboza(Apr 27, 2020)
If you really want to get your hand SERIOUSLY DIRTY with Power Pivot on Excel or for Power BI....then THIS IS the course for you.
Morris Muthubi(Apr 14, 2020)
This was a well-outlined class. I look forward to finishing the definitive guide. I love Marco's teaching style and I look forward to more interaction. Worth the money and time
Kenneth Barber(Dec 4, 2019)
This course has aged surprisingly well. However, some parts of this course are no longer relevant. SQLBI's Mastering DAX course largely supersedes this course, and I would recommend that most people take Mastering DAX instead.
Thomas Rice, PMP(Aug 16, 2019)
Great course! I am very close to taking exam 70-779! Thanks again! Highly recommended for all Excel users.
Marshall Joubert(Jun 17, 2019)
Despite covering a previous version of Excel, the material was still relevant.
Min Thein Aung Aung(Aug 6, 2018)
Extremely useful for my career allowing my capability in analysis of transactions which are almost impossible to processed in Excel without using Power Pivot.
If the course is programmed with explanation of each formula that are introduced along the chapters in a way what is their nature, how they work or when they are useful, it would make the course more compelling!
Ezequiel A. Costa(Jun 17, 2018)
Wonderful workshop! Congratulations Marco Russo and Alberto Ferrari