Paper Topic:

DB Wk 5 Computer

Running Head : DB Wk 5 Computer

Ways in which a company uses advanced Excel tools , such as MIN and MAX statement , and conditional formatting to manage its business finances

Name

Course

Tutor

Date

Ways in which a company uses advanced Excel tools , such as MIN and MAX statement , and conditional formatting to manage its business finances

Companies do to keep an eye on their daily operational overheads . This is routinely done using various excel tools . A number of such tools include MIN and Max statements , conditional formatting , relative

referencing and absolute referencing . Take an example of a manufacturing concern that utilizes casual labour , for instance . The company accountant wouldn 't have a way of knowing the exact number of workers hired , but using the MAX statement , he would be able to define the extreme range of the cell . In this way he is able to tell if the number input is expected or not . Basically , these two statements are used to make conspicuous cells that appear to be in extreme ranges (Blattner 2001

The MIN statement could also be used in retail outlets to identify product lines that have lower than expected turnover or sales . This helps the shop manager to know which product lines need special attention in terms of advertising , training of staff etc , in order to boost the general bottom-line of the entire outlet . A MAX statement can also be used to pin point areas (for example , transportation ) that are incurring more expenses , so as to either...

2 pages

30.5 KB

Free sing-up