Knowledgebase: Downloads > EC Professional
EC - External Help Resources for Excel Power Pivot
Posted by Joel Brickell, Last modified by Becky Gruber on 11 September 2020 02:46 PM

External Help Resources

It is not the scope of our Support team to train and support EnergyCAP users on basic functionality of Excel's Power Pivot. Use of Report Designer comes with the presupposition that EnergyCAP users are comfortable working with the plug-in and Excel Power Pivot tables.  Below are external help resources to assist with a proficiency in Power Pivot and Pivot Tables. Please note that we do not endorse or benefit from any particular resource - the list below was compiled using an online search.

Microsoft Product Sites

Microsoft Power Pivot Add-In - https://support.office.com/en-us/article/Power-Pivot-Add-in-a9c2c6e2-cc49-4976-a7d7-40896795d045 

Power Pivot - Overview and Training - https://support.office.com/en-us/article/Power-Pivot-Overview-and-Learning-f9001958-7901-4caa-ad80-028a6d2432ed  

Power Pivot Forum - https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlkjpowerpivotforexcel 

Power Pivot Help - https://support.office.com/en-us/article/Power-Pivot-Help-241aac41-92e3-4e46-ae58-2f2cd7dbcf4f 

Data Analysis Expressions (DAX) in Power Pivot - https://support.office.com/en-us/article/Data-Analysis-Expressions-DAX-in-Power-Pivot-bab3fbe3-2385-485a-980b-5f64d3b0f730 

Training

Power Pivot Pro: training resources on Power Pivot and Power BI - http://www.powerpivotpro.com/ 

TLG Learning - Microsoft-certified training workshops - http://www.tlglearning.com/Training/PowerPivotPowerViewTraining.aspx?gclid=Cj0KEQjwvZq6BRC9kfq2zKfQ_94BEiQAOeUVC9PszK597PtfYcEPlNRR4r27fcDr38ENxeyOpxzHa8oaAva28P8HAQ

Books

Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016: http://www.amazon.com/Power-Pivot-BI-Excel-2010-2016/dp/1615470395/ref=sr_1_1?ie=UTF8&qid=1464200351&sr=8-1&keywords=power+pivot+and+power+bi 

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) - http://www.amazon.com/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X?ie=UTF8&qid=1464269780&ref_=tmm_pap_swatch_0&sr=8-11 

Twitter

#PowerPivot - https://twitter.com/hashtag/powerpivot?src=hash

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: