Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.
This course presents information and skills that are appropriate for users of either the Office 2021 or Office 365 applications. However, the instructional environment for the delivery of this course utilizes Office 365.
You will:
Get started with Power Pivot.
Visualize Power Pivot data.
Work with advanced functionality in Power Pivot.
Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
Prerequisites
To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following courses:
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2
Microsoft® Excel® for Office 365™/2021: Data Analysis with PivotTables (recommended)
*Course cost listed does not include the cost of courseware. Course to run is subject to a minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.