PowerPivot is a free Microsoft add-on for Excel 2010 and a built-in feature of Excel 2013. It extends the functionality of pivot tables and pivot charts using concepts and features that you may already be familiar with, while providing additional functionality and formulas. If you have previous experience with pivot tables, you can think of PowerPivot as an amplifier of your existing Excel pivot skills. Regardless of any prior experience with pivot tables, PowerPivot allows you to work with large volumes of data, using less space, but with speed.
This session by Joel Rosenblum will help you understand the PowerPivot functionality in Excel 2010 and 2013. The process you may have implemented previously with many VLOOKUPs is now simplified as PowerPivot already understands the relationship between the tables of data in a data source. In addition, you can add data from multiple data sources creating Data Mashups. By adding intelligent calculated columns, you can create Business Intelligence which can be presented using a Dashboard.
In this program, you will learn:
Who should attend
Joel Rosenblum is a Principal Consultant with Techinsight, based in Denver, Colorado. He is a well-respected speaker, trainer and consultant with over 25 years’ real-world experience which includes many Microsoft and Oracle desktop and server products. With a Master’s degree in Engineering, Joel has de... More info