Exporting worksheet data
A customer has asked for a price list that they can load into their proprietary system. They have asked you to provide comma-separated values as it is the most compatible with their process. You need to export the price list as a CSV file.
1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.
https://github.com/alcadelina/Excel-
2. Before we begin the export, take note of some of the elements of the workbook. Click to select cell C4, and observe the formula used to calculate the price. Also note the formatting of the cells. Some have colored text, colored fill, or bold type. There is also a second worksheet, called Percentages:
3. To export the file, Click File → Export:
4. In the Export window, click to select Change File Type, then click to select CSV (Comma delimited) (*.csv) from the Change File Type category. Finally click Save As:
5. Choose a location for your file, leave the File Name as Activity 6-1.csv, and click the Save button:
6. Note the alert regarding multiple sheets, then click OK:
7. The open workbook is now called Activity 6-1.csv, but you will note that the formatting and formulas are still visible, and the Percentages worksheet is still visible. You can now close the file:
8. If necessary, open Excel 365, then click File → Open and navigate to the Activity 6-1.csv file you just saved. Click on the file to open it:
9. You will now see that the formatting has been removed, the formulas are replaced with values, and the Percentages worksheet has been removed:
10. You can now save your changes as Activity 6-1 Complete.csv and close Microsoft Excel 365 to complete the activity.
11. Now, you can check out an example of a completed document in the link below:
No comments:
Post a Comment