excel and tableu

Here are a few notes to consider about this assignment:

1) When you first open the assignment, be sure to Enable Macros and Editing. This will appear as a button just below the ribbon or menu bar. Click on it and then ok. If you do not see this and you do not see a dialog box that requests your last name, first name and red id, then you have to manually change your security settings for Macros. This varies with MAC vs PC and with the various versions of Excel (2000, 2003, 2007, 2010, 2013). Do a search in Google on your version for instructions on how to change your Macro Security settings. Failure to enable this macro to enter your name and red-id will result in a loss of a minimum of 50% of the points.

2) Pivot tables: Versions of Excel, both the PC and the MAC include the ability to insert Pivot tables in various menus. Version 2010 has the pivot tables in the Insert Tab. You might have to google pivot table and your version of Excel to find where the pivot table feature is. You do not have Pivot table in the Starter Excel and some MAC versions of Excel. You will need to use a friend's Excel or the school's computers in that case.

Good luck. You have plenty of time, but don't wait until the last minute. It is tricky and you may need to swing by my office hours for some help.

Remember - this is an individual assignment!