Fill in order details

  • Submit your instructions
    to writers for free!

Chat with the writer

  • Chat with preferred expert writers
  • Request a preview of your paper
    from them for free

Editing

  • Project edited by the quality evaluation department

Download Your Completed Project

  • Download the completed project from your account or have it sent to your email address

To complete this assignment, you will need the assignment you completed last module that you saved as BA132_LastName_SalesData.xlsx (or you can download the original assignment

To complete this assignment, you will need the assignment you completed last module that you saved as BA132_LastName_SalesData.xlsx (or you can download the original assignment here (Links to an external site.)) and a new workbook you can download here (Links to an external site.). Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.

  1. Open both workbooks. Save the new Module 7 file to the Rowan folder on your desktop as BA132_LastName_YearlyTrends.xlsx, replacing “LastName” with your own last name. (Example: BA132_Hywater_Memo) It is a good idea to save your work periodically.
  2. First, we need to combine the information into a single workbook. Add a new worksheet to the Module 7 file and copy the table from the Module 6 assignment to that new tab. Name the new tab “2014”. Be sure to set the number type to currency.
    A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The auto fit column width has been applied.
  3. Add another new worksheet. Now we want to set up the spacing for the table we are about to make. Merge the 1 and 2 cells of column A, B, C, D, and E individually (so A1 and A2 merge, B1 and B2 merge, etc). Then name the cells as shown in the list below and center the text in those cells.
    A = Month
    B = 2012 Sales
    C = 2013 Sales
    D = 2014 Sales
    E = Monthly Trends An excel sheet with content in cells A1, B1, C1, D1, and E1. A1 is representing the months, B1 is representing 2012 sales, C1 is representing 2013 sales, D1 is representing 2014 sales and E1 is showing the monthly trends.
  4. Copy the following columns of data over in order: “2012 Sales Total,” “2013 Sales Total,” and “2014 Sales Total.” Remember, you can just copy and paste each column in order, using the columns you have already labeled. When you autofit the column to the data width, your header cells will change.An excel sheet with content in cells A1, B1, C1, D1, and E1. A1 is representing the months, B1 is representing 2012 sales, C1 is representing 2013 sales, D1 is representing 2014 sales and E1 is showing the monthly trends. Cells A1, B1, C1, and D1 have data entered in them down to line 14.
  5. Now apply conditional formatting to your sales data to highlight any month with a value less than $4,000.
    An excel sheet with content in cells A1, B1, C1, D1, and E1. A1 is representing the months, B1 is representing 2012 sales, C1 is representing 2013 sales, D1 is representing 2014 sales and E1 is showing the monthly trends. Cells A1, B1, C1, and D1 have data entered in them down to line 14. Cells D4, C6, D8, and D12 have been highlighted in red.
  6. Next, in the ‘Monthly Trends’ column, create a sparkline that shows performance for that month over the three years. Remember, after you create the first sparkline in January, you can just copy and paste into the other cells.
    An excel sheet with content in cells A1, B1, C1, D1, and E1. A1 is representing the months, B1 is representing 2012 sales, C1 is representing 2013 sales, D1 is representing 2014 sales and E1 is showing the monthly trends. Cells A1, B1, C1, and D1 have data entered in them down to line 14. Cells D4, C6, D8, and D12 have been highlighted in red. The E row has been filled in down to line 14 with small graphs showing the monthly trends.
  7. Return to the individual tabs for each year. For each individual year of data, sort the sales total “Z to A” so that the month with the highest sales is at the top. When you chose the “Sort” option, be sure to “Expand the Selection.” That will make sure that the months change as well. The screenshot below shows you only what 2012 should look like, but when you finish you should see October as the highest in 2012, August for 2013, and May for 2014.A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The auto fit column width has been applied. The total sales values have been re-ordered to display the highest earning months.
  8. Finally, go back to Sheet4 and create a clustered column chart of your data.An excel sheet with content in cells A1, B1, C1, D1, and E1. A1 is representing the months, B1 is representing 2012 sales, C1 is representing 2013 sales, D1 is representing 2014 sales and E1 is showing the monthly trends. Cells A1, B1, C1, and D1 have data entered in them down to line 14. Cells D4, C6, D8, and D12 have been highlighted in red. The E row has been filled in down to line 14 with small graphs showing the monthly trends. A large graph has popped up representing all the data in the excel sheet.

Place your order now for the similar assignment and get fast, cheap and best quality work written by our expert level  assignment writers.To complete this assignment, you will need the assignment you completed last module that you saved as BA132_LastName_SalesData.xlsx (or you can download the original assignment

Use Coupon Code: NEW30 to Get 30% OFF Your First Order

Answered Questions:

[ANSWERED] Identify a quality improvement opportunity in

[ANSWERED] Develop an interview questionnaire to be used in a family-focused functional assessment

[ANSWERED] Select a family, other than your own, and seek

ANSWERED! In this project you will select an organization or

[ANSWERED] What is the significance of the product lifecycle

ANSWERED! How can different types of attributions and

ANSWERED!! Lily is a 20-year-old student at

ANSWERED!! What details did the patient provide regarding their chief complaint and symptomology to derive your differential diagnosis? What is the duration and severity of their symptoms?

ANSWERED!! In 4 or 5 sentences describe the anatomy of the basic unit of the nervous system

ANSWERED!! Describe measures that you would take as a nurse to assist clients with health promotion measures to incorporate exercise and physical activity into their lives

ANSWERED!! Assess the characteristics of the medical care culture that encourage the latter approach.

ANSWERED!! Identify two things that surprised you about the results and one idea you believed prior to conducting the Assessment that was confirmed.

ANSWERED!! Submit a summary of six of your articles on the discussion board. Discuss one strength and one weakness to each of these six articles

Design an educational simulation scenario incorporating the use of an electronic health record (EHR) and answer the following questions

Write a fully developed and detailed APA essay addressing each of the following points/questions. There is no required word count; be sure to completely answer all the questions for each question in detail.

Answered! Read Case 2.1: Hacking into Harvard, located on page 71 in your textbook. As applicants began to defend themselves against

Answered: Vince Corporation has current assets of $300,000 and current liabilities of $175,000. Compute the effect of each of the following transactions on Vince’s current ratio:

What our customers say
_____

Ishita M.Ishita M.
Great Job! Thank you so much for your work. You got it done faster than I imagined and everything is perfect. Will definitely be using you again!
Megan J.Megan J.
"As a wife, mother, and full-time student, I was struggling to try to go back to school and take care of my responsibilities. Sometimes you just need a little help, and I appreciate all the help I have gotten from Academic Research Bureau. My papers are on-time and the writers are easy to work with. Thanks for the support!"
Rajab M.Rajab M.
Universitywritingservices.com has saved me a lot of time. I was tired of taking the same classes many times over again. As an ESL student, my professors were taking points off of my assignments for my grammar mistakes. It made it very hard to feel encouraged to continue with my studies. Thankful for having found an answer for better grades."
Frank N.Frank N.
As a working student, I just really don't have the time to write paper after paper and complete assignment after assignment. Working full-time and going to school was nearly impossible until I was able to feel comfortable with the writers on this site. They make me feel secure enough to trust them with my papers. While I'm busy with life, they are busy writing my papers. They always do an outstanding job!
Courtney B.Courtney B.
Thank you! You were really patient with me and my needs. This was my first time using you guys, however, I will definitely be using you again!
John H.John H.
I cannot tell you enough how amazing your company is! Your writers are superb, on time, excellent content, so very thankful you reached out to me that day! Lifesaver for sure! Couldn’t be happier with the results I’ve gotten from my first 2 papers with you, I have 4 papers left to go and I’ll be using your company for them all!
Rebecca T.Rebecca T.
After I ordered a dissertation from your writing service, the first paper that I was given did not met my professor’s demand. I set the paper on revision and the writer made the revision for free meeting all my requirements and I was very satisfied
Thomas R.Thomas R.
I was shocked by how your writers managed to deliver my paper on time, and I was among the best in our class in that paper. Thank you so much and I will never hesitate to use you
error: protected!!