Microsoft Excel is a software that allows users to organise and calculate data with formulas using a spreadsheet system broken up by rows and columns. This software is often used for processing great amounts of data. The availability of data is expected to increase the coming years, which means that the demand of technical skills will be significantly higher for us students. It is our task to find out how data can be processed in the best possible way for further usage of it.
What is a function?
A function is a type of formula that allows the user to perform mathematical, statistical and logical operations more easily. You can write a formula into a cell, or you could use Excel’s preset formulas that they term functions. To employ this function you start with writing “=” in a cell. A popular formula used within Excel is “=sum()” which sums up chosen cells. Another characteristic one is “=AVERAGE()” who sums up the average of chosen cells.