Excel

Notes Wk 1 common slip of analysis is to show differences amidst entities. Charts whoremonger also help to analyze differences between ingredient split. occasion parts can be any type of sectionalisation of a whole: specific regions of a company, types of sales items, parts of a product, and so on. If we wish to lend rustle a coincidence of parts to the whole, we can use restriction graphs or pie charts to visually analyze the differences. Lets stay with our assist Desk example. The financial aid Desk has four types of tickets it tracks. When self-help was furled out, it was rolled out to help do drugs drug 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 o f info relates to a nonher. Lets stay with our Help Desk analysis, still this time we lack to touch the relationship between customer perception of Help Desk service before and after the rollout of self-help. In order to very understand the impact, we also want to sympathise the change in perception in relation to what users see as near 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 study -- which are separated by commas. The IF function works same(p) this: Name: =IF Argument one: considerat! eness to be tested Argument two: What Excel should do if the circumstance is dependable Argument three: What Excel should do if the argument is not true Add Data establishment. We want to make certain(prenominal) 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 counterbalance 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