Excel's PowerPivot Add-In

Learning Objectives

• To investigate the PowerPivot application and importing data.
• To discuss how to manipulate data in a PowerPivot worksheet.
• To create reports using PowerPivot data.
• To analyze how to use DAX functions in PowerPivot.
• To inspect how to distribute PowerPivot Data.

Course Description

Excel is one of the most widely used spreadsheet programs in the world. 

People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence. 

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. 

Fortunately, Excel provides PowerPivot to help you organize, manipulate, and report on your data in the best way possible. PowerPivot add-in allows you to import data from various sources and create dynamic reports.

Join in this Excel CPE Webinar to know how PowerPivot add-in allows you to import data from various sources and create dynamic reports.

Learn how Excel allows you to advance your data analysis capabilities by using PowerPivot.

You can learn different techniques and shortcuts to learn how to make an excel worksheet Visually Pleasing and:

• Increase your Microsoft Excel & Power Pivot SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
• Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
• Use Excel Power Pivot with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac

Overview

• Usage of Power Pivot in Excel

  2 mins
• Importing data into a data model

  7 mins
• Adding unique identifiers to a table

  11 mins
• Inserting a pivot table in Excel

  13 mins
• Inserting KPIs in a pivot table

  17 mins
• Inserting a calculation in a dataset

  19 mins
• Applying KPIs to a measure in pivot table

  21 mins