Excel 11 tutorial

Excel 11 tutorial - Excel Tutorial 11 Connecting to...

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 A 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 Properties button
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.

Page1 / 30

Excel 11 tutorial - Excel Tutorial 11 Connecting to...

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