Our Services

Get 15% Discount on your First Order

To complete this assignment, you will need the assignment you

May 7, 2022

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.

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.
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.
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
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.
Now apply conditional formatting to your sales data to highlight any month with a value less than $4,000.
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.
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.
Finally, go back to Sheet4 and create a clustered column chart of your data.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

USC Health & Medical A Male with Shortness of Breath Soap Nursing Assignment Help

Write a soap note using this information and the template below: 73 year old Hispanic male comes into the clinic with complaints of a cough that started 5 days ago, shortness of breath, chills and a temperature of 101.2. He has not taken any medications. Problem-Focused SOAP Note Format Demographic

Pick 3 interesting entities for self-driving cars and draw a

Pick 3 interesting entities for self-driving cars and draw a ER model. Do not use customers and sales as entities but rather technology they use. Provide domain specific attributes that are needed by the company as part of its data in order to conduct its business. Have two different types

With ToysRUs closing having for closure for most of the

With ToysRUs closing having for closure for most of the location through the US, many toy companies are facing the same thing. Struggling to keep up with technology and keep interest along with the draw back still being felt from COVID-19. Major innovations to help the market were being tested

Think back to your grade school days and the kinds

Think back to your grade school days and the kinds of students who were disciplined in some way (e.g., sent to the office, given detention, suspended, expelled). Pinpoint a student or a group of students who fits that description. Respond to the following in a minimum of 175 words:

Respond to the following in a minimum of 175 words:

Respond to the following in a minimum of 175 words: What are the Adlerian assumptions of human nature? Do you agree or disagree with these assumptions? Why or why not? Support your response with examples and relevant details. What are three Adlerian concepts that relate to these assumptions?

For this assignment, explore the different types of leadership styles.

For this assignment, explore the different types of leadership styles. In a 10-12-slide PowerPoint discuss which approaches are most effective for a health care setting and why. For the presentation of your PowerPoint, use Loom to create a voice-over or a video. Refer to the Topic Materials for additional

HCR 210 Week 1 DQs

This pack of HCR 210 Week 1 Discussion Questions shows the solutions to the following points: DQ 1: Using the Internet for information about medical records standards, what are three ways you can ensure that you maintain standard measures of performance when you work in records management?DQ 2: Select an

Health & Medical Question Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor, my responsibility is to create meaningful and relevant assignments for college students, design and deliver lectures, evaluate their performance, and provide constructive feedback through examinations and assignments. Through these activities, I aim to enhance students’ knowledge, critical thinking skills, and ability

UMGC Adopting Electronic Health Records at A Hospital Nursing Assignment Help

I’m working on a health & medical writing question and need the explanation and answer to help me learn. Imagine you are the Chief Information Officer (CIO) of a local healthcare facility and plan to implement Electronic Health Records (EHR). Beside successful implementation, its effective application by the users (doctors,

1. Read and summarize chapter 24 of the Financial Management

1. Read and summarize chapter 24 of the Financial Management book in at least 500 words. – Answer the following questions as well: – Explain “free cash flow.” – How is it calculated? – What is a statement of cash flow? CHP24 ; Cash Flow Analysis n objective of financial

Read the case. Write 5-7 page executive summary on the

Read the case. Write 5-7 page executive summary on the case, including answers to the following questions: What are the main arguments that Sarah is trying to counter? That is what are the reasons and rationalizations she needs to address in deciding how to handle the meeting with Paul Henley?

hat has happened to Sears department stores? Founded in 1886

hat has happened to Sears department stores? Founded in 1886 as a small mail-order catalog company, the iconic retailer grew to be a national chain of department stores that every suburban mall wanted as its important anchor store. Up until the 1990’s Sears was the largest retailer in the

Creating a Use Case In the textbook, Systems Analysis and

Creating a Use Case In the textbook, Systems Analysis and Design in a Changing World, refer to the RMO CSMS marketing subsystem Figure 3-10d on page 83. Write a paper in which you research use case diagrams: Create a diagram using Visio, Word, or your choice of program that

ASP case study in Organizational Development

Read the ASP case study in Organizational Development.a choose any three of the following topic areas that we have covered throughout the course to apply to the case study. Values and Ethics: How would the values and ethics of OD help you decide what to do in this case? Contracting:

stroke

The assignment requires you to select a disease process covered in class and write a 3-page paper using evidence-based practice guidelines. You are to choose a diagnosis from the NUR 140 content. Then, discuss the promotion of health, and interventions/treatments that are recommended to reduce hospital re-admission as supported by

Assignment Content You have arrived at your course project. Begin by selecting a topic from the following list: Determinants of HealthOrganization Structures in Health CareGroups and Teams in Health Nursing Assignment Help

Assignment Content You have arrived at your course project. Begin by selecting a topic from the following list: Determinants of Health Organization Structures in Health Care Groups and Teams in Health Care Recruiting and Retaining Health Care Staff Leadership in Health Care Motivating Health Care Employees Managing Change in Health

Negotiation – Private Equity – “Getting to Yes” book

Negotiation Paper – Private Equity: Leveraged Buyouts Assignment Questions After reading the book by Roger Fisher, William Ury and Bruce Patton, Getting to Yes; Negotiating Agreement Without Giving In, Second Edition; Penguin Books, 1991, please write a paper no more than 700 words, typed double spaced that addresses the following

Health & Medical Uncovering Bias in Narratives Discussion Nursing Assignment Help

For this discussion, reflect on what you have learned about your research question and the historical event and current event you chose. To ensure an interesting discussion, you are encouraged to think creatively about your initial posts and extend the points made by your peers. It is also important to