• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Importing External Data

To analyze data with Excel, you must first provide the data in a format that Excel recognizes. You can do this in two ways: you can open a data source in a format that Excel knows how to work with, or you can import the data into an Excel worksheet.

Tip

When you import data into Excel, you generally are creating a copy of the data, separate from the original data source. As a rule of thumb, if you want to see updates to the original data, you should open the data in Excel instead of importing the data into Excel.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint