(Solution) COMP 150N Week 6 Discussion: How do we analyze data in Excel?

Required Resources

Read/review the following resources for this activity:

  • Assigned textbook reading
  • Minimum of 1 post using technologies such as Kaltura, PowerPoint, or any other tool to explain the concepts learned during the week.
  • Minimum of 1 scholarly source

Initial Post Instructions

This week we went over the different tools that we have available to analyze data in Excel. Share what you learned from this week, what was most interesting, or even what was the most challenging feature for you. Also share as to how you came up with your solutions in the assignments and the type of analysis you decided to use.

Follow-Up Post Instructions

Respond to at least one peer. Further the dialogue by providing more information and clarification. This is a hands-on course and it is expected for you to use more visuals such as screenshots and video. Make sure to utilize that since it is a requirement.


This week was very educational. We learned how to use additional features of the Excel software. For instance, we learned how to sort and filter data, created charts, use the IF function, create pivot tables, exercise conditional formatting, and how to use the quick analysis tool. Before this week, I had only used the charts and IF function. This was my first time learning about and using pivot tables, conditional formatting, and altering the cell borders, shading, and formatting.

Please click the icon below to purchase full answer at only $10