Looking for corporate training?
We offer custom onsite training and discounted class firstname.lastname@example.org
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.
This course is for students with a sound working knowledge of Microsoft Excel and general computing proficiency, including those who will be using Excel to make business decisions.
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!
Learn with real-world projects
Step-by-step instruction to boost retention
The Career Centers instructors are highly skilled communicators who really know their craft. They are wonderful about explaining and re-explaining when necessary and I never felt rushed or foolish for asking a question.
Gain industry knowledge from professionals
Retake the course for free within one year
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 Microsoft Excel PowerPivot with your selected courses.
Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.
Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow.
Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.
Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.
Learn Visual Basic for Applications to accelerate your workflow and reduce errors in Excel. This bootcamp course includes Excel VBA Macros Levels 1 and 2. By the end of this course, you'll be able to develop a macro, create automated event processes, and use automation to manage unforeseen errors.
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.
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.