Cloud Computing Center

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

If you use Power Pivot and Power Query, it is necessary to download and install these plug-ins as a standard .EXE application in Microsoft Excel 2010. I focus on direct download links and short steps how to do.

Power Pivot
Power Pivot should automatically appear as a tab if you run Excel again. If not, then you need to install Visual Studio 2010 Tools for Office Runtime:
and then go to File> Options> Add-ins and right-click COM Add-ins and choose Go ... and then check PowerPivot for Excel, picture:

powerpivot installation in excel 2010 install addins

Power Query

The next installation refers to Power Query, which requires a minimum of Service Pack 1 (a 64-bit version) or Service Pack 2 (a reference to a 64-bit version) for Microsoft Excel 2010.
Power Query can then be downloaded from this link:

Nájdete ma aj na

youtube logo male


About Jan Zitniak

Jan ZitniakFor over 11 years Jan Zitniak has been a professional instructor concentrating on Microsoft Office. He holds an international Microsoft Excel – Office Excel ® 2010 Expert certificate and has written several books discussing Microsoft Office.

obalka microsoft excel for intermediates

I'm author of books Microsoft Excel 2019 for intermediates, Microsoft Excel 2019 for beginners (for free, download here), Microsoft Outlook 2013 Jednoduše (translated to czech language), Microsoft Office 2016 Podrobná uživatelská příručka (translated to czech language).

The information mentioned in the books comes from practical experience he obtained at such large companies as T-Systems, BSH Bosch and Siemens, Veolia, Magneti Marelli, Coavis, National Bank of Slovakia and many others.

If you like my website you can support me by buying my book on Amazon clicking here. - simple Excel online

Simple online Excel with many examples - is a project for students, teachers, lecturers and other people who want to learn Excel online. Many Excel exercises available there.

Príručka Microsoft Word, Excel, PowerPoint zadarmo na stiahnutie