Using applications like Excel and Numbers can be extremely beneficial just for the sake of organization, but it could also help me save money. For example, one could be reviewing the information and notice that too much money was spent on buying supplies. After realizing this we could look up the different people we buy our raw materials from and try to cut down. After looking this information up we could try to work out some type of deal, where my company could buy a certain amount of parts and receive a lower price based on consistency.
Excel and numbers have many resources within their programing. The most helpful to my product would be the use of the functions. These functions allow anyone to put formulas in cells to do calculations. One function that can be extremely helpful is the conditional formatting. This allows you to set rules for cell formatting. A specific way I could use conditional formatting would be to have one cell represent either positive or negative information regarding my money available versus the calculated expenses.
When my available money is less than my expenses I could have the cell light up in a solid red to draw attention. When the available money is greater I could have the cell light up in a solid green to symbolize everything is ok.
No comments:
Post a Comment