Excel (Microsoft Office Excel) is a spreadsheet program and a program from the Microsoft Office package. Training for an initial level of use PowerPivot. Power Pivot is a software add-on for Excel 2016 that you can use to perform powerful data analysis and the creation of detailed data models. Using the plug-Power Pivot, you can connect large amounts of data from different sources, quickly analyze information and easily share insights. By using Excel, as well as using the plug-Power Pivot, you can create a data model, a collection of tables with relations. The data model that you see in the workbook in the Excel program is the same one you see in Power Pivot window. All data that you import into Excel are available in add-Power Pivot.
What will you learn?
Exams and certificates