- Explain how Power Pivot is accessed within Excel.
- Describe how to create and manage data relationships.
- Interpret the type of formula used for creating a lookup.
- Explain the benefits of using measures in Power Pivot.
- Determine the location of data sources when using a PivotTable.
- Distinguish the process for illustrating results using PivotCharts.
Skill Level Beginner
- [Josh Rischin] Let's face it data is everywhere and organizations of all shapes and sizes are continually looking at ways to harness this data to improve outcomes. And to also improve the quality of products and services that they produce. Luckily for these organizations and the individuals that work for them as the volume of data continues to grow so too does the capability of tools that can analyze this data. - Hi, I'm Josh Rischin, and I've been working with large volumes of data for more than 20 years now and have used this data to help enterprises of all sizes make more evidence-based decisions. In this course I'll introduce you to Power Pivot. We'll talk about how to create and manage data models. We'll then cover how to create calculations and measures and finally we'll look at ways to seamlessly analyze your data using Excel's standard pivot table and charting features. If you're passionate about using data to help make positive changes to your organization then please join me as we explore Excel's Power Pivot.