Microsoft Excel Data Analysis Chapter

Open, View, and/or
Download this Document

Total Length: 870 words ( 3 double-spaced pages)

Total Sources: 0

Page 1 of 3

Excel Q's

(TCOs 2, 3, 7 and 9) You currently work for a home improvement store.

Your company is growing and is considering expansion. The company currently has three locations (East, West, and Central) in one state and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you are tasked with analyzing current sales.

The company classifies the sales at the stores into two categories. They are either retail sales to home users, or wholesale to contractors. You want to determine whether the growth is in the retail sales, the wholesale sales, or equally in both to better develop an expansion strategy.

The data from these operations should be combined in the easiest way possible. If the data sample is small it might be easiest to just cut and paste the data into one file. However, if the three locations have a large data set then the "import" data feature can be used to integrate the data. Once the data is combined into one file then the sort feature can be used to isolate the various items of interest. Once the categories are developed then functions such as autosum can be used to total up the different categories of interest.

Stuck Writing Your "Microsoft Excel" Data Analysis Chapter?

View All Our Example Microsoft Excel Data Analysis Chapter

Have A Custom Example Essay Written



* A - (TCO 9) The data has been provided to you in one combined .csv file showing the sales for all three stores for the last three years. The stores all categorize sales as either retail or wholesale, but they are not consistent in how they do this. The West location uses a code of R. For retail, or W. For wholesale. The other locations use RS for retail sales or WS for wholesale sales. Explain the steps involved in converting the information from the .csv file to Excel, and what steps you will take to ensure the data is usable for your purpose.

The easiest way to achieve this is to use the sort function to isolate the data points that you would like to rename. Then you can pick the first point, rename it, and then drag it to replace the rest of the data points. However, in a huge data set it may be more efficient to create a rule to automatically transfer the data.

* B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data.

Because you have all sales records, you want to summarize it by month.

Again, you could use the data sort tool….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Microsoft Excel" (2011, December 06) Retrieved July 4, 2025, from
https://www.aceyourpaper.com/essays/microsoft-excel-115822

Latest MLA Format (8th edition)

Copy Reference
"Microsoft Excel" 06 December 2011. Web.4 July. 2025. <
https://www.aceyourpaper.com/essays/microsoft-excel-115822>

Latest Chicago Format (16th edition)

Copy Reference
"Microsoft Excel", 06 December 2011, Accessed.4 July. 2025,
https://www.aceyourpaper.com/essays/microsoft-excel-115822
   

Open, View, and/or
Download this Document
order custom essay example