My Shopping Cart
There are no items in your shopping cart.

Excel 2010/2013: How Can PowerPivot Take Your Existing Pivot Tables And Charts To The Next Level? (IME940I)

Presented By : Joel Rosenblum
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Tue, September 23, 2014
Event Description

Manage large volumes of data easily with Excel PowerPivot

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:

  • How to access and use PowerPivot functionality in Excel 2010 and 2013
  • PowerPivot extends Excel’s Pivot Tables and Pivot Charts and empowers you to work with larger data sets and sources with ease. If you think of Excel with Pivot Tables as a family 4-door sedan; Excel with PowerPivot would be the more versatile van.
  • PowerPivot extends Pivot Table functionality. You can add additional calculated columns or tables of data from multiple sources, and blend the data together to create Data Mashups.
  • PowerPivot simplifies your work. For example, you can relate tables together without using VLOOKUPs and place all the tables together in one field list.
  • PowerPivot provides Business Intelligence by creating running totals, moving averages, year-over-year growth and other professional business analysis formulas.

Who should attend

  • Business analysts
  • Data analysts
  • Report writers
  • Excel power users
  • Database analysts
  • Excel data analysts
About Our Speaker(s)

Joel Rosenblum, Excel Advanced Tutorial ExpertJoel Rosenblum
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

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel 2010/2013: How Can PowerPivot Take Your Existing Pivot Tables And Charts To The Next Level?
    Presenter(s): Joel Rosenblum Protection Status