1 / 16

Excel Chapter 3

Excel Chapter 3. Nitin Chowdary Are Nitin.are@mail.wvu.edu. Imports Web Queries XML. Importing external data. Importing is the process of inserting data from one application or file into another. Why do we need to import !. IMPORT ………………….. !. Import a text file

akando
Download Presentation

Excel Chapter 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Chapter 3 Nitin Chowdary Are Nitin.are@mail.wvu.edu

  2. Imports • Web Queries • XML

  3. Importing external data • Importing is the process of inserting data from one application or file into another. • Why do we need to import !

  4. IMPORT ………………….. ! • Import a text file • Import an Access Database Table or Query • Import data from other sources

  5. Import text file • Text file is a data file that contains letters, numbers, and symbols only. • Delimiter is a character used to separate data in a text file. Most commonly used are TABS and COMMAS. • Tab-delimited file • Comma-separated value (CSV) file

  6. How does data is arranged in rows and columns • In tab-delimited file TAB separates columns. • In Comma-separated value (CSV) file COMMA separates columns. • New line character to separate data in ROWS.

  7. Importing text file with .txt extension ! • Then you need to setup Text Import Wizard. • Contains 3 steps

  8. Step 1 of 3 • Choose file type • Delimited/Fixed width • Specify starting row number • Start import at row • Have a look at preview of data at bottom

  9. Step 2 of 3 • Select one or more delimiters to specify how the data to be entered in columns and row. • Have a look at preview of data at bottom

  10. Step 3 of 3 • Specify column data format

  11. Import an access database table or query • Select “FROM ACCESS” • Choose the desired access database ( .aacdb extension) • Then select table dialog box pops up asks us to select table/query. • Then Import data dialog box pops up asks us to • How you want to view the data? • Where do you want to put the data?

  12. Import Data from other sources

  13. Creating a web query • Web Query connects from an Excel worksheet to data on a web page. • Why do we need this ! • Stock prices, traffic reports, airport delays etc. • Select “FROM WEB” in Get External Data column.

  14. How to create a web query • Specify the ULR in ADDRESS ( u can see the page by clicking GO ) • Select IMPORT • Select cells where to put data

  15. Managing connections • Excel creates a link to the original data source so that we can update the data quickly in Excel. • Refresh connections • Display connections • Set connection properties

More Related