NCC013 02 - Advanced Health Care Spreadsheets

Week 1 Overview

This week we will learn how to modify an existing macro to do additional things.  You are encouraged to read the lecture notes while watching the video tutorials and carrying out the steps simultaneously.  You will also practice these steps in the corresponding homework assignment, then view the homework video and evaluate your own performance.

Lecture Notes and Data Sets

Lecture Notes and Data Sets

I encourage you to open the data set and carryout the steps in the lesson while following the notes and watching the video (pausing as needed).

Lecture Video Tutorials

1 More with Macros - Video Tutorial

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.
 
 
 
    Note: Toolbars in Windows 2007 (windows calls it the ribbon) cannot be customized as they can be with Mac computers.  This video has been converted if you wish to view the process.

Assignment

1 More Macros

- Modify the existing macro to use a green font and a light red fill (use the color index provided in the notes - or - below in cells N12 and N13).
- Apply the macro to format both first and last names for those with a last name starting with B.
- After completion, save the excel file as YourName Week1 Assignment, and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page.
(.xls, 61K)
Download 1 More Macros Assignment
Review the homework "solution" tutorial, complete the self evaluation, save the file as YourName Week1 Evaluation and submit via the appropriate dropbox under the 'Coursework' tab located at the left of the course page.
Note: each self evaluation is the same, so if you keep the blank file somewhere accessible, you do not need to download it after every assignment. 
(.xlsx, 41K)
Download Self Evaluation

Homework Solutions

It is  strongly  encouraged that you attempt the entire assignment before viewing the solution video.