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.
Spreadsheet Automation Facilitates EFFORTLESS Data Handling, Analysis & Report Generation! Sometimes people don't really care about learning(or using) all the "cool' advanced functions, formulas and techniques in the spreadsheet application they use for their work. They just want to punch in their relevant raw data _ at any time _ and immediately see the computed results generated by the spreadsheet in a manner that can facilitate their important decision making.
You will find this article of considerable reading value, if you belong to at least ONE of the following spreadsheet user categories: Owners of Small Businesses _ Restaurants/Bars, Hotels, Hospitals, Factories, Consultants etc; Decision Makers/Job Holders in Corporations _ Materials Managers, Sales/Marketing Analysts, Financial Analysts/Accountants, Project Engineers; And Anyone desiring to make BETTER sense _ and use _ of data!
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.
spreadsheet templates for tracking
excel budget templates