Assignment #10

1. Watch the video Reformatting Data (MS Excel)   (CC).

2. Create a MS Excel spreadsheet similar to the document developed in the video and shown below (assignment10-students.xlsm or data). In particular, create an "Extract Addresses" command button that when pressed extracts the address, city, state, and zip code. Insert your name somewhere in the document. Rename this sheet "Assignment 10A".

   Note: Mac computers only support a restricted version of VBA. If your Mac computer does not allow you to complete this assignment, then complete either option A or B below.

   A. Write out all the code presented in this video and briefly comment what each line does. Save and upload this information to your website.

   B. Complete this assignment using the NSU Virtual Desktop. A link to this service can be found under Obtain access to MS Excel.

   
   
   
   

   Complete either Step #3 or Step #4 below.

3. Create a new tab in the Microsoft Excel document created in the previous step. Rename this sheet "Assignment 10B". Enter the data as shown in the image below. Create an "Extract Names" command button that when pressed extracts the first and last names.
   
   
   
   
4. Explore one VBA tutorial by going to TrumpExcel and selecting "Free Training" and then selecting "Excel VBA Course". Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.
   
   
5. Save your work as "assignment10.xlsm" when you are finished. The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)".
   
   
6. Upload this file to YOUR-CLASS-WEBSITE.   Help

OR

Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4.