Week 5: Clear

This week Microsoft Excel was introduced. We learned how Excel works, for what it can be useful and some of the numerous functions were illustrated. Although I have already worked with Excel during my study there were some functions explained which I have not known before. One of these was the function "right". With the help of this function you can tell Excel to copy parts of a cell to another cell. If e.g. one cell contains a first and a last name and you want work further only with the last name in another cell, you can use the function "right", indicate how many characters of the original cell you want to rewrite in the other cell, and, thus you can seperate first and last name from each other. The same also works with "left", this time only the left part of a cell is used. For indicating how many characters you want to copy, there is a further function called "find" which helps you identify the number of characters written until a certain symbol, like e.g. a comma.

I think this function is rather important, because in today's business environment it is all about digital information, which is compiled by one person and edited by another worker. Often the second person needs to focus on a different aspect of a particular document and thus needs to seperate data which may be written in one cell. Thus, with the help of these functions, you can align different data formats to let operations run smoothly.