Excel Essay

1717 Words7 Pages
Notes Wk 1 common type of analysis is to show differences between entities. Charts can also help to analyze differences between component parts. Component parts can be any type of breakdown of a whole: specific regions of a company, types of sales items, parts of a product, and so on. If we wish to see a comparison of parts to the whole, we can use bar charts or pie charts to visually analyze the differences. Let's stay with our Help Desk example. The Help Desk has four types of tickets it tracks. When self-help was rolled out, it was rolled out to help users having login problems. Therefore, we may wish to see the difference in proportion of tickets for login problems after we rolled out the self-help functionality. Here's a chart we might create. Charts to Show Relationships: Some charts, such as scatter charts and radar charts, allow us to see how one set of data relates to another. Let's stay with our Help Desk analysis, only this time we want to see the relationship between customer perception of Help Desk service before and after the rollout of self-help. In order to really understand the impact, we also want to see the change in perception in relation to what users see as most important. We can use a radar chart to see the relationship clearly. Wk 2 Excel functions have several components--a name (such as IF) and one or more arguments -- or required pieces of information -- which are separated by commas. The IF function works like this: Name: =IF Argument one: Condition to be tested Argument two: What Excel should do if the condition is true Argument three: What Excel should do if the argument is not true Add Data Validation. We want to make certain that the user adds correct data. We can use Excel's Data Validation tools to tell the user what kind of data to add--and we can even prevent them from adding incorrect information. In this example, we

More about Excel Essay

Open Document