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.
One Possible Application: Plotting a pie chart based on income contributions from all your products and services(daily, weekly or monthly), and reviewing the automatically computed percentages/visual pie slices, can give very illuminating insight.
At times, they would prefer to click a button that says "Print ABC", or "Print XYZ" report, instead of having to crawl all over the huge spreadsheet(and get "lost" every now and then), to highlight and print different report pages. Using a custom built data entry form to make data entries into 14 different cells in different parts of a table(at the same time/with one click) would, for them, be "heaven" compared to making the entries one at a time.
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.
what is a spreadsheet used for
types of spreadsheet
spreadsheet templates for small business