Analyzing Data

Analyzing Data

Analyzing data is an important skill for any professional to possess. The existence of data in its raw collected state has very little use without some sort of processing.
Examples of this are the answers to quiz questions that are collected from students. If no further examination of the quiz answers is undertaken, you will not know if the students passed or failed. Further, you would not know how one student performed as opposed to another. Excel can assist you in this analysis of data. You can grade the students’ results and chart their progress. You can even allow the modification of data through web pages. If you teach, you keep student data; so make the most of your available data and use it efficiently by evaluating that data with Excel.

• Filter lists using AutoFilter
• Sort lists
• Insert and modify formulas
• Use statistical, date and time, financial, and logical functions
• Create, modify, and position diagrams and charts based on worksheet data