Follow the link to our self-service price quote form to generate an email with a price quote.
We can deliver this class for your group. Follow the link to request more information.
Receive an email when this class is available as "Ready to Run" or "Early Notice" status.
If you have high-speed internet and a computer you can likely take this class from your home or office.
The new analytics tools in Excel make it easy to conduct manipulate and gain insights from big data. PowerPivot extends the use of pivot tables with a data model and offers improved data summarization and cross-tabulation and advanced calculations. Power Query retrieves data from a variety of sources can be cleaned up before being added to data model. Power View create interactive dashboards. Power Map is a 3D visualization tool to create map charts and interactive tours. These tools bring the power of advanced analytics to the average Excel user.
PowerPivot, Power Query, Power View, and Power Map are add-in programs for Excel 2010 and Excel 2013. These programs are integrated into Excel 2016 and later versions. This course is taught using Excel 2019 software platform. The concepts between versions are the same; minor differences in the interface between versions are explained.
This course is for individuals whose job responsibilities include complex Excel reports and advanced analytics.
Excel Introduction or equivalent skills. Previous experience with pivot tables is helpful, but not required.
View outline in Word
Attend hands-on, instructor-led Excel PowerPivot and Interactive Visualizations training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.
For additional training options, check out our list of Power BI Courses and select the one that's right for you.