Excel provides many different ways in which to analyze data. Discuss the differe

Question

Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. That is, try an Internet search for "data analysis with excel" or use some of the methods you learned in this week's lesson. P.S. Please don't use the same methods. Show your research and creativity skills.

Assume the role of a regional manager for a retail organization looking at ways to analyze the large amounts of sales data you have. Give some examples.

Explanation / Answer

Pivot Table and Pivot Chart is used for analysis   the large number of datas.

Pivot Table is a whole data found in spread sheets, It is base for the analysis.

Next Step is pivtot chart is a considered to be a analyse tool. It is a stage for analysis the data and give the visual effects analysis.

Apart from that Sorting is very important. At any type of stage we can sort the data whether in ascending or decending order, Single column wise or multiple column wise.

Conditional formatting and if options is also very important, large amount of data condition formating and if options is most useful according to the needs and different the sales according to the value, year, etc.

Solver: Now- a-days, latest version is considered is excel solver. It is having ability to give the optimal solution.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.