Week 9: Clear

Is there anything Excel cannot do? Really, Excel is such a vital tool to have in the business world. My father and I own our company and we use Excel spreadsheets for just about everything. We use Excel for our estimating. Instead of buying software, we created an elaborate workbook which does 90% of the calculations for us. We just have to enter the measurements and the type of product, Excel will spit out a price for us. We use it to track time of our employees, estimate taxes due to the payroll company. I used it to do a linear regression of the permits pulled over the last year in Duval County to see if there was a relation to price to squares (the quantity we sell in roofing).

Excel is a magnificent tool to have for your business, but if you do not understand Excel it goes to waste. It is easy to jump on Excel and do simple functions and create simple tables. To get the full use of the program you need to understand Pivot Tables, how to use all the functions, absolute cell referencing, changing the theme of you worksheet and all the other options to make the worksheet jump out.