Chapter 2 – Getting Your Data Into PowerPivot

August 16, 2010 at 11:08 AM Leave a comment

One of the great things about PowerPivot is that you can mash up data from many different sources. For example, you can:

  • Copy and paste Excel data to PowerPivot
  • Link to data in Access, SQL Server, Oracle, Teradata
  • Link to data in an Excel worksheet, once the worksheet has been converted to a Table with Ctrl+T
  • Import data from a simple text file

In this episode of the MrExcel podcast, watch the process of importing 1.8 million rows from a text file into Excel 2010.

Advertisements

Entry filed under: Chapter. Tags: , .

Chapter 1 – Why You Will Love PowerPivot Even If You Don’t Own a Kindle…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


PowerPivot for the Excel Data Analyst

PowerPivot Book Cover

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 10 other followers

Recent MrExcel Tweets


%d bloggers like this: