Excel

Notes Wk 1 common take downt of analysis is to show differences amidst entities. Charts whoremonger also help to analyze differences between luck split. occasion parts can be any type of sectionalisation of a whole: specific regions of a company, types of gross sales items, parts of a product, and so on. If we wish to achieve convolute a coincidence of parts to the whole, we can use proscribe graphs or pie charts to visually analyze the differences. Lets stay with our function Desk example. The supporter Desk has four types of tickets it tracks. When self-help was furled out, it was rolled out to help dose users having login problems. Therefore, we may wish to key out the difference in proportion of tickets for login problems after we rolled out the self-help functionality. Heres a chart we might create. Charts to Show Relationships: Some charts, much(prenominal) as scatter charts and radio detection and ranging charts, allow us to entrance how one set of entropy relates to a nonher. Lets stay with our Help Desk analysis, still this time we postulate to touch the relationship between customer perception of Help Desk service before and after the rollout of self-help. In order to real understand the impact, we also want to take hold of the change in perception in relation to what users see as more or less important. We can use a radar chart to see the relationship clearly.

Wk 2 Excel functions have several(prenominal) components--a name (such as IF) and one or more than arguments -- or required pieces of schooling -- which are separated by commas. The IF function works manage this: Name: =IF Arg! ument one: considerateness to be tried Argument two: What Excel should do if the circumstance is trustworthy Argument three: What Excel should do if the argument is not true Add Data verification. We want to make genuine that the user adds correct data. We can use Excels Data Validation tools to express the user what kind of data to add--and we can even proscribe them from adding incorrect information. In this example, we want to prevent the user from claiming more than 80 hours in a week, since this is against company...If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper