Excel.11 - ExcelTutorial11 Connectingto ExternalData...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
COMPREHENSIVE  Excel Tutorial 11 Connecting to  External Data
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives Import data from a text file Work with connections and external data  ranges Define a trusted location Understand databases and queries Use the Query Wizard to import data from  several tables Edit a query Import data into a PivotTable and PivotChart New Perspectives on Microsoft Office Excel 2007 2
Background image of page 2
Objectives Create a Web query Retrieve data from the World Wide Web Use hyperlinks in a workbook Access data from an XML document Work with XML data maps New Perspectives on Microsoft Office Excel 2007 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Examining Data Sources New Perspectives on Microsoft Office Excel 2007 4
Background image of page 4
Working with Text Files text file  contains only text and numbers without  any formulas, graphics, special fonts, or formatted  text In the Get External Data group on the Data tab,  click the From Text button In the first step of the Text Import Wizard, choose  how the data is organized, and then specify the row  in which to start the import In the second step, set the column breaks by  clicking a location in the Data preview window to  insert a column break, double-clicking a column  break to delete it, and dragging a column break to  New Perspectives on Microsoft Office Excel 2007 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Working with Text Files In the third step, specify the data format for  each column by clicking the column, and  then selecting the appropriate data format  option button, or skip import columns by  clicking the column in the Data preview  window then clicking the Do not import option  button Click the Finish button Specify where to insert the imported text, and  then click the OK button to import the text file  into the worksheet New Perspectives on Microsoft Office Excel 2007 6
Background image of page 6
Working with Text Files New Perspectives on Microsoft Office Excel 2007 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Editing the Properties of an  External Data Range Click any cell in the range containing the external  data In the Connections group on the Data tab, click the 
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/09/2011 for the course BCIS 2610 taught by Professor Sidorova during the Spring '08 term at North Texas.

Page1 / 30

Excel.11 - ExcelTutorial11 Connectingto ExternalData...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online