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.
Get Maximum Returns On Your Investment In Spreadsheet Automation By Developing "In House" Expertise. Organisations can deliberately expose their employees to learning events(or self_help tutorials) on spreadsheet solutions development. Such employees can then be challenged to develop in_house solutions that effectively address the business' peculiar data analysis/report_generation needs as they arise.
Spreadsheet Tracking As A Crucial Element For Business Development. There are ways you can use spreadsheets to record and track materials usages/stocks, product sales, and other business data such that discrepancies will be easily detected when they do occur. The use of spreadsheets when properly done, can help to uncover the cause(s) of "losses" in virtually any aspect of a business operation.
The claims I make above are NOT exaggerated. They are in fact based on my personal experiences doing the foregoing (a). As an manager in the challenging, fast_paced manufacturing work environment of a corporate multinational (b). As a solutions developer for individuals and businesses who use MS Excel for their work.
uses of spreadsheet