Exporting data


show more Exporting data provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Exporting data

Exporting data from Microsoft Excel is just as easy as importing it. An obvious destination for an Excel spreadsheet would be as a Microsoft Word table or an Access database. One of the ways to transfer data from a spreadsheet to another application would be to use a delimited text format. If I select the File > Save As here in Microsoft Excel, you'll see that I have an option for, in my Save as type dialog Tab Delimited Text, Comma Delimited Text. This is exactly the process that went I through to create the Quarterly_Sales.csv.

Quarterly_Sales.csv is this file delimited by commas. So I'll use that file to import into other programs in a moment. Let's cancel this dialog box. An obvious and the most intuitive way to move information from Excel to Word would be to select the data that you want to move, copy it, and then in Word Paste. Automatically, again because the tight integration in the Suite, it knows how to create a Word table from the Excel spreadsheet. If I can ...

Exporting data
Video duration: 2m 19s 4h 8m Beginner

Viewers:

Exporting data provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...