I am keen to encourage individuals and organisations to explore using advanced MS Excel formulas and functions, in conjunction with Excel VBA programming, to develop customised spreadsheet applications that will solve typical problems end_users encounter daily in trying to record/analyse data and generate reports.
How A Well Known Corporate Multinational Used Spreadsheet Tracking/Automation To Repeatedly Cut Spending _ And Increase Profits. During my graduate training(while in paid employment), I was redeployed from Guinness Nigeria Plc's corporate headquarters training office(in Lagos) to the Benin brewery training department (in Edo state), where I was assigned the _ additional _ job of using a custom Lotus macros driven Variable Cost Analysis spreadsheet application to generate brewery reports for dispatch to headquarters.
So, (when considering the automation I speak about) do not think about spreadsheet documents containing one or two click_able buttons that allow a user print a page or copy some cells from one sheet to another. Instead, I want you to picture an application(or Entreprise Information System) that customises the appearance of your spreadsheet workspace(to take advantage of maximum screen capital available on your PC), and offers you custom "floating" data entry forms.
This last point in my opinion is ONE major benefit you must seek to extract, if you choose to engage the services of a developer. S/he should be able to help you develop (in_house) expertise needed to maintain the application AFTER s/he is gone. If you fail to ensure this, all your cost_savings from using the application might end up being spent paying the developer to maintain the application over time in the future!
spreadsheet templates for business
spreadsheet templates for tracking
uses of spreadsheet