Viewers: in countries Watching now:
Excel 2003 Essential Training with Mark Swift is a movie-based workshop for users who are new to working with spreadsheets, or those wanting to improve their skills. This workshop begins with a basic overview of the application and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more. Exercise files accompany the training, allowing you to follow along and learn at your own pace.
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 undo that paste, and this time I'm going to open up the file that we have here in your Student Folders, Chapter 12, and I'll need to look at all files. There we are. This csv file, I'll open that up and you can see that it opens up just like it did in Notepad. Commas are intact, all the data is smashed together. If you select this range, go up to Table and Convert - Text to Table, one of the options that we have here is text separated with commas. So it's already prepared to take delimited text and create a proper Word table. Say OK. And now you can see the table inside of Microsoft Word is almost identical to that in Excel. Using delimited data is one of the most powerful ways to move it into an Access database as well. Access can accept and create delimited files for use within other programs.
There are currently no FAQs about Excel 2003 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.