I need this by tomorrow

Objectives:

Create an Excel workbook with external resourcesDesign a basic report tableApply professional formatting to a data tablePrepare an Excel document for printingEnter and format date dataConstruct basic formulas

Step 1: Gather the data

Research and locate any data you are interested in for the entertainment industry, or alternatively, research demographics information you feel are related to the industry.Your data must be different from other classmates.  Review post summaries completed before yours to ensure there is no duplication.

The data should be a minimum of 1 column x 5 rows (or 5 columns by 1 row) and should include numbers/currency that can be calculated with a formula.

Step 2: Start the workbook and create formulas

1. Copy the data from the original source in your research.
2. In a new Excel workbook, paste the data  with the data collected using the Paste Special option in the Edit Menu item.
3. Choose Paste “Values” or Paste “Unicode Text” (Option of Values / Unicode Text will vary depending on data collected).  Note: If data does not copy/paste easily into the document, it may need to be hand-typed.
4. Using the data collected: Create at least 2 unique formulas or functions to analyze the data.

Below is a tutorial discussing how to bring the data into Excel.

*****PLEASE LOOK AT THE VIDEO******

Below is a video discussing the creation of the formulas.

https://www.youtube.com/watch?v=FPBJQlFczGU

*****PLEASE LOOK AT THE VIDEO*****

https://www.youtube.com/watch?v=bs0csk9B1i8

1. Step 3: Format the data set

Formatting should include:

1. Change at least one font color
2. Change at least one font size
3. Change at least one type of font
4. Apply a background fill to your labels for the categories
5. Addition of borders
6. Professional alignment of text and/or numbers
7. Formatting of currency if appropriate.  For any number over 1,000 that is not currency, there should be commas with no decimals
8. Resizing of columns or rows if necessary to ensure all data and categories can be viewed easily
9. Insert at least two symbols with the Excel symbol browser to help emphasize areas of interest in your data

****PLEASE LOOK AT THE VIDEO*****

https://www.youtube.com/watch?v=QvCtt-tqu_Q

Step 4: Worksheet Design Guidelines

1. File saved with assignment number and first name, last initial.  For example: A1AprilW.xlsx
2. Headers contain name of Assignment (unless otherwise instructed) on each worksheet.
3. Footers contain creation date, last opened date, and student’s name on each worksheet.  Creation date is hand-typed.  Opened date will change every time assignment is opened.
4. Excess sheets removed (no unused extra tabs)
5. Each tab contains short worksheet name (renamed, should not be: Sheet1 or Chart1, etc)
6. Cell formatting appropriate: text and number formatting correctly used and appropriate to the scenario.  Financial figures should have currency or accounting format.  Figures over 100havenodecimals.Figuresunder 100 will show two decimals.
7. No cells contain errors (all green triangle cells resolved)
8. At least one cell comment on each worksheet to document notes from class OR to emphasize outcomes (explain why you chose a certain formula, certain data or explain the outcome of data analysis)
9. Designed for both Normal and Page Layout views but delivered in Page Layout view with the correct perspective chosen (either portrait or landscape) - ensure that neither data nor charts cross page breaks (one page wide).

Here is a refresher on the worksheet design guidelines.

Note: this is the same video from the month-long tutorials area if you already viewed it.

Step 5: Submission

In the discussion board area:

1. Provide a brief explanation to other students of the data you selected.  Include details such as time frame pulled, subject area, basic content of the data.   
2. In at least one paragraph, describe how you feel the data you selected relates to your field of interest.
3. Include a citation/reference for the data source.
4. Upload the spreadsheet to the Assignment 1 discussion board as an attachment.