PowerPivot Courses & Corporate Training
Not currently scheduled. Contact us if you’re interested in this course.
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
This PowerPivot group class concentrates on how to create powerful Pivot Tables through multiple table relationships.
By the end of the Excel PowerPivot training course, you will feel confident setting up relationships, creating and displaying complex Pivot Tables and using Calculated DAX columns.
This class is perfect for those that have a fundamental understanding of Excel and using Excel Pivot tables and want to see more correlation between data. Those in the financial, real-estate or data analysis field will especially find this class enjoyable.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, if you plan to take the course live online, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
We don’t currently offer discounts as we do our best to affordably prices our courses.
Students must be comfortable using a computer. No other prior knowledge is required.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of PowerPivot Fundamentals with your selected courses.
Become an advanced Microsoft Excel user in just three days. This Excel Bootcamp includes 21 hours of hands-on training in formulas, functions, Pivot Tables, macros & more.
Learn the fundamentals of VBA, Excel's programming language, in project-based training. This VBA course concentrates on the automation of repetitious Excel tasks and reports.
This certification program will prepare you for the Microsoft Excel exam: Excel 2016 Expert: Interpreting Data for Insights. This program includes three group classes, four hours of private training, and the Excel Expert Exam with a free retake.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
PowerPivot is an Excel add-in that allows the user to analyze much greater quantities of data, as well as build sophisticated data models.
PowerPivot provides several unique advantages over using Excel's standard features. A few of these include:
Generally speaking, in Excel, we are limited to using a single dataset as the source of a Pivot Table (we will exclude the internal data model from this discussion). But with PowerPivot, you can select different data sets, create relationships (effectively creating a relational database), and build a single Pivot Table from these multiple sources.
There are approximately 1,048,576 rows (and 16,384 columns) available on every Excel worksheet. This is more than most of us would ever need, but for some, it is not enough. Excel users that work with large sets of data generally agree that once data goes beyond 700,000 rows, you run the risk of Excel crashing on you. PowerPivot, on the other hand, increases row capacity up to 100 million rows of data, thereby vastly increasing the amount of data that can be collected and analyzed. The more data collected, the more accurate your projection.
PowerPivot incorporates both Excel functions, as well as DAX (Data Analysis eXpressions) functions. DAX is a special type of programming that increases the specificity of potential results. One example of a DAX function is CALCULATE, which works like a SUMIFS in Excel, except you can expand beyond the standard SUM operation to include any function with the filter effect added to it.
In PowerPivot, two types of calculations are possible: Calculated Columns and Measures. A Calculated Column is similar to creating a Calculated Field in your Pivot Table. Calculated Fields is an area of Excel that never received much investment by Microsoft, so it remains somewhat archaic, unpolished, and largely ignored by most Excel users. Calculated Columns in PowerPivot, on the other hand, are much more progressive. Measures are aggregate calculations that exist solely for Pivot Tables
With both Calculated Columns and Measures, PowerPivot employs a very easy-to-use auto-population method. Not only does the function name appear in a dropdown when you begin to type (like regular Excel), but the table name and column name appear in a similar fashion, making it incredibly easy to enter calculations.
Data Analytics is a new, trendy method of gathering large amounts of transactional data and then performing powerful analyses on this data for Business Intelligence (BI) purposes. PowerPivot serves as Microsoft’s BI engine. PowerPivot collects, organizes, and analyzes your data. You can then create Pivot Tables and Pivot Charts or go beyond this and use Power BI to create amazing visuals and dashboards.
The list of advantages that PowerPivot offers is a long one, but we will stop here for now. Remember, that PowerPivot is a free add-in for Excel that works closely with Excel to create powerful analyses. Enabling PowerPivot means that you can open up your data to more variety of sources, greater quantities, specialty functions, ease of calculating, and BI-related visuals. PowerPivot does not replace Excel, it works with Excel and greatly enhances it.