Power Query & Pivot in Excel
Sat, Sep 14
|Virtual Workshop Power Pivot in Excel
All classes are live, hands-on training via remote instructor.
Time & Location
Sep 14, 2024, 6:00 PM – 8:00 PM
Virtual Workshop Power Pivot in Excel
About the Event
Power Pivot & Query in Excel
What you'll learn in this excel workshop:
PowerPivot is a add-in for Excel that greatly extends the pivot table. PowerPivot offers improved data summarization and cross-tabulation as well as expanded data capacity, and advanced calculations. As a result, PowerPivot falls under Microsoft's Business Intelligence offerings. This product brings the power of advanced analytics to the average Excel user.
Excel Versions PowerPivot is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016. This course is taught using Excel 2013 software but the concepts are identical with Power Pivot implementations found in Excel 2010 and 2016 (or Office 365).
Target Student This course is for students/professional whose job responsibilities include complex Excel reports and advanced analytics.
Prerequisites Excel Introduction or equivalent skills. Previous experience with pivot tables is helpful but not required.