Format Text in Microsoft Excel

What you'll do

In this lab, you will format and modify text using various functions.

1. Use a function to show how many characters are used
2. Use functions to extract information into the appropriate columns
3. Plan to send a single email to all vendors
4. Use a function that lists each vendor email list
5. Create a Column Chart based on columns
6. Move the chart to a separate sheet in the workbook and name the sheet
7. Change the title for the chart
8. Remove the horizontal gridlines
9. Create a copy of the sheet that contains the chart
10. Name the sheet